Loading Delimited File with different delimiter - Qlik Community

Report Inappropriate Content · ‎2014-09-23

Hi,

I am trying to load a .dat file is delimited by « which has the ASCII code of 171.

Qlikview doesn't list the ASCII code for « in the Customer delimiter drop down

Any thoughts on how do i get round this issue?

Thanks

Stuart

PrashantSangle · ‎2014-09-23

Hi,

I am not sure but you can try like

Load it as you load .csv file

and made changes in script at end line

like

delimiter is '<<'

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂