Jump to content

Combine Address Fields

This topic is 5661 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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:









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


100 East 4500 South

Thanks for your help!


Link to comment
Share on other sites

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.

Link to comment
Share on other sites

This topic is 5661 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Create New...

Important Information

By using this site, you agree to our Terms of Use.