Load script : CSV file with single quote in numeric field

[pattyccia]

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

[marcus_sommer]

Make sure that msq is disabled within the file-format, like suggest from @PrashantSangle per:

(txt, utf8, embedded labels, delimiter is ';', no quotes); 

[pattyccia]

Sorry, I was probably replying to you when it arrived 😅

Thank you very much... it works fine!

Patrizia