This is a technique that emulates the search and replace function of a word processor. In fact, it loosely emulates the search and replace feature built into FileMaker. This version is simplified and uses the substitute functions.
You can type in the information you want to search in one field, the information you want to replace it with in another and click a button for it to do it. Unlike word processors, these technique doesn’t allow you to step through each potential replacement one at a time. It is pretty much does all of them or does none of them.
This is done with the Text function of SUBSTITUTE. It’s syntax is tailor made for this operation, Substitute (text, search string, replace string). We recommend putting a button that calls a script that uses the SET FIELD script step. You can set a field equal to itself with modifications.
Set Field [ Example Text ] [ Substitute(Example Text, Find Text, Replace Text) ]
An example file can be downloaded by clicking (here)
© 2010 - Dwayne Wright - dwaynewright.com
The material on this document is offered AS IS. There is NO REPRESENTATION OR WARRANTY, expressed or implied, nor does any other contributor to this document. WARRANTIES OF MERCHANT ABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE EXPRESSLY DISCLAIMED. Consequential and incidental damages are expressly excluded. FileMaker Pro is the registered trademark of FileMaker Inc.