RemoveExtraReturns ( Text )
Removes duplicate carriage returns from text.
Average rating: 4.1 (39 votes) Log in to vote
Function definition: (Copy & paste into FileMaker's Edit Custom Function window)
Removes duplicate carriage returns from text. Single carriage returns are preserved, but multiple or superfluous carriage returns are boiled down to a single carriage return.
Sep 10, 2013
|Yes, this is a good one.
We may delete/replace the first and last carrriage return of a text/string.
I'm wondering how to delete the multiple carriage return from anywhere of the string/text. So I think it is the best custom function for this.
Thanks for sharing...
Oct 12, 2018
|The first Left () function refers to "text" instead of "Text".
Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.