Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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);
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);