RemoveEmptyValues ( _values )
Removes all empty values from a value list.
Average rating: 4.8 (29 votes) Log in to vote
|
Michael Rhodes Allied Data Service http://allieddataservice.com |
Sample input:
RemoveEmptyValuesƒ ( "¶a¶¶¶¶¶b¶" )
Sample output:
"a¶b"
Function definition: (Copy & paste into FileMaker's Edit Custom Function window)
Removes all empty values from a value list.
Comments
 |
Michael Rhodes, Rancho Cucamonga Apr 17, 2009 |
|
| Updated 4/17/2009 to account for arrays that have only empty values. | ||
 |
Daniel Wood, Digital Fusion Ltd Jan 24, 2011 |
|
| Calc is missing a ";" after the second line in the Let statement. | ||
|
Michael Rhodes, Rancho Cucamonga, CA Jan 24, 2011 |
|
| Thanks for the heads up, Daniel. Fixed. | ||
|
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, 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, 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, Northwest Enforcement 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 :-) James |
||
Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.