Improperly formatted data is one of the scourges of database housekeeping. For a mature system, it’s like cleaning out the pantry. You don’t have to do it every week, but you will be faced with it a few times each year. When migrating information from an old system to a new FileMaker database, the volume of malformed data can approach plague of locust proportions. This week we’ll look at a triad of functions that can help with one kind of formatting headache: incorrect capitalization.
- Published in FileMaker Functionality