RemoveLinesContaining ( Text ; RedFlag )
It will remove all lines containing the "red flag".
Be the first to rate this function Log in to vote
Philip Wang - Show more from this author
106th Street Wheel and Tire
Function definition: (Copy & paste into FileMaker's Edit Custom Function window)
Similarly you can put in your own "red flag" to filter out the lines that contains the offensive word. For multiple red flags you need to use a script with loops.
The idea is actually quite simple. When a "red flag" is removed, the line became different than the original, so a FilterValue() function will automatically removes all the different lines.
Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.