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

Share on Facebook Share on Twitter

  Sample input:
  Sample output:

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

CUSTOM FUNCTION: CullNulls ( listOfValues )
© 2008 Debi Fuchs of Aptworks Consulting,

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



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, Lancaster
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.
Stephen Wonfor   Stephen Wonfor, Iceworm Consulting & Stuff, Inc.
Nov 1, 2018
nice work.

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: