Brian Dunning's FileMaker Custom Functions ( TextList ; ExceptionsList )

Gets unique values from a list (excluding values specified in the second list)

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

Jonathan Jeffery   Jonathan Jeffery

Share on Facebook Share on Twitter

  Sample input: ( "Jean¶Paul¶Jean-Paul¶Peter¶-¶ ¶Jean¶David¶Paul" ; "-¶ " )
  Sample output:

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

Filters a list, returning only one instance of any repeated value. Items are returned in the oder of first appearance. Additionally, you can submit a list of values to be ignored—for example spaces, dashes and other characters that may have been entered into a field in lieu of a proper value. Such items will be ignored only is the *whole line* of the list matches the *whole* of one of the 'ignore-items'



Log in to post comments.


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

Under construction. Email me your wish list for improvements.