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.

Support this website.

This library has been a free commmunity resource for FileMaker users and developers for 15 years. It receives no funding and has no advertisements. If it has helped you out, I'd really appreciate it if you could contribute whatever you think it's worth: