7 Replies Latest reply: Feb 18, 2013 4:51 AM by 978906 RSS

    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