I am relatively new to FileMaker and have a database I imported from another source.
One text field is structured thus: City, State - Structure Name
City and State are separated consistently by a comma; state and structure name are consistently separated by a dash; the structure name includes everything to the right of the dash and may contain punctuation.
I would like to put the City in a city field, state in state, and structure name in a separate field.
I'm unsure how to accomplish this and would greatly appreciate help.