AnsweredAssumed Answered

Formatting a field

Question asked by mk4482 on Jun 17, 2011
Latest reply on Jun 17, 2011 by mk4482


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?