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 - Show more from this author

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.

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: