FileMaker Pro Custom Functions

//HighlightOccurrence ( ListToTest ; ListToCompare ; ColorMatch ; ColorNoMatch ) //by maarten witberg 2008 //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 Let( [ text = ListToTest ; first = LeftValues ( text ; 1 ) ; next = Case ( not PatternCount ( ListToCompare & ¶ ; first ) ; TextColor ( first ; ColorNoMatch ) ; TextColor ( first ; ColorMatch ) ) ; text = RightValues ( text ; ValueCount (text ) - 1 ) ]; next & Case ( not IsEmpty ( text ) ; HighlightOccurrence ( text ; ListToCompare ; ColorMatch ; ColorNoMatch ) ) ) // end let
 Then copy & paste into FileMaker Advanced's Edit Custom Function window.