Home » RDBMS Server » Server Administration » 'Enter' pressed in textarea
'Enter' pressed in textarea [message #372548] Wed, 21 February 2001 13:42 Go to next message
Lisa Stone
Messages: 3
Registered: February 2001
Junior Member
I have a field called Comment varchar2(500). This gets data from a textarea provided in one of the screen. Sometimes people after copmlition of one line , press 2-3 times 'Enter'. Now when I export data to excel sheet instead on one, more records are formed.
Is there any way I can remove characters entered by pressing 'Enter' and keep whole of the entered data as one string. ?
I probabily need to find position of the character that is entered by pressing 'Enter'. and then combine two parts together.

Report message to a moderator

Re: 'Enter' pressed in textarea [message #372549 is a reply to message #372548] Wed, 21 February 2001 14:46 Go to previous message
amarpatgiri
Messages: 11
Registered: December 2000
Junior Member
Use the TRANSLATE or REPLACE function to remove the new lines from your varchar2 field, e.g.

select replace('this is a string
with an embedded newline','
',null) from dual

-amar

Report message to a moderator

Previous Topic: nested queries
Next Topic: Re: Passthrough query
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat May 18 07:38:46 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.