Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

how to remove quote marks (") in the script?

Hello, the data I upload has some quote marks (""). the script stop running when it hits the data with quote marks. I am wondering if there is a way to allow the script to keep running instead of stopping. The data is only partially uploaded and I would like everything to upload.

4 Replies
robert_mika
Master III
Master III

Try

replace(<your_field_name>, chr(34),'') as your_field_name


chr(34) is "" in ASCi code

Not applicable
Author

Hi Robert, My field name is

[RCD]  in the script. that particular column contains data with quotation marks ". I am not sure how to use the data above. do I replace this line in the script with replace([RCD], chr(34),'') as [RCD] ? Thanks,


anbu1984
Master III
Master III

Yes use this replace([RCD], chr(34),'') as [RCD]

Or

Purgechar([RCD],'"') As [RCD]

robert_mika
Master III
Master III

Yes try this way.

Tak sprobuj a jak nie zadziala napisz dlaczego