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

[#1]

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.

[robert_mika]

Try

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

chr(34) is "" in ASCi code

[#3]

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]

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

Or

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

[robert_mika]

Yes try this way.

Tak sprobuj a jak nie zadziala napisz dlaczego