Just ran into a hidden carriage retun inside the requested data. I wanted to spool to a .csv file and got garbled data.
Fix like this:
select replace (column01,CHR(10),'')||';'||replace (column02,CHR(10),'') as column_header from schema.table;
September 1, 2008
Comments Off on Query and replace carriage returns:
Just ran into a hidden carriage retun inside the requested data. I wanted to spool to a .csv file and got garbled data.
Fix like this:
select replace (column01,CHR(10),'')||';'||replace (column02,CHR(10),'') as column_header from schema.table;