Separate content in a field

[Guest_imported]

Hi,
I am new with FMP and I am doing this database in which I have to import 900 records. Now, my new database has to have a street # and a street name on separate fields. My old database has the street # and name in the same field. How can I separate the field on my new database? Also I have trouble bringing on my new database another table.

Karen

 

[Schlogg]

Karen
If you can be certain that every record does have a street number, it is fairly simple.
Import your single field into, say, New Field.
Define Street Number and Street Name both as Text
Set Street Number to Leftwords(New Field, 1)
Set Street Name to Rightwords(WordCount(New Field) - 1)

You can set the fields to these values by using Replace or a Loop with Set Field.
In either case, back up first and set these up in a script.
At the end, a sort on Street Number should show up any oddball numbers. Yep, you might have to scan it manually. (A multi-column layout with record number and Street Number.)

Good luck. HTH
Paul


Cheers,
Paul J.