Qlik Community

New to Qlik Community

Discussion board for questions on how to use Qlik Community and its features.

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

Re: how to remove quotation marks from file during import

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

34 is the ascii code for double quotes.

MVP
MVP

Re: how to remove quotation marks from file during import

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

Re: how to remove quotation marks from file during import

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?

Community Browser