Thread: remove embedded carriage returns

remove embedded carriage returns

From
chwy_nougat@yahoo.com
Date:
Outputting a SELECT statement's results to ascii file showed me a table
with a bunch of embedded carriage return characters in the values. I
want to remove the embedded returns, so I read the documentation and
tried a few variations on "SELECT replace(columname, 'chr(13)','') from
tablename" with no luck. Could someone help me rid this table of its
embedded returns?

Thanks in advance...


Re: remove embedded carriage returns

From
Jonathan Hedstrom
Date:
chwy_nougat@yahoo.com wrote:
>  "SELECT replace(columname, 'chr(13)','') from tablename"

Try using chr(13) without the single quotes:

SELECT replace(columname, chr(13),'') from tablename

or you could use '\r' to get the character:

SELECT replace(columname, E'\r','') from tablename


-Jonathan

Attachment

Re: remove embedded carriage returns

From
chwy_nougat@yahoo.com
Date:
chwy_nou...@yahoo.com wrote:
> Outputting a SELECT statement's results to ascii file showed me a table
> with a bunch of embedded carriage return characters in the values. I
> want to remove the embedded returns, so I read the documentation and
> tried a few variations on "SELECT replace(columname, 'chr(13)','') from
> tablename" with no luck. Could someone help me rid this table of its
> embedded returns?
>
> Thanks in advance...

Is there a different board that I should post this question to?


Re: remove embedded carriage returns

From
"Kj"
Date:
Jonathan Hedstrom wrote:
> chwy_nougat@yahoo.com wrote:
> >  "SELECT replace(columname, 'chr(13)','') from tablename"
>
> Try using chr(13) without the single quotes:
>
> SELECT replace(columname, chr(13),'') from tablename
>
> or you could use '\r' to get the character:
>
> SELECT replace(columname, E'\r','') from tablename
>
>
> -Jonathan
>
> begin:vcard
> fn:Jonathan Hedstrom
> n:Hedstrom;Jonathan
> org:Downtown Emergency Service Center;Information Services
> email;internet:jhedstrom@desc.org
> title:Data Systems Administrator
> tel;work:(206) 464-1570 ext. 3014
> version:2.1
> end:vcard
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster


Thanks so much! I am a psql noob and really appreciate your response
and help.