Combining field content

[Phillip Holmes]

Hello all,

I need to calc field "Combined_ALL" that brings together the contents of 3 other text fields.

The only issue I have is that the calc field needs to place a carrige return only between the fields that actually have data in them.

I have tried to figure this out and have come up short.

[bruceR]

Hello all,

I need to calc field "Combined_ALL" that brings together the contents of 3 other text fields.

The only issue I have is that the calc field needs to place a carrige return only between the fields that actually have data in them.

I have tried to figure this out and have come up short.

That's exactly what the List function does; but it is only available in 8.5+.

[Lee Smith]

the simple calculation would look like this;

Field1 & "¶" & Field2 & "¶" & Field3

However, this would also give you double return for those fields that are empty.

Case ( not IsEmpty ( Field1) ; Field1 & "¶") &

Case ( not IsEmpty (Field2) ; Field2 & "¶" ) &

Case ( not IsEmpty (Field3) ; Field3)

HTH

Lee

Edited April 24, 2008 by Guest