Removing multiple carriage returns
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?