2 Replies Latest reply on Jan 11, 2012 8:54 AM by Polarpro

    Removing multiple carriage returns

    Polarpro

      Title

      Removing multiple carriage returns

      Post

      Hello,

      I've got a field with a list of values that are separated by one or more carriage returns, e.g. "¶¶3¶15¶¶123¶¶¶¶¶5¶41¶¶12¶5¶".

      I'd like to elimintae the multiple returns, so that only "¶3¶15¶123¶5¶41¶12¶5¶" is left.

      Using Substitute ( TextfieldwReturns ; "¶¶" ; "¶" ) still leaves multiple returns where there are more than one return. Any idea how to implement this?

      Thanks,

      Mike