RemoveValues_ReturningUnique ( MyList ; Out )

Speedily (and with no recursion) filter values out of a list (returning unique values only)

Be the first to rate this function Log in to vote

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

Sample input:

RemoveValues_ReturningUnique( List("a";"b";"c";"d"; "a"); List("d"; "b") )

Sample output:

"a¶c¶"

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

/*
CUSTOM FUNCTION: RemoveValues_ReturningUnique ( MyList; Out )
Debi Fuchs of Aptworks Consulting

Speedily (and with no recursion) filter values out of a list
NOTE: returns unique values only
  (for an alternative see RemoveValues_PreservingDuplicates, which is slower)

EXAMPLE:
 RemoveValues_ReturningUnique( List("a";"b";"c";"d"; "a"); List("d"; "b") )
    --> "a¶c¶"

CREATED: 2025-11-05

*/

Let (
  [
    ~exclusions = UniqueValues ( Out );
    ~combined = UniqueValues ( ~exclusions & MyList )
  ];
  Right ( ~combined; Length ( ~combined ) - Length ( ~exclusions ) )
)

Speedily (and with no recursion) filter values out of a list
NOTE: returns unique values only (for an alternative see RemoveValues_PreservingDuplicates, which is slower)

Comments

Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.

RemoveValues_ReturningUnique ( MyList ; Out )

Comments

Support this website.

Support this website.