tab delmited export

[webguy]

I very rarely do tab delimited exports. In progress whats the best method.

For example I can do this:

output stream myfile to file.txt.
for each customer:
export stream myfile delimiter "~011"
customer.cust-number
customer.cust-name.
end.
output stream excelfile close.


or this

output stream myfile to file.txt.
for each customer:
export stream myfile delimiter "\t"
customer.cust-number
customer.cust-name.
end.
output stream excelfile close.

Either way I get the doble quotes around each value.

 

[rzr]

When you use EXPORT the character data types will always be exported in quotes.

DELIMITER "~011" or DELIMITER "~t" both works the same way on windows. I'm not sure on unix/linux.. maybe it is "\t"; i have'nt tested it.

 

[webguy]

Thanks rzr. Another thread with the same topic.
http://www.progresstalk.com/showthr...&highlight=remove+quotes+export+tab+delimited