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: 
dmpilars
Partner - Creator
Partner - Creator

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
Specialist
Specialist

try

PurgeChar ( reporte,'"' )

View solution in original post

11 Replies
agigliotti
Partner - Champion
Partner - Champion

how did you convert from QVD to TXT ?

dmpilars
Partner - Creator
Partner - Creator
Author

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
Partner - Champion
Partner - Champion

let's try using the below statement:

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

zebhashmi
Specialist
Specialist

try

PurgeChar ( reporte,'"' )

dmpilars
Partner - Creator
Partner - Creator
Author

Not work :c

dmpilars
Partner - Creator
Partner - Creator
Author

Not work :c

agigliotti
Partner - Champion
Partner - Champion

could you post the final ascii file created ?

isingh30
Specialist
Specialist

dmpilars
Partner - Creator
Partner - Creator
Author

I can't, is confidential data!!!