topic Re: how to remove quote marks (") in the script? in QlikView

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

Thu, 02 Apr 2015 22:25:04 GMT

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.

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

robert_mika — Thu, 02 Apr 2015 22:42:00 GMT

Try

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

chr(34) is "" in ASCi code

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

Thu, 02 Apr 2015 22:57:22 GMT

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,

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

anbu1984 — Fri, 03 Apr 2015 03:48:51 GMT

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

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

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

robert_mika — Fri, 03 Apr 2015 05:04:18 GMT

Yes try this way.

Tak sprobuj a jak nie zadziala napisz dlaczego