Newest functions Upload a function Leave a tip My account

There are 2,572 functions in this library.

StrMatch ( string1 ; string2 ; comparemethod ; matchcase )

StrMatch makes it easier to compare to textfields.

  Average rating: 3.8 (40 votes) Log in to vote

Theo Ros - Show more from this author

  Function definition: (Copy & paste into FileMaker's Edit Custom Function window)

/*----------------------------------------------------------------------------------------- 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) Theo Ros -----------------------------------------------------------------------------------------*/ Let ( comparemethod = Trim ( Lower ( comparemethod ) ) ; Case ( comparemethod = "neq" ; If ( matchcase ; Exact ( string1 ; string2 ) = 0 ; Upper ( string1 ) <> Upper ( string2 ) ) ; comparemethod = "cn" ; If ( matchcase ; // do a Case Sensitive PatternCount Let( [ marker = "%!Case!%" ; // use a highly unlikely string find = marker & string2 ; // combine into new search string string1 = Substitute ( string1 ; string2 ; find ) ] ; // redefine string1 PatternCount ( string1 ; find ) > 0 // search for the combined string ) ; PatternCount ( string1 ; string2 ) > 0 // do a normal case Insensitive PatternCount ) ; comparemethod = "bw" ; Let ( [ string1 = Left ( string1 ; Length ( string2 ) ) ] ; If ( matchcase ; Exact ( string1 ; string2 ) ; Upper ( string1 ) = Upper ( string2 ) ) ) ; comparemethod = "ew" ; Let ( [ string1 = Right ( string1 ; Length ( string2 ) ) ] ; If ( matchcase ; Exact ( string1 ; string2 ) ; Upper ( string1 ) = Upper ( string2 ) ) ) ; comparemethod = "gt" ; If ( matchcase ; string1 > string2 ; Upper ( string1 ) > Upper ( string2 ) ) ; comparemethod = "gte" ; If ( matchcase ; string1 >= string2 ; Upper ( string1 ) >= Upper ( string2 ) ) ; comparemethod = "lt" ; If ( matchcase ; string1 < string2 ; Upper ( string1 ) < Upper ( string2 ) ) ; comparemethod = "lte" ; If ( matchcase ; string1 <= string2 ; Upper ( string1 ) <= Upper ( string2 ) ) ; // anything else defaults to "eq" If ( matchcase ; Exact ( string1 ; string2 ) ; Upper ( string1 ) = Upper ( string2 ) ) ) ) Click to copy

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)

 

Comments

		Anon, lol Mar 10, 2011
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.

		Theo Ros, Hilversum Mar 10, 2011
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

		Tjebbe van Tijen, IMP Jun 19, 2015
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

		Theo Ros, Hilversum Jun 22, 2015
You're welcome!

Log in to post comments.

 

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

Support this website.

This library has been a free commmunity resource for FileMaker users and developers for 21 years. It receives no funding and has no advertisements. If it has helped you out, I'd really appreciate it if you could contribute whatever you think it's worth: