How to load mixed delimiter file?

ganeshreddy — Mon, 23 Nov 2015 20:34:21 GMT

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

Re: How to load mixed delimiter file?

sunny_talwar — Mon, 23 Nov 2015 20:38:09 GMT

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);