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.3 (35 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.	UnQuote ( string )
	(Tue, Apr 10, 12:34pm)
2.	TrimInvalidTrailingChars ( invalidChars ; textToTrim )
	(Wed, Apr 04, 10:31pm)
3.	ITA_PositionIndexValues( textList; searchList; searchValue; occurrence)
	(Wed, Apr 04, 6:29pm)
4.	@UniqueValuesToAdd ( existingValues ; addingValues ; ~datatype ; ~locale )
	(Sat, Mar 31, 12:52am)
5.	ExcludeValues(MyList ; Out)
	(Wed, Mar 21, 7:23am)
6.	PreviousMonthEndDate ( myDate )
	(Wed, Mar 07, 3:35am)
7.	PreviousMonthName (myDate)
	(Wed, Mar 07, 3:33am)
8.	FmTableFields ( tableName ; fieldsInclude ; fieldsExclude ; classExclude ; typeExclude ; prefixExclude )
	(Fri, Mar 02, 6:32am)