Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

dmpilars
New Contributor II

Eliminate Quotes of .txt

Hi People

I'm working with Qlik Sense and I have a format problem. I have a QVD table result, I need to convert this QVD to .txt and I do that but in the resultant .txt, the quotes are includes when a coma (" , ") appears, like this:

ABCDEFG00000000001

"ABCDEFG1250,876807"

ABCDEFG00000000002

The info in my .txt is like that, numbers separate by comas... I try transform the .txt with Replace(reporte, '"', ' ') but it's like that not exist because not replace nothing!!!!! I need the results with comas and without quotes.

Please Help Me!!!!

Thanks

1 Solution

Accepted Solutions
zebhashmi
Valued Contributor

Re: Eliminate Quotes of .txt

try

PurgeChar ( reporte,'"' )

11 Replies
agigliotti
Honored Contributor II

Re: Eliminate Quotes of .txt

how did you convert from QVD to TXT ?

dmpilars
New Contributor II

Re: Eliminate Quotes of .txt

I read QVD table, I make another transformation and I save again but in this time in .txt format whit

STORE Formato351_Final into 'lib://4_Qvd_Modelo\Formato351_Final'.txt

agigliotti
Honored Contributor II

Re: Eliminate Quotes of .txt

let's try using the below statement:

store * from Formato351_Final into [lib://4_Qvd_Modelo/Formato351_Final.txt] (txt);

zebhashmi
Valued Contributor

Re: Eliminate Quotes of .txt

try

PurgeChar ( reporte,'"' )

dmpilars
New Contributor II

Re: Eliminate Quotes of .txt

Not work :c

dmpilars
New Contributor II

Re: Eliminate Quotes of .txt

Not work :c

agigliotti
Honored Contributor II

Re: Eliminate Quotes of .txt

could you post the final ascii file created ?

isingh30
Contributor III

Re: Eliminate Quotes of .txt

dmpilars
New Contributor II

Re: Eliminate Quotes of .txt

I can't, is confidential data!!!