Hi,

I'm trying to create a calculation field to concatenate multiple fields (about 10)into a single field (field1 & field2 etc). Thing is, some of the fields are empty and I do not want to add those fields. Does anyone know of a way to do this?

Thanks,

Grahame.

Use a conditional If[] statement in conjunction with IsEmpty[] function...

If[isEmpty[field], <empty>, <not empty>]

Maybe I'm missing something, but the concatenation of blank fields is still a blank field. You don't need the test. IsEmpty will not detect a field full of spaces as "empty". The calculation can be:

Field1 & Field2 & Field 3 & Field4

The only time you need the IsEmpty is if you are concatenating the fields with a delimiter such as <cr> or dash.

-bd

Ok Vaughan, just to make sure I've got this. Using only three fields to keep this uncomplicated , are you saying I should do the following? (deep breath):

If[isEmpty[field1], field2 & "

Nearly... Let's think the logic out a bit: let's say you want to join the fields together with

Ahhh...yes, that looks better - I seem to have a panache for over complication I'm afraid

Thanks very much for your help.

Regards - Grahame.

quote:

---

Originally posted by Vaughan:

Nearly... Let's think the logic out a bit: let's say you want to join the fields together with

Hi Vaughan,

Hope you don't mind me asking another question related to this last one. The formula you helped me with is working great for my flat-file databases. I'm now trying to achieve something similar with a relational database. The formula I'm using is:

If( IsEmpty(Tel_Dir_cont::Name), "", Tel_Dir_cont::Name & "