Brian Dunning's FileMaker Custom Functions

TrimAll_CR ( Text )

All redundant returns: leading, trailing and the extra returns between values will be removed

  Average rating: 4.5 (31 votes) Log in to vote

Menno van Beek   Menno van Beek
Van Beek Zakelijke Software
https://www.vbzs.nl

Share on Facebook Share on Twitter

  Sample input:
TrimAll_CR ( "


All redundant returns:

leading, trailing and the extra returns



between values will be removed


" )
  Sample output:
All redundant returns:
leading, trailing and the extra returns
between values will be removed

  Function definition: (Copy & paste into FileMaker's Edit Custom Function window)

All redundant returns: leading, trailing and the extra returns between values will be removed.

The function is recursive, but very fast since it only has between 1 and 3 iterations.

 

Comments

Log in to post comments.

 

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

Under construction. Email me your wish list for improvements.