ZapChars ( textToZap ; zapText )
Filters out all characters in a specified string from the supplied text.
Average rating: 4.4 (31 votes) Log in to vote
Function definition: (Copy & paste into FileMaker's Edit Custom Function window)
Here is a function which is the logical inverse of FileMaker 7's Filter( ) function. Whereas Filter( ) removes everything from the supplied text that is *not* in the filter string, this function removes everything that *is* in the zapText string, leaving everything else. Great for getting rid of a host of gremlin characters in one pass.
The function is case sensitive, so if you want to remove 'a' and also 'A' they must both be present in the zapText parameter.
It is possible to achieve the same result by performing multiple substitutions where every character to be removed is separately specified (each being replaced with a null) but for long strings of characters to be zapped, the ZapChars ( ) syntax is much more compact and manageable.
The function utilizes recursion to 'walk' the length of the supplied string omitting any characters that are present in the specified zapText.
|Scott Zeigen MD, Richboro PA
Feb 26, 2011
|Works nice, removes the <CR> character, too|
Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.