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
http://www.106sttire.com

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

fruit - Company

blue

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

// This function will search the value list like "apple - fruit ¶iron - metal",  " - " is the seperator, if MatchText is "apple", the function will return "fruit"
// This is for fast search fix corresponding values and no need for a table. Only first match will be returned.

Let ( [
    p1 = Position ( ¶ & Valuelist ; ¶ & MatchText & Seperator ; 1 ; 1 ) ;   		// Search only the beginning of a value
    p2 = p1 + Length(MatchText) +Length(Seperator); 		//The start position of the MatchValue
    p3 = Position ( Valuelist & ¶ ; ¶ ; p2 ; 1)  ];		 //Find the end of the line
    // result
   if( p1=0; ""; Trim(Middle ( Valuelist ; p2 ; p3 - p2 )))
)

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 "-" .

Comments

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

GetMatchValueInList ( ValueList, Seperator, MatchText )

Comments

Support this website.

Support this website.