Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
ganeshreddy
Creator III
Creator 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
sunny_talwar

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
sunny_talwar

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