Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
We are writing a table into txt file using the store command. e.g store ExtractofAddress into 0002 - Addresses.txt(txt); This is working fine.
But when if the value contains comma (','), the the value is starting and ending with double quotes (' " '). We want the data without double quotes.
Is there any solution for this ?
Attached the sample qvw
Thanks,
Sijo
Try like below,
Store Name into test.txt (txt, codepage is 1252, no labels, delimiter is '\t', no quotes);
Ignore the red line in script window.
May be store like this:
Store Name into test.txt(txt, delimiter is '|')'
Thanks
This is working for comma, but I got double quotes for " ' ". Is there any way we can avoid double quotes coming due to special character.
This is working fine in my test data. Could you post some sample file, so that we can check.?
Please find the below sample data
Name |
Arun Sane |
Prasant,Saha |
Vika's Taunk |
Dixon$ Devassy |
John Honnai* |
Thanks,
Sijo
Thanks Sunny.
Thanks