fnBackSlashForQuery ( String )
substitute Backsplash \ when query
Average rating: 5.0 (1 vote) Log in to vote
|
Shanghai Zhao - Show more from this author
Shanghai YouLu |
Sample input:
fnBackSlashForQuery("a\b")
Sample output:
a\\b
Function definition: (Copy & paste into FileMaker's Edit Custom Function window)
symbol \ , Backsplash , when query such like a\b, when just input "a\b", the query will be invalid. the symbol \ must be substitute , just as this function
在执行查找时，比如字段值为a\b，如果查找时只输入"a\b"，则查找不到需要的结果。此时需要输入"a\\b"来查找，则会找到对应的值为a\b。此自定义函数即是用于处理只有一个\的查询情况。
Comments
Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.