Newest functions Upload a function Leave a tip My account

There are 2,570 functions in this library.

StripEmptyValues ( theList )

strip empty values from a list

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

Peter Wagemans - Show more from this author Lesterius https://www.lesterius.com

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

// strip empty values from a list, this function also removes trailing returns in value lists Case ( IsEmpty ( theList ) ; "" ; Let ( [ tempResult = Substitute ( "¶" & theList & "¶" ; ["¶¶"; "¶"] ) ; strippedList = Middle ( tempResult ; 2 ; Length ( tempResult ) - 2 ) ] ; If ( PatternCount ( "¶" & strippedList & "¶" ; "¶¶" ) ; StripEmptyValues ( strippedList ) ; strippedList ) ) ) Click to copy

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.

 

Comments

		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".

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.

Support this website.

This library has been a free commmunity resource for FileMaker users and developers for 20 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: