Software Venture Consulting

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

Free Web Tools
Free FileMaker Tools

Personal Pages
Videos
Adventures
Links

Shopping Cart
Shopping Cart

Search:

Free Newsletter
Signup


Contact


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:  

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

Theo Ros, *
http://notapplicable.com

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

Description:

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 BrianDunning.com. Please contact the individual developer with any questions or problems.

This is my Custom Function and I want to edit it

Discuss:

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:
City/Location:
Comment:
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 3 + 5 =
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. decFromHex ( hexValue )
  (Mon, Oct 16, 12:34pm)
2. MonthYearList ( startmonth ; startyear ; numbermonth ; short )
  (Mon, Oct 16, 3:38am)
3. ErrorDescription ( errorNumber )
  (Wed, Sep 27, 2:51am)
4. decodeEntities (text)
  (Wed, Sep 27, 1:22am)
5. HexidecimalToNumber ( HexidecimalValue ; counter )
  (Mon, Sep 25, 12:39pm)
6. FixedFieldConverter ( Fieldname ; f1 ; f2 ; f3 ; f4 ; f5 ; f6 ; f7 ; f8 ; f9 ; f10 ; f11 ; f12 ; f13 ; f14 ; f15 ; f16 ; f17 ; f18 ; f1
  (Fri, Sep 15, 12:34pm)
7. ShannonEntropy ( text )
  (Thu, Sep 07, 5:59am)
8. LetterCount ( text ; summary )
  (Thu, Sep 07, 5:53am)

RSS Feed of Custom Functions