Import CSV with \, delimeter?

[Senor_Dai]

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

[Taoufiq_Zarra · Accepted solution]

@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: