Extract ZIP Code

[steigrafx]

I need to extract the ZIP code from an address. I'm having no luck figuring this out on my own.

The addresses are all contained in one field, and sometimes they contain 3 lines, sometimes 4. For example:

Absolute Transcription

87 Village Lane

Canton, CT 06019

or

J&J Court Transcribers, Inc.

268 Evergreen Avenue

P.O. Box 3211

Hamilton, NJ 08619

I need the ZIP codes so I can make a list of addresses according to area.

Thanks for any help you can provide.

Kevin

[Lee Smith]

You have more than one problem. Your data structure needs to be change. Each of these should have their own field.

In other words,

NameFirst

NameLast

StreetAddress

City

State

Zip

PhoneNumbeer, and so on.

If you have no control over data entry, there are some CFs, or calculations that you can use to parse this information out.

However, I would change the structure first.

You need to Update your profile to reflect the Platform, Operations System, and Version of FileMaker.

Lee

[steigrafx]

Thanks, Lee. I've updated my profile.

The addresses in my database are static, so to speak. There are minor changes on an annual basis. It is a collection of court transcript services.

When an attorney orders a transcript, I would like to be able to provide a list by ZIP code so that the attorney can select a transcript service local to his or her office.

Thanks again,

Kevin

[comment]

I believe you can extract the ZIP code as =

RightWords ( Address ; 1 )

Still, it would be best to have a separate field for each component of the address, as Lee said.

[steigrafx]

Thank you, Comment. Works perfectly.

And yes, I think I'll separate the addresses into separate fields as Lee suggested. But right now, your calc is the perfect bandaid.

Kevin