Brian Dunning's FileMaker Custom Functions

StripEmptyValues ( theList )

strip empty values from a list

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

Peter Wagemans   Peter Wagemans

Share on Facebook Share on Twitter

  Sample input:
StripEmptyValues ( "¶abc¶¶def¶ghi¶" )
  Sample output:

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

This function strips all occurrences of "¶¶", and "¶" at the beginning or the end of a list of values.
It's also useful to strip that annoying trailing return from the LeftValues(), RightValues() and MiddleValues() function results.



Kenneth Durrum   Kenneth Durrum, Released Solutions
Jun 27, 2015
Not sure if this is a problem in earlier version of Filemaker but in version 13 and up the term "list" should be changed to "thelist" or you won't be able to save the function.
Peter Wagemans   Peter Wagemans, Lesterius
Sep 9, 2018
Correct. Parameter changed to "theList".

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.