Break address field into multiple fields

[Cable]

I know there must be a way to do this, but I haven't done much with text field manipulation.

What I'm doing is replacing a SQL database with a FileMaker database that tracks memberships in a non-profit organization. Membership submissions come in as an email in the following format:

John Doe

12345 Anystreet

Anycity, US 12345

999-999-9999

[email protected]

There is also the possibility of a middle initial, additional address line, and the phone number is user formated.

What they've been doing in the existing database is to copy each part of the submitted info and paste it into the repective fields (first name, last name, address, city, etc)

What I want to do is to copy the entire thing, paste it into a text field, and have FileMaker 7 run a script to break apart the address itself.

Any ideas on how to do that?

[dbruggmann]

Hi Cable

Attached you find a sample file, that fits for your needs, I think. You will surely have to adopt a little more for the exceptions of the real world data. But it should give you a good start.

AdressBreaker.fp7.zip

[Cable]

Perfect. Thanks!

[-Queue-]

This can be made easier in version 7 by making use of the MiddleValues function. Substitute( MiddleValues( field; n; 1 ); "