AnsweredAssumed Answered

Format Fields for Address mailing lables

Question asked by jamie.hunt on Oct 23, 2009
Latest reply on Dec 8, 2009 by TSGal

Title

Format Fields for Address mailing lables

Post

Hey guys, I hope someone can help me out with this.

 

I have 5 text fields for an address:

 

Address1

Address2

Address3

AddressCounty

AddressPostCode

 

I need a calculation to format each field so that I have the address in one field.

 

What function can I use to look at each field and if there is not a comma at the end, to display the field with a comma on the end.

What function can I use so that if the field is empty it wont display the field in the address.

 

I have already used the Proper function and added carriage returns. 

 

 

Basically at the moment some look like this:

 

House Name,

Street

Town

County,

Postcode

 

 

House Name

Street, 

                    <<empty field

County

Postcode 

 

 

 

 

They all need to look like this

 

House Name,

Street,

Town,

County,

Postcode

 

or if empty field is present:

 

House Name,

Street,

County,

Postcode 

 

 

 

Outcomes