Shopping Cart

Free Newsletter
Signup

Contact

FileMaker is a registered trademark of FileMaker, Inc. in the U.S. and other countries.

FileMaker Pro Custom Functions

List | Show Random | Upload | Add This to Your Site

MatchPrefixAll ( theList ; thePrefix )

Rate this function:

Average rating: 4.4 (34 votes)
Discuss this Custom Function

Jeremiah Small, Soliant Consulting
http://jsmall.us

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

Sample Input:

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

Sample Output:

printReport
printInvoice
printEstimate

/*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 */
Then copy & paste into FileMaker Advanced's Edit Custom Function window.

Click here to copy To Clip Manager if you have myFMbutler's Clip Manager installed

Description:

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.

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

This is my Custom Function and I want to edit it

Discuss:

There are no comments yet. Be the first to post a comment about this Custom Function! Please try to keep it brief & to the point. Anyone can post:

Download the Custom Function Dashboard Widget for OS X
Keep all the latest Custom Functions right at your fingertips!

Newest Custom Functions:

1.	StopwatchMilliseconds ( StartTimeLapLapsStopClear , LapPrefix )
	(Fri, Jun 23, 9:46am)
2.	StopwatchSeconds ( StartTimeLapLapsStopClear , LapPrefix )
	(Fri, Jun 23, 9:40am)
3.	LinkedInLookup ( name )
	(Fri, Jun 23, 1:07am)
4.	BaseX_ToDecimal ( baseString; decimalNumber )
	(Tue, Jun 20, 8:40am)
5.	BaseX_FromDecimal ( baseString; decimalNumber )
	(Tue, Jun 20, 8:33am)
6.	AutoPct ( myValue )
	(Thu, Jun 15, 12:07pm)
7.	BarcodeCode128B_BMP_380px ( string )
	(Wed, Jun 14, 4:05pm)
8.	FrontTabPanelNames ( param )
	(Tue, Jun 13, 5:46am)