FileMaker Pro Custom Functions

List  |  Show Random  |  Upload  |  Add This to Your Site

ZapChars ( textToZap ; zapText )

Rate this function:  

Ray Cologon, NightWing Enterprises
http://www.nightwing.com.au/FileMaker

Filters out all characters in a specified string from the supplied text.

Description:

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.

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

This is my Custom Function and I want to edit it

Discuss:

Make a comment about this Custom Function (please try to keep it brief & to the point). Anyone can post: