Home » SQL & PL/SQL » SQL & PL/SQL » How to Remove New Line Character in Multilne String
icon9.gif  How to Remove New Line Character in Multilne String [message #218200] Wed, 07 February 2007 04:54 Go to next message
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 Go to previous messageGo to next message
joy_division
Messages: 4640
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 Go to previous messageGo to next message
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.

Re: How to Remove New Line Character in Multilne String [message #218412 is a reply to message #218276] Thu, 08 February 2007 02:07 Go to previous messageGo to next message
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 ....
Re: How to Remove New Line Character in Multilne String [message #218811 is a reply to message #218200] Sat, 10 February 2007 11:44 Go to previous message
pakcikkantin
Messages: 4
Registered: February 2007
Junior Member
select replace(replace(mystring,chr(10),''),chr(13),'') from mytable;
Previous Topic: Finding the latest data
Next Topic: Accessing Data From Oracle Reports
Goto Forum:
  


Current Time: Mon Dec 05 09:14:45 CST 2016

Total time taken to generate the page: 0.10398 seconds