Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

how to remove quotation marks from file during import

Hi,

I'm trying to upload a .txt file and I know there are double quotation marks in several of the columns which is preventing the file from fully uploading. How can I remove the double quotes during the import process? I know it's probably within the Enable Transformation Step, but I can't figure out how to use it. Thanks for any advice.

3 Replies
Colin-Albert

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

34 is the ascii code for double quotes.

maxgro
MVP
MVP

maybe the no quotes can help you in the load

then use Colin answer

FROM

quot.txt

(txt, codepage is 1252, no labels, delimiter is ',', no quotes);

Not applicable
Author

thanks for this, but I'm not 100% clear. Do I use that replace statement in the script?  or do I use it somehow in the Enable Transformation area?