MatchPrefix ( theList ; thePrefix )

Returns first value in a list that matches the supplied prefix.

Average rating: 4.5 (29 votes) Log in to vote

Jeremiah Small - Show more from this author
Soliant Consulting, Inc.
https://www.soliantconsulting.com

Sample input:

MatchPrefix ("
ItemA1¶
ItemB1¶
ItemB2
" ; "ItemB" )

Sample output:

ItemB1

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

Case ( not IsEmpty ( theList ) and not IsEmpty ( thePrefix ) ;

  If ( Left ( theList ; Length ( thePrefix ) ) = thePrefix ; 
    Substitute ( LeftValues ( theList ; 1 ) ; "¶" ; "" ) ;
    MatchPrefix ( MiddleValues ( theList ; 2 ; ValueCount ( theList ) - 1 ) ; thePrefix ) 
  )//end If

)//end Case

Updated so List parameter doesn't conflict with new native List function.

Returns the first value from a list that matches the supplied prefix.

This CF was designed to aid in window management. When the list supplied is the function WindowNames, the CF returns the first open window name that matches the supplied prefix. Used in conjunction with a looping routine that is run prior to opening a new window with the name "Example", you can ensure that any existing windows that begin with "Example" are closed before invoking the new "Example" window. This is useful in defeating proliferation of windows created with the New Window command that share the same base name as their master window, but have numbered suffixes.

Comments

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

MatchPrefix ( theList ; thePrefix )

Comments

Support this website.

Support this website.