This discussion is archived
7 Replies Latest reply: Feb 18, 2013 2:51 AM by 978906 RSS

Replacing multiple carriage return

978906 Newbie
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points