Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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

11 Replies
agigliotti
Partner - Champion
Partner - Champion

Yes i can imagine, but you can scramble it just to see how the text file is formatted.

dmpilars
Partner - Creator
Partner - Creator
Author

I prove this again and the function works,  but when quotes are includes from the .qvd to .txt transformation, not recognized the character and not eliminate. For now, the only solution that I can run is convert " , " in " . "