Brian Dunning's FileMaker Custom Functions

RemoveExtraReturns ( Text )

Removes duplicate carriage returns from text.

  Average rating: 4.1 (39 votes) Log in to vote

Andrew Persons   Andrew Persons

Share on Facebook Share on Twitter

  Sample input:
RemoveExtraReturns ( "Hello

name is

Andy" )
  Sample output:
name is

  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.



Avaya   Avaya, Bhubaneswar
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...
RealGrouchy   RealGrouchy
Oct 12, 2018
The first Left () function refers to "text" instead of "Text".

- RG>

Log in to post comments.


Note: these functions are not guaranteed or supported by Please contact the individual developer with any questions or problems.

Under construction. Email me your wish list for improvements.