APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Replace or delete all single NewLines in a Blob

Johnny Be GoodSep 25 2012 — edited Oct 15 2012

Hi there,

I would like to delete/replace all single New Lines (NOT the Carriage Return / New Lines) within a blob.

I tried to convert the blob in a clob and then replace all occurences of single New Lines with the replace function (e.g. replace(clob, chr(10)) ),
I even cut the clob into small chunks of varchar2 and tried to apply the replace function etc, but all without success!

I would be glad if someone could give me a hint how I could tackle this problem.

I am using
Application Express 4.1.0.00.32 on
Oracle 10g (10.2.0.4.0 - 64bit)

Thanks,
Johnny

This post has been answered by fac586 on Sep 26 2012

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 12 2012

Added on Sep 25 2012

#apex-discussions

10 comments

4,547 views