Software Venture Consulting

FileMaker Pro downloads & Resources
FileMaker Custom Functions
FileMaker Web Viewer Examples
FileMaker Pro & Lasso Consulting
FileMaker Books
FileMaker Articles
FileMaker Error Reference

Free Web Tools
Free FileMaker Tools

Personal Pages

Shopping Cart
Shopping Cart


Free Newsletter


Privacy Policy

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

StrMatch ( string1 ; string2 ; comparemethod ; matchcase )

Rate this function:  

  Average rating: 3.8  (41 votes)
  Discuss this Custom Function

Theo Ros, *

StrMatch makes it easier to compare to textfields.

Sample Input:
StrMatch ( "AbcDef" ; "Def" ; "cn" ; True )
Sample Output:
True (1)

 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


StrMatch makes it easier to compare to textfields.
With parameters 'comparemethod' and 'matchcase', various comparisons
can be performed.
The function returns a boolean number:
False (0) means both strings do not match
True (1) means the match is found

In: string1 - the textfield or literal string you want examined
string2 - the textfield or string you want to match against string1
comparemethod - a string containing one of the following commands:
eq - test if string 1 and string 2 are equal
neq - test if string 1 and string 2 are NOT equal
bw - test if string 1 begins with string 2
cn - test if string 1 contains string 2
ew - test if string 1 ends with string 2
gt - test if string 1 is greater than string 2
gte - test if string 1 is greater than or equal to string 2
lt - test if string 1 is less than string 2
gt - test if string 1 is less than or equal to string 2

matchcase - if set to True (any value not equal to zero)
the function does a Case Sensitive compare.
if False (0) the function behaves Case Insensitive

If an invalid comparemethod is given, the function compares for Equality

Syntax: StrMatch ( string1 ; string2 ; comparemethod ; matchcase )

Return type: Number (boolean)

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

This is my Custom Function and I want to edit it


How would I import this in filemaker pro 8 advanced?
Or is there already a version like this in Filemaker Pro 8 Advanced?

If so could you send me into the right direction. I only need the "cn" method.

Anon, lol
March 10, 2011 7:38am

Hi Anon,

i do not have pro 8 advanced, but i think this functio should work in that version aswell.

Have you tried adding it to your custom functions?

Theo Ros

Theo Ros, Hilversum
March 10, 2011 8:54am

Great! this solved a problem that was even with some 'work--arounds' not solvable, as Filemaker Pro 11 does not have a clear function for exact comparison of strings... I had to clean up thousands of fields in a bibliographical database and peel out all those small variations made by typists/cataloguers over years (those without a proper library education and without proper tools)... my parsing script works perfect now... thanks again! Theo Ros

Tjebbe van Tijen, Amsterdam
June 19, 2015 5:43am

You're welcome!

Theo Ros, Hilversum
June 22, 2015 12:01am

Make a comment about this Custom Function (please try to keep it brief & to the point). Anyone can post:

Your Name:
characters left. If you paste in more than 1500 characters, it will be truncated. Discuss the function - advertisements and other useless posts will be deleted.
Answer 6 + 7 =
Search for Custom Functions:

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

Newest Custom Functions:

1. ExcludeValues(MyList ; Out)
  (Wed, Mar 21, 7:23am)
2. PreviousMonthEndDate ( myDate )
  (Wed, Mar 07, 3:35am)
3. PreviousMonthName (myDate)
  (Wed, Mar 07, 3:33am)
4. FmTableFields ( tableName ; fieldsInclude ; fieldsExclude ; classExclude ; typeExclude ; prefixExclude )
  (Fri, Mar 02, 6:32am)
5. sql.getTable ( fullyQualifiedFieldObject )
  (Thu, Feb 22, 8:36am)
6. sql.getField ( fullyQualifiedFieldObject )
  (Thu, Feb 22, 8:34am)
7. FilterOut ( ListA ; ListB )
  (Wed, Feb 21, 6:11pm)
8. Char0 ( )
  (Sun, Feb 18, 2:35am)

RSS Feed of Custom Functions