OraFAQ Forum: SQL & PL/SQL » How to Remove New Line Character in Multilne String

Home » SQL & PL/SQL » SQL & PL/SQL » How to Remove New Line Character in Multilne String

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to Remove New Line Character in Multilne String [message #218200]

Wed, 07 February 2007 04:54

javed.khan
Messages: 340
Registered: November 2006
Location: Banglore

Senior Member

Hi
I am Stuck with a Query in which I have to Fetch a Whole data in a Single line of a Multi Line Data So I was about to Find out the ASCII Value of New Line Character and Then Remove it...Is there any Other Better way to Find out the New Line or Enter Key ASCII Value or to Solve the Problem.

Desc
---------

Data I am Getting from Query
----------------------------
DDESCRIPTION OF ITEMS SI

M.S. PLATE CUTTING 250830
M.S. SHEET CUTTING 99969
M.S. SCRAP 79950
M.S. BRIGHT BARS 87591
--------------------------------------------------------

I need in format
----------------

DDESCRIPTION OF ITEMS ||SI||M.S. PLATE CUTTING ||.....and So on..

[Updated on: Wed, 07 February 2007 05:37]

Report message to a moderator

Re: How to Remove New Line Character in Multilne String [message #218242 is a reply to message #218200]

Wed, 07 February 2007 08:03

joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA

Senior Member

chr(10) is a linefeed and chr(13) is a carriage return. Look into the replace or translate function. Maybe that will help.

[added] I really couldn't tell what you were trying to do based on the data and what you expected.

[Updated on: Wed, 07 February 2007 08:04]

Report message to a moderator

Re: How to Remove New Line Character in Multilne String [message #218276 is a reply to message #218242]

Wed, 07 February 2007 10:17

JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...

Senior Member

I think the OP is hoping that they can convert a multi-row set of data into one row by removing the <CR> characters that separate the lines.

Report message to a moderator

Re: How to Remove New Line Character in Multilne String [message #218412 is a reply to message #218276]

Thu, 08 February 2007 02:07

javed.khan
Messages: 340
Registered: November 2006
Location: Banglore

Senior Member

Ya Same I need This data is Feeded by a Form in an Editor and User Entered data By Hitting Lots of Enters But Now I have to Generate a Text File in Which all data they want in a Single line ....

Report message to a moderator

Re: How to Remove New Line Character in Multilne String [message #218811 is a reply to message #218200]

Sat, 10 February 2007 11:44

pakcikkantin
Messages: 4
Registered: February 2007

Junior Member

select replace(replace(mystring,chr(10),''),chr(13),'') from mytable;

Report message to a moderator

Previous Topic:	Finding the latest data
Next Topic:	Accessing Data From Oracle Reports

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Jul 29 11:46:26 CDT 2025