AnsweredAssumed Answered

How to split a field into two fields?

Question asked by AVDOGAUN on Sep 9, 2010
Latest reply on Sep 9, 2010 by LaRetta_1


How to split a field into two fields?


I am translating my databases from SuperBase to FileMaker 11. Due to the space constraint (I originally used SuperBase on Amiga computers) the STATE and ZIP are in one single field. I normally export the SuperBase file either in DbaseIV or Excell format and then import them into FileMaker. Is there a way to extract date from my STATEandZIP field and have it create separate STATE and ZIP fields in FileMaker?

Thank you:   DrG