insert comma between data

[LasseJ]

hi all

I have seperated my customer adresses in separated in three fields: 'street' 'number' and 'floor' in my database.

My problem is how to separate 'number' and 'floor' with a comma, when merging the data into a letter template in FM.

I only need a comma if the adress actually includes a floor.

I guess I'm looking for a solution where a comma only is included if there is no data in 'floor'.

But I cant figure out how. Can anyone help?

Regards

Lasse

Edited January 8, 2008 by Guest

[stanley]

Lasse:

You should consider using a fourth field, a calculation field, for your letter template.

In the calculation definition, you would have something like this (with your fields named 'Street', 'Number' and 'Floor':

Street & " " & Number & Case(IsEmpty(Floor);"";", " & Floor)

So, if you have no data in Floor, the calculation puts "" after Number. If there is data in Floor, the calculation puts in ", " and then the Floor. Note also that I have put a space in between Street and Number. Remember to make sure that the calculation result is text.

Hope that helps.

-Stanley

[LasseJ]

Hi Stanley

Thank you very much. I added a forth field and it works perfect.

Best regards

Lasse