Replace Line Breaks?

[lmf232s]

Im using Enterprise Manager to export the results of a query to a .csv file.

All is good except for one of the fields that im exporting is a text field that contains line breaks.

When you view the .csv file with in excel all is fine except where the line breaks occure in code. It causes the line of text (after the line break) to appear on a new line.

I would preferr to remove the line breaks and just have 1 long line of text.

Any ideas on how to remove the line breaks?

[russell]

since u are using EM, make a dts package to do the export. in the data pump task, type in the query

SELECT Replace(Replace(fieldName, char(10), ''), char(13), '') as fieldName,
otherFields...
FROM Table
...