Brian Dunning's FileMaker Custom Functions

GetMatchValueInList ( ValueList, Seperator, MatchText )

Search in a value list for MatchText, then return the rest seperated by Seperator

  Average rating: 3.6 (7 votes) Log in to vote

Philip Wang   Philip Wang
106 Street Tire & Wheel

Share on Facebook Share on Twitter

  Sample input:
MatchValueList( "apple - fruit ¶iron - metal" , " - " , "apple" )

MatchValueList( "apple - fruit - Company ¶iron - metal" , " - " , "apple" )

MatchValueList( "Rose is red ¶Sky is blue" , " is " , "sky" )
  Sample output:

fruit - Company


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

It allows me to store value pairs in value list. Very useful to retrieve corresponding values I need.
Please be very careful with the separator: For example: For the pair "Apple - Fruit", the separator is " - ", not just simple "-" .



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.