Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
ganeshreddy
Contributor III

How to load mixed delimiter file?

Hi All,

I have got mixed delimeter file with tab delimeter and comma seperated fields in one file, how to load all fileds seperatly?

Pleaae find attached files.

Regards,

Ganesh

1 Solution

Accepted Solutions

Re: How to load mixed delimiter file?

Try this:

new:

LOAD SubField([sn lon], Chr(9), 1) as sn,

  SubField([sn lon], Chr(9), 2) as lon, 

    name,

    city,

    country

FROM

test.txt

(txt, codepage is 1252, embedded labels, delimiter is ',', msq);


Capture.PNG

View solution in original post

1 Reply

Re: How to load mixed delimiter file?

Try this:

new:

LOAD SubField([sn lon], Chr(9), 1) as sn,

  SubField([sn lon], Chr(9), 2) as lon, 

    name,

    city,

    country

FROM

test.txt

(txt, codepage is 1252, embedded labels, delimiter is ',', msq);


Capture.PNG

View solution in original post