AnsweredAssumed Answered

Removing multiple carriage returns

Question asked by Polarpro on Jan 11, 2012
Latest reply on Jan 11, 2012 by 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

Outcomes