Combine Address Fields

[jess]

I have an existing contact database where the address is broken into 8 seperate fields. Can anyone help me combine these into a single field?

I tried digging through the FM8 Help section by searching "concatenate" and "append" too, but didn't find anything to help.

The fields are as follows:

House_number

House_suffix

Direction_prefix

Street

Direction_suffix

Street_type

Unit_type

Unit_number

An example could be:

House_number = 275

House_suffix = -1/2

Direction_prefix = West

Street = Riverdpoint

Direction_suffix =

Street_type = Cir

Unit_type =

Unit_number =

Another example:

House_number = 1136

House_suffix =

Direction_prefix = West

Street = 6400

Direction_suffix = South

Street_type =

Unit_type =

Unit_number =

The addresses in Salt Lake can be kind of funny, as we live on a grid/coordinate system (with the mormon temple as the monument)...Typically they will read like this:

1300 South 500 East

or

100 East 4500 South

Thanks for your help!

Jess

[John Mark Osborne]

You can concatenate fields and text in quotes using the ampersand (&) but you will also need to learn the Case and IsEmpty functions since some of your fields could be empty. If a field is empty, you will not want to concatenate the separating space that would go along with the field to separate it from the other field values.

[theyetti]

Hi jess, this one got me for a while as well, have a look at the attached file and see if it helps.

Cheers Pedro :-)

Address_Example.zip

[jess]

Pedro,

Thanks for the file. Looks great! I'll tweak it this week to allow for all of my fields and see how it goes.

Thanks again!

Jess