Formatting a field
I am using FMP 11 Advanced. I have a text field that contains letters and numbers, but the data is not entered consistently. Sometimes there are spaces between a few characters, sometimes there are dashes, sometimes there are colons. I would like to remove those types of characters so the field just has the letters and numbers in it (it is a computer's Mac Address field). In the future I will restrict the field to 12 characters, but would like to fix the current entries before I do that. How can I change this globally so I don't have to change each entry manually that is incorrect?