Brian Dunning's FileMaker Custom Functions

RemoveEmptyValues ( _values )

Removes all empty values from a value list.

  Average rating: 4.8 (29 votes) Log in to vote

Michael Rhodes   Michael Rhodes
Allied Data Service

Share on Facebook Share on Twitter

  Sample input:
RemoveEmptyValuesƒ ( "¶a¶¶¶¶¶b¶" )
  Sample output:

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

Removes all empty values from a value list.



Michael Rhodes   Michael Rhodes, Rancho Cucamonga
Apr 17, 2009
Updated 4/17/2009 to account for arrays that have only empty values.
Daniel Wood   Daniel Wood, Digital Fusion Ltd
Jan 24, 2011
Calc is missing a ";" after the second line in the Let statement.
Michael Rhodes   Michael Rhodes, Rancho Cucamonga, CA
Jan 24, 2011
Thanks for the heads up, Daniel. Fixed.
Crispin   Crispin, Hodges
Nov 3, 2011
My values all begin with a *. I found the first * was deleted by this function.
The identically named rival did the job for me
Jared   Jared, Los Angeles, CA
Aug 15, 2014
If you're looking for a function to remove an extra carriage return after the array, try RemoveEmptyValues ( Text ) instead, this one will preserve a carriage return at the end of the array. Helpful for certain situations.
Michael Rhodes   Michael Rhodes, Colorado Springs, USA
Mar 17, 2017
The current version removes the trailing pilcrow. The original version kept it intentionally, but I have found it better to remove it over the years.
James   James, UK
Sep 6, 2017
Hi Michael,

This is fab thanks - just what I needed. You may wish to update the sample output ainfo as it currently still has the trialling pilcrow in it :-)


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 16 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: