Fast EOL Conversion

[martindsouza]

Right now to simplify EOL conversions can do the following:

regexp_replace(l_str, '[' || gc_cr || gc_lf || ']+', gc_crlf); where l_str can be a string or a clob. On large files this takes a long time.

Can do the same thing using:

replace(replace(replace(replace(l_str, gc_crlf, gc_lf), gc_lfcr, gc_lf), gc_cr, gc_lf), gc_lf, gc_crlf); and it's very quick for LOBs.

Create a function that takes in p_str which can be a clob varchar2 as well as desired EOL set (ex: lf) and returns the value.

Similar tickets:

• Detect EOL for a string #152
• EOL conversions #124