Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
how did you convert from QVD to 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
let's try using the below statement:
store * from Formato351_Final into [lib://4_Qvd_Modelo/Formato351_Final.txt] (txt);
try
PurgeChar ( reporte,'"' )
Not work :c
Not work :c
could you post the final ascii file created ?
I can't, is confidential data!!!