Issue with parsing multiple lines

[Vijay Chaganti]

Hi,
 I am reading a database column which has data stored as a multiline text.
 How do I make that text to a single line? The issue is the web service does not accept multiline data as a payload.

 How do I convert the text that I read to a single line? any builtin functions?

Thanks
Vijay

[Pete Wirfs]

Typically a line break is represented by CHAR(13) and CHAR(10).  If you can change your database select statement, you should be able to do something like this in your SQL to remove them;

• REPLACE(REPLACE(column, CHAR(13), ''), CHAR(10), '')

------------------------------
Pete
------------------------------

[Vijay Chaganti]

Thank You Pete, Instead of Automic as you suggested on the query I did and it worked.
The only change is In Oracle instead of CHAR I need to use CHR to work.

Thanks
Vijay