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