MatchPrefixAll ( theList ; thePrefix )

Returns all values from a list that matches the supplied prefix.

Average rating: 4.3 (34 votes) Log in to vote

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

Sample input:

MatchPrefixAll ( "layout1¶
layout2¶
layout3¶
printReport¶
printInvoice¶
printEstimate¶
layout4¶
layout5¶"
; "print" )

Sample output:

printReport
printInvoice
printEstimate

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

/*Thanks to "Ender" (Mike Hackett) on FMForums for the core of this version that does not require a piggy-back counter. I expanded his basic premise so it strips the trailing CR*/

Case ( not IsEmpty ( theList ) and not IsEmpty ( thePrefix ) ;
Let ( newlist = MatchPrefixAll ( MiddleValues ( theList ; 2 ; ValueCount ( theList ) - 1 ) ; thePrefix ) ;

  Case ( Left ( theList ; Length ( thePrefix ) ) = thePrefix ; 

    If ( ValueCount ( newlist ) > 0 ; 
      LeftValues ( theList ; 1 ) ;
      Substitute ( LeftValues ( theList ; 1 ) ; "¶" ; "" )
    )//end If

  )//end Case
  & newlist

)//end Let
)//end Case

/*plain version with trailing CR

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

  Case ( Left ( theList ; Length ( thePrefix ) ) = thePrefix ; LeftValues ( theList ; 1 ) )//end Case
  & MatchPrefixAll ( MiddleValues ( theList ; 2 ; ValueCount ( theList ) - 1 ) ; thePrefix )

)//end Case

*/

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

Returns all values from a list that matches the supplied prefix. This version strips the CR off the end of the result list. For reference, Mike's original revision is included as a comment in the body of the CF above. There is an interesting thread on fmforums.com called "Piggy backing on a CF input parameter" if you are learning about CFs and and care to read a technical discussion about CFs.

Comments

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

MatchPrefixAll ( theList ; thePrefix )

Comments

Support this website.

Support this website.