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.	ListSort ( ValueList )
	(Mon, Aug 21, 11:04am)
2.	AddSortOrder ( values ; padWidth ; delimiter ; currentValue )
	(Wed, Aug 16, 10:37am)
3.	AddAddHiddenSortOrder ( values ; currentValue )
	(Wed, Aug 16, 10:31am)
4.	String_to_Number_in_Scientific_Notation ( text )
	(Tue, Aug 15, 9:20am)
5.	Quartic_Solver ( a, b, c , d, e, which_x )
	(Sun, Aug 13, 1:05pm)
6.	SQLRefSimple ( FldRef ; Option1TO2Fld3Both )
	(Fri, Aug 11, 3:19pm)
7.	BinaryStringXOR ( a ; b )
	(Mon, Aug 07, 1:46pm)
8.	VarListCreatorPro ( VarType, VarName, VarValue, Mode)
	(Mon, Aug 07, 1:05pm)