Re: Replace a carriage return in a text field

LinkBack

Thread Tools

Display Modes

#1 (permalink)

04-20-2008, 03:34 PM

FRANK

Posts: n/a

Re: Replace a carriage return in a text field

HI, Jared,

Have you tried magic?

EXECUTE PROCEDURE IFX_ALLOW_NEWLINE('t');

update mytab set desc=replace(desc,'
',"#")
where mycol =90010564;

Yes, jusr hit Enter key, instead of using special cracter for NewLine.

Cheers!
Frank

On 5/11/07, floyd@fwellers.com <floyd@fwellers.com> wrote:
>
> I usually unload the primary key and the field in question to a file on
> unix, and use the 'tr' command to get rid of any control characters, then
> load it back up with a sql statement.
>
>
>
> <DIV> </DIV>
> 
> ======================== 
> email: floyd@fwellers.com 
> Home: 703-430-0805 
> Cell: 703-477-6045 
> ======================== 
> 
> www.one.org 
> 
> 
> 
>
>
> >-----Original Message-----
> >From: jared.hanks@gmail.com [mailto:jared.hanks@gmail.com]
> >Sent: Thursday, May 10, 2007 09:05 PM
> >To: informix-list@iiug.org
> >Subject: Replace a carriage return in a text field
> >
> >Hello,
> >
> >I need to remove carriage returns in a text field. Does anyone know
> >how to do this? I've tried the following:
> >
> >update item_table
> >Set long_description = replace(long_description,"~r"," ")
> >where inv_id = "130539";
> >
> >and I get the following error: "674: Routine (replace) can not be
> >resolved."
> >
> >I've also tried:
> >
> >Update items_table
> >Set long_description = replace(replace(long_description,
> >char(10),char(13)),char(13),' ')
> >where inv_id = "130539";
> >
> >and I get the following error: "674: Routine (char) can not be
> >resolved."
> >
> >I tried looking at the manual but couldn't figure it out.
> >
> >Any help is appreciated.
> >
> >Thanks,
> >Jared
> >
> >_______________________________________________
> >Informix-list mailing list
> >Informix-list@iiug.org
> >http://www.iiug.org/mailman/listinfo/informix-list
> >
>
>
> _______________________________________________
> Informix-list mailing list
> Informix-list@iiug.org
> http://www.iiug.org/mailman/listinfo/informix-list
>
>

« Time Data | RE: Confused engine: No SHM segments but thinks it is quiescent »

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Forum Jump

All times are GMT. The time now is 10:08 PM.

SEO

Re: Replace a carriage return in a text field