ExcludeValues ( MyList ; Out )
to exclude values from a list
Average rating: 4.8 (12 votes) Log in to vote
Agnes Barouh - Show more from this author
ExcludeValues ( "I¶want¶to¶exclude¶words¶from¶list¶simply" , "want¶to¶some¶I" )
Function definition: (Copy & paste into FileMaker's Edit Custom Function window)
// ExcludeValues(MyList ; Out) v1.0
to exclude values from a list.
Not case sensitive and not recursive
Used UniqueValues() => not runtime compatible
Joshua Willing, Willing Apps
Mar 21, 2018
|This is quite genius.|
Mar 23, 2018
the code is mostly quite simple ;)
Thank you !
Mar 24, 2018
Mar 25, 2018
|Very nice! Simple, handles lists with long list of duplicates easily and correctly.|
Mar 26, 2018
|There is a TIP "shorter list first in FilterValues()", so changing parameter order in FilterValues() would make it a bit faster generally.|
Mar 27, 2018
With all his years, I'm not looking for speed any more in Filemaker.
But you're right to point it out
In fact, if we want to optimize the code, we must put a Let for each calculation is the fastest :
Prepa = Substitute ( Out & ¶ ; [¶ ; Char (8203 ) & ¶]) ;
Unic = UniqueValues ( Prepa & MyList )
FilterValues ( Unic ; MyList )
Merci à tous, ravie que ce calcul vous interpelle !
Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.