StripEmptyValues ( theList )
strip empty values from a list
Average rating: 4.6 (31 votes) Log in to vote
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, 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, Lesterius
Sep 9, 2018
|Correct. Parameter changed to "theList".|
Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.