cf_GetElement ( SearchString ; KeyList ; ElementList )

Find a value from a second list, based on a search of a key field in a first list.

Average rating: 4.1 (36 votes) Log in to vote

Gary Tate
TGI Solutions
http://www.tgisolutions.co.uk

Sample input:

cf_GetElement ( "06" ; "01¶02¶03¶04¶05¶06¶07¶08¶09¶10¶11¶12" ; "January¶February¶March¶April¶May¶June¶July¶August¶September¶October¶November¶December" )

Sample output:

"June"

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

/*Supply 2 lists, the first (KeyList) being a list of keys to match the corresponding second list (ElementList)
By finding the first occurance of SearchString in the first list, the function will then return the same item from ElementList
eg if the first list contains numbers 1 thru 12, and the second contains the months of the year, if you set SearchString to 6 the result will be June*/

Case(PatternCount ( KeyList ; SearchString ) = 0;"";
Let( [
PosInKeyList  = Position( KeyList ; SearchString ; 1 ; 1 ) + Length( SearchString ) ;
List = Middle( KeyList ; 1 ; PosInKeyList ) ;
ItemID   = ValueCount( List );
Result = GetValue ( ElementList ; ItemID )
] ; Result ))

I wrote this to dynamically build tool tips based on 3 possible values for a specific button. Each tool tip would have 2 values, Full and Minimum. A user preference would specify which level of tool tip to return (ie a user could decide to receive a long or short tool tip, or none at all). The tool tip for the button would then be set to supply the tool tip list (either Full or Minimum) a serias of tool tip headings, and the name of the tool tip to find (eg New Company). The tool tip name would then be looked up in the tool tip heading list and the appropriate tool tip returned.

Note it will fall over if your key list entries can be found in more than 1 place (in the example above "1" appears in 1, 10, 11 and 12)

Comments

		Kamal Salah, Creative Art Design Aug 26, 2020
Hi, i was looking for a simular function that if i have this string example without order. Function (SearchString, input, output) array 1 ="Banan" , "Banana is a fruite" array 2 ="kiwi" , "Kiwi is a fruite" array 2 ="RB" , "RB Means.... bla bla bla." array 100 ="...etc" Input string String ="Banana Yellow 15kg ES RB" Input: -> "Banana" output: <- "Banana is a fruit" Anything you can recommend? Or how to do it?

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

cf_GetElement ( SearchString ; KeyList ; ElementList )

Comments

Support this website.

Support this website.