Re: Searching for newline characters in a varchar

To ensure hardware independance:

   lv_string := REPLACE(lv_OriginalString, '
', 'NEW_STUFF');
Also, there must be no spaces from the end of the first line and the start of the second. An alternative is to make a global constant in place of the
'
' part...

   prv_NL_CHAR CONSTANT VARCHAR2(2) := '
';

...

   lv_string := REPLACE(lv_OriginalString, prv_NL_CHAR, 'NEW_STUFF');

Cheers Fred Received on Thu Oct 09 1997 - 00:00:00 CDT