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

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.

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

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