Brian Dunning's FileMaker Custom Functions

HighlightOccurrence ( ListToTest ; ListToCompare ; ColorMatch ; ColorNoMatch )

this function will recursively color code values in ListToTest by determining if they occur in ListToCompare

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

Maarten Witberg   Maarten Witberg
http://www.maatwerkdbs.nl

Share on Facebook Share on Twitter

  Sample input:
HighlightOccurrence ( "apple¶pear¶banana " ; "kumquat¶banana¶guave" ; 0 ; RGB ( 200 ; 0 ; 0 ) )
  Sample output:
apple¶pear¶banana with the value banana in red.

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

- This function will recursively color code values in ListToTest by determining if they occur in ListToCompare
- Input format for ListToTest and ListToCompare : ¶ -delimited values;
- Two color parameters allow the user to select a highlight color for either or both matching and non-matching values
-contact me: witbe001 - at - planet.nl

 

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.