7 Replies Latest reply on Feb 18, 2013 10:51 AM by 978906

    Replacing multiple carriage return

    978906
      Hi all, a query returns string like AAA[][]AAA[][][][]BBB[][]BBB . I have to replace the four consecutive carriage returns with a semicolon and not the consecutive two carriage returns. I tried
      replace(STRING,chr(13)||chr(13)||chr(13)||chr(13),';') but it has no effect. Any help would be appreciated.
      TIA