Newest functions Upload a function Leave a tip My account

There are 2,522 functions in this library.

CullNulls ( listOfValues )

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

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

Debi Fuchs - Show more from this author Aptworks Consulting http://www.aptworks.com

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

/* CUSTOM FUNCTION: CullNulls ( listOfValues ) by 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 Consulting */ Let( s = "##*aaa*##"; //very unlikely string If( //Check if unlikely string rears its head Position( listOfValues; s; 0; 1 ); //If so, simulate an out-of-range error. Evaluate( "Factorial( -1 )" ); // Otherwise, proceed to get rid of nulls Substitute( s & listOfValues & s; [ "¶¶"; ¶ & s & ¶ ]; [ "¶¶"; ¶ & s & ¶ ]; [ s & ¶; "" ]; [ ¶ & s; "" ]; [ s; "" ] ) ) ) Click to copy

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, 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, Aptworks Consulting Feb 5, 2013
Sorry...copyright removed!

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

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: