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:

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

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
 Share

×
×
  • Create New...

Important Information

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