Special Characters in the excel makes makes the data truncated when we load into the Qlikview

[naveen341]

Hi,

  I have an excel file of shipment Details .

  In the Address or the name fields It contains a different kinds of special characters like &,Alpha,Betta and many more .

  example: "Dißerner Bruch 81"

The problem when I import the file into QlikView as my data source, the left part along with the special character is truncated and displayed as

  "erner Bruch 81".

I cannot edit the excel Files as it contains millions of record on daily basis. But one thing I noticed is when I copy or do "Save as " the same file then it reads the complete data as "Dißerner Bruch 81"

  All characters before the "ß" are truncated and couldn't read by QlikView.

  Any help on getting through this?

Thanks in Advance

Regards,

Naveen.

[Chanty4u · Accepted solution]

hi replace that field by empty string

Replace( Field, '_x000D_'  ,'')

[Gysbert_Wassenaar]

Are you sure your source document is an excel file and not a csv file? It sounds like it is a csv file with unicode characters and you try to load it as an ascii file.

[naveen341]

HI Chanty .

It is still the same .

Any other suggestions?

[naveen341]

HI Wassenaar.

Yes i am sure its a excel file only

[Chanty4u]

try to create

Replace(Your Field,'ß',' ') as Youfield,

[Gysbert_Wassenaar]

Can you post the load statement that loads that file?

[naveen341]

BUt ß is not the only special character in that excel i have many such kind of special characters

[naveen341]

LOAD [Shipment Details],

     [Shipped (ASN)],

     [Shipment ID],

     [Delivered to Final Dest.],

     [Purchase Order],

     [Final Destination (Shipment)],

     [Final Destination Addr1],

     [Final Destination City],

     [Final Destination Country],

     [Final Destination Postal Code],

     [Final Destination State],

     Status,

     [BL/AWB/PRO],

     Container,

     [Pro #]

FROM

(ooxml, embedded labels, table is [View Shipments]);

[naveen341]

i dont want to delete or replace the special character how can i get the output as "Dißerner Bruch 81 " ?