Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
pattyccia
Contributor III
Contributor III

Load script : CSV file with single quote in numeric field

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:

pattyccia_0-1701420872485.png

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

Labels (1)
11 Replies
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
Contributor III
Contributor III
Author

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

Thank you very much... it works fine!

Patrizia