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

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

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?

Create a calculation field of result text called Addresses_Merged:

If (

IsEmpty ( Address2 ) ;

Address1 ;

Address1 & "," & Address2 )

& ","

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.