Tidying up text in calculation field

[gfcross]

This is my first posting so please be gentle.

I have a layout which requires me to take data from 40 plus fields and merge them. The problem is that as I have to put punctuation between all fields and yet some fields are empty, I end up with multiple punctuation when fields are empty.

Is there a way of stopping this?

[eide]

Use the

IsEmpty(field)

in your calculation. Sometimes

not IsEmpty(field)

makes more sense.

[gfcross]

I had a quick look at IsEmpty and Filemaker's Help states that function is only for numbers and only returns a 1 or a 0.

I am planning to merge 40+ fields into a single field. Some of these fields are empty, but as I am having to place space/punctuation between values in merged field I am ending up with for example:

value one, value two, , , , value six, , value eight, , , , , , value fourteen

when I only want:

value one, value two, value six, value eight, value fourteen

Get the idea. Do you know how I can do this?

[The Bridge]

code:

---

Substitute(

If(not IsEmpty(Trim(Substitute(Field1, "