Brian Dunning's FileMaker Custom Functions

GetUniqueValues.cf ( 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
igeek
http://www.igeek.co.uk

Share on Facebook Share on Twitter

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

  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'

 

Comments

Log in to post comments.

 

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

Under construction. Email me your wish list for improvements.