How to remove Unwanted Special character when generating the text file.

[balrammahato204]

Hi All,

Please help me

My issue is when I am generating text file from the qlikview then i am getting random special character( " ) in my text file. Please let me know how can i remove these special character from the text file.

Please find the below example

Eg:-

"0000000080002	ISERVISXTUR"
0000000090002	ISERVISXPGH
0000000100002	ISERVISXHGA
"0000001180002	ISERVISXHUR"
0000000120002	ISERVISXKAT
0000000130002	ISERVISXPUK

Thanks and Regards

Balram Mahato

[Peter_Cammaert]

Well, I cannot force QV to not do this. Except by tricking QV into thinking it always does have something to store, like in:

:

if (trim(len(A1&A2&A3)) = 0, 'XXXXXXXXXXXXXXXX', A1 & A2 & A3) AS [Loader File]

;

Peter

[rubenmarin]

Hi Balram, If it helps I tried using an inserted space as separator and Qv didn't exported it with doublé quotes, if I used a tab character it exports values between double quotes.

Load
  A1&' '&A2&A3 as [Loader File] //Exports values without double quotes
  resident Temp;

Load
  A1&Chr(9)&A2&A3 as [Loader File] //Exports values between double quotes
  resident Temp;

Maybe the values with double quotes has a tab instead of an space as separator?