topic Loading Delimited File with different delimiter in QlikView

Loading Delimited File with different delimiter

Tue, 23 Sep 2014 10:43:17 GMT

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 — Tue, 23 Sep 2014 10:48:52 GMT

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

delimiter is '<<'

Regards