SubstituteWildcardRange ( text ; searchString ; replaceString )
Replace a wildcard expression with another wildcard expression.
Average rating: 2.9 (85 votes) Log in to vote
Howard Schlossberg - Show more from this author
FM Professional Solutions
SubstituteWildcardRange ( "FileMaker", "*", "*")
SubstituteWildcardRange ( "FileMaker", "*", TextStyleAdd("*"; Bold) )
FileMaker (in bold)
Function definition: (Copy & paste into FileMaker's Edit Custom Function window)
Similar to SubstituteRange, this function can be used to replace a portion of text, given beginning and ending text. But unlike SubstituteRange, this function utilizes a wildcard character ("*") to keep the text between the beginning and ending text. This can be great for replacing format tags, either as HTML or within a FileMaker field (using any of FileMaker's text formatting functions).
By using an asterisk (as the wildcard character) in the middle of the searchString, and anywhere in the replaceString, this custom function will retain the unknown text between your known beginning and end text/tags.
4/15/2011: fixed the recursion call, as it was calling an incorrect function name.
Mar 4, 2019
Add the following to the Case statement before the default option, in order to support uses like:
SubstituteWildcardRange("FileMaker,3", ",*[pilcrow]", ""), which can be used to remove arbitrary endings of strings.
ptBegin > 0 and ptEnd ≥ lenEnd and modText ≠ text; modText;
Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.