Tags: carriage, database, file, mysql, oracle, removing, return, sql, text

Removing carriage return

On Database » Oracle

559 words with 3 Comments; publish: Thu, 14 Feb 2008 15:40:00 GMT; (25054.69, « »)

Hi,

How can I remove all the carriage return in a text file using PL/SQL?

Thanks.

All Comments

Leave a comment...

  • 3 Comments
    • replace(str,CHR(13))

      ?

      #1; Sat, 23 Feb 2008 23:50:00 GMT
    • CHR(13) may alone not suffice as Windows uses a control line feed carriage return combo - #10#13.

      Only stripping #13 will thus still leave a trailing #10 control character.

      #2; Sat, 23 Feb 2008 23:51:00 GMT
    • > CHR(13) may alone not suffice as Windows uses a

      > control line feed carriage return combo - #10#13.

      >

      > Only stripping #13 will thus still leave a trailing

      > #10 control character.

      yep, missed that

      then CHR(13)||CHR(10) will help

      #3; Sat, 23 Feb 2008 23:52:00 GMT