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.

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 0 + 8 =
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. HexUUIDToNum_cf (_uuid)
  (Sat, Jun 16, 1:55pm)
2. httpResponseCode ( responseHeaders )
  (Tue, Jun 12, 10:40pm)
3. FindDuplicateCharacters ( string )
  (Fri, Jun 08, 5:01pm)
4. FieldRepetitionLast ( field ; maxRepetition )
  (Wed, Jun 06, 6:05pm)
5. CountModifiedRecords ( NameTimestampField ; StartTimestamp ; EndTimestamp )
  (Mon, May 28, 8:23am)
6. JSONArrayLength ( JSONArrayStr )
  (Fri, May 25, 7:46am)
7. interpolation (y1; y2; y3; x1; x2; x3; x1y1; x2y1; x1y2; x2y2; rnd)
  (Sat, May 19, 3:55am)
8. @JSONFormatElements ( json )
  (Tue, May 15, 3:31am)

RSS Feed of Custom Functions