1 Reply Latest reply on Jun 10, 2016 11:41 PM by siplus

    I need to replace an abbreviated word in a text field with a whole word, i. e., Street for St.

    sgwilsonky

      I have 65,000 records I need to review.  In each record there is an address line.  I need to see if each record contains an abbreviated word, and if so, change the abbreviation to a whole word.  For example, if the address line contains ST then I would need to change the abbreviation to STREET.  I think this could be done with a script but I am new to FileMaker Pro.  Any help you could provide would be greatly appreciated.