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 - Show more from this author
106th Street Wheel and Tire
MatchValueList( "apple - fruit - Company ¶iron - metal" , " - " , "apple" )
MatchValueList( "Rose is red ¶Sky is blue" , " is " , "sky" )
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 "-" .
Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.