How to remove carriage...

No replies
Anonymous's picture
Anonymous

How to remove carriage return and line feed from bank payment format.

I have tried the below 4 but nothing is working. The bank payment file is always printing a CR LF at the end

v_chr_l_sec:= regexp_replace(v_chr_z_rec,'([^[:graph:]||^[:blank:]])',''); /*Remove CR LF*/
              v_chr_l_sec:= regexp_replace(v_chr_z_rec,chr(13)||chr(10),'');
              v_chr_l_sec:= regexp_replace(v_chr_z_rec,chr(13),'');
              v_chr_l_sec:= regexp_replace(v_chr_z_rec,chr(10),'');

Post new comment

The content of this field is kept private and will not be shown publicly.
All Rights Reserved. Copyright 2008-11 OracleUG.com.