RemoveValues_PreservingDuplicates ( MyList ; Out )

Speedily (and with no recursion) filter values out of a list (keeping any dups)

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_PreservingDuplicates( List("a";"b";"c";"d"; "a")

Sample output:

"a¶c¶a¶"

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

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

Speedily (and with no recursion) filter values out of a list
NOTE: includes original duplicates rather than returning unique values only 
  (for an alternative see RemoveValues_ReturningUnique, which is faster)

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

CREATED: 2025-11-05

*/

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

Speedily (and with no recursion) filter values out of a list
NOTE: includes original duplicates rather than returning unique values only (for an alternative see RemoveValues_ReturningUnique, which is faster)

Comments

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

RemoveValues_PreservingDuplicates ( MyList ; Out )

Comments

Support this website.

Support this website.