Brian Dunning's FileMaker Custom Functions

CullNulls ( listOfValues )

Speedily (and with no recursion) remove empty items from a list.

  Average rating: 4.2 (38 votes) Log in to vote

Debi Fuchs   Debi Fuchs
Aptworks Consulting
http://www.aptworks.com

Share on Facebook Share on Twitter

  Sample input:
CullNulls(
"¶9¶2¶4¶¶7¶¶¶"
)
  Sample output:
"9¶2¶4¶7"

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

CUSTOM FUNCTION: CullNulls ( listOfValues )
© 2008 Debi Fuchs of Aptworks Consulting, debi@aptworks.com

Speedily (and with no recursion) remove empty items from a list.
e.g. CullNulls("¶9¶2¶4¶¶7¶¶¶") -> "9¶2¶4¶7"

LAST MODIFIED: 13-AUG-2008 by Debi Fuchs of Aptworks

 

Comments

Vaughan   Vaughan, Sydney, Australia
Jul 28, 2011
You have asserted copyright on this cf, but not granted any permissions for others to copy it or use it.
 
Debi Fuchs   Debi Fuchs, Aptworks Consulting
Feb 5, 2013
Sorry...copyright removed!
 
steve   steve, norwich
Aug 1, 2018
Have you thought about maybe using Get ( UUID ) for the value assigned to s?

Just thought it might be better than a magic string.

BTW, Thanks so much, I have used this consistently since it was first shared ages ago.
 

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.