AnsweredAssumed Answered

Split 1 text field into three separate ones

Question asked by PatPhelan on Dec 15, 2016
Latest reply on Dec 15, 2016 by PatPhelan

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.


Thank you.