自定义函数: cf_compareStrings ( stringWildcard ; stringCompare ; wildChar )

2020年5月18日 • String

函数功能描述

来源:

作者:

作者原述:

猫壹佰描述:

比较两个字符串, 判断第二个字符串是否符合第一个字符串规范模版的格式.

第3个参数是一个字符串规范模版的通配字符, 通配字符可以是任意字符,但在字符串模版中只能出现一次.

测试文档下载:

调用范例

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

返回结果

函数内容

/*
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 )
)

当前页面使用FileMaker生成发布, 更新于2021年3月15日0时50分57秒

← 较旧的文章较新的文章 →