Hi,

Anyone know how to get rid of the last delimiter in the output file when we use the UNLOAD TO statement?

i.e. The statement is UNLOAD TO 'output' DELIMITER '|'
SELECT shoes, bottoms, tops FROM closet

The results will be: running shoes|jeans|tutleneck| <- don't want this
high heals|skirt|shirt|

Please help, thanks alot!!!

try

unload to 'output' delimiter ""
select shoes,"|",bottoms,"|",tops from closet

its a bit manual ..but it may work for you.