Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I have a load script of an csv file with a numeric field (price) where , if there isn't value, there is a single quote.
An example of field in csv:
How I can replace the single quote with nothing?
I tried with
LOAD
PurgeChar(PrezzoListino, chr(39)) as PrezzoListino,
.....
but doesn't work.
I tried also with:
LOAD
replace(PrezzoListino, chr(39),'') as PrezzoListino,
but doesn't work.
Thanks for your help.
Patrizia
Make sure that msq is disabled within the file-format, like suggest from @PrashantSangle per:
(txt, utf8, embedded labels, delimiter is ';', no quotes);
Sorry, I was probably replying to you when it arrived 😅
Thank you very much... it works fine!
Patrizia