Formating a address block

[jdenver]

Ive have the following script to create an address block from the individual fields in a record. Sometimes there is not data in the 'line_address_2' and this script will produce a blank line.

Can someone advise me on what to add so as the 'line_address_2' field is checked for data and if blank then don't create a blank line, whereas if it contains data the data will be added.

 

Thanking you in anticipation.

title & " " & firstname & " " & surname & ¶ & houseno_name & " " & line_address_1 & ¶ & line_address_2 & ¶ & town & ¶ & county  & " " & postcode

[doughemi]

title & " " & firstname & " " & surname & ¶ & houseno_name & " " & line_address_1 & ¶ & if (not isEmpty(line_address_2); line_address2 & ¶; "") & town & ¶ & county  & " " & postcode

Edited August 5, 2015 by doughemi

[mr_vodka]

List ( 

title & " " & firstname & " " & surname;

houseno_name & " " & line_address_1;

line_address_2;

town;

county  & " " & postcode

)

 

 

[Lee Smith]

See if this thread helps

best address

There are several choices.

Edited August 5, 2015 by Lee Smith

[jdenver]

Thanks guys, very helpful, Ill try these suggestions over the weekend