adrress merge and commas

[welby]

Hi,

I have two fields namely address1 and address2.

I need to merge these 2 fields seperated by commas.

This is how I achived this:

address1 & "," & address2 & ","

This is fine if both fields are populated, but if the second field is empty I get double ,, at the end of address1. Such as:

address1,,

I have tried to use the Substitute command without little success.

Could anyone please point me in the right direction.

Thank you

[RogerJ]

Why do you need the 2nd set of ",". If you leave it off, it should only show the one ","

Roger in Midland, Tx

Hi,

I have two fields namely address1 and address2.

I need to merge these 2 fields seperated by commas.

This is how I achived this:

This is fine if both fields are populated, but if the second field is empty I get double ,, at the end of address1. Such as:

I have tried to use the Substitute command without little success.

Could anyone please point me in the right direction.

Thank you

[welby]

hi,

the reason is that the resultant file goes into a database that then displays the address as:

,

Just the way it should be.

Hope this helps?

[musicarteca]

Create a calculation field of result text called Addresses_Merged:

If (

IsEmpty ( Address2 ) ;

Address1 ;

Address1 & "," & Address2 )

& ","

[welby]

Hi

thank you for the reply...worked a treat!

Apologies for the delay in reading this.

Been away from the pc for a while.

Thanks again.