Import CSV with \, delimeter?

Senor_Dai — Tue, 02 Mar 2021 09:22:09 GMT

HI, Im trying to import a csv where the delimiter is \, eg:

Unit\,User\,Profits\,

When importing using the wizard I can only select \ or , as a delimiter. Is it possible to select both?

Many thanks,

Senor Dai

Re: Import CSV with \, delimeter?

Taoufiq_Zarra — Tue, 02 Mar 2021 10:00:35 GMT

@Senor_Dai you can keep one delimiter like ',' and do :

LOAD left("Unit\",len("Unit\")-1) as Unit, left("User\",len("User\")-1) as User, left("Profits\",len("Profits\")-1) as Profits FROM C:\Users\t.zarra\Desktop\TEMP.csv (txt, utf8, embedded labels, delimiter is ',', msq);

from this file:

the output:

topic Import CSV with \, delimeter? in QlikView

Import CSV with \, delimeter?

Re: Import CSV with \, delimeter?