cf_compareStrings ( stringWildcard ; stringCompare ; wildChar )

Compare two text strings containing a wildcard.

Be the first to rate this function Log in to vote

Witschi - Show more from this author
Medio-Ingeno AG
https://medio-ingeno.ch

Sample input:

cf_compareStrings ( "myfile*.xml" ; "myfile243535.xml" ; "*" )

Sample output:

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

/*
cf_compareStrings function

Author
Medio-Ingeno AG

Format
cf_compareStrings ( stringWildcard ; stringCompare ; wildChar )

Parameters
stringWildcard - text string containing a wildcard character
stringCompare - text string to compare against stringWildcard
wildChar - any character to serve as wildcard, can only occur once, e.g. "*"

Return values
1 - stringCompare matches with stringWildcard
0 - stringCompare is different from stringWildcard

Description
Compare two text strings with each other to see if they match. One string contains a 
wildcard character that stands for one or more arbitrary characters. The wildcard 
character can be chosen freely but must occur only once in the string. If they match 
1 is returned, otherwise 0.
*/


Let ( [ 
numCharsBeforeWildcard = Position ( stringWildcard ; wildChar ; 1 ; 1 ) - 1 ;
numCharsAfterWildcard = Length ( stringWildcard ) - numCharsBeforeWildcard - 1
] ; 
If ( 
Left ( stringWildcard ; numCharsBeforeWildcard ) = Left ( stringCompare ; numCharsBeforeWildcard )
and
Right ( stringWildcard ; numCharsAfterWildcard ) = Right ( stringCompare ; numCharsAfterWildcard )
 ; 1 ; 0 )
)

Compare two text strings with each other to see if they match. One string contains a
wildcard character that stands for one or more arbitrary characters. The wildcard
character can be chosen freely but must occur only once in the string. If they match
1 is returned, otherwise 0.

Comments

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

cf_compareStrings ( stringWildcard ; stringCompare ; wildChar )

Comments

Support this website.

Support this website.