AnsweredAssumed Answered

Concatenate text

Question asked by AndyHum on Jul 26, 2011
Latest reply on Jul 27, 2011 by philmodjunk

Title

Concatenate text

Post

Looking for help on setting up Concatenate text from multiple fields to a single field.

I have:

Field 1 = Material

Field 2 = Finish

Normally I would do “Material – “ & Material & ¶ & “Finish – ” & Finish

The result would be:

Material – CRS

Finish – ZINC CLEAR CHROMATE

But if one of the field has no data, I do not want to show the embedded Text at all.

I’m thinking use “If” statement with “IsEmpty” but not sure how to construct.

OS = XP

FMP server and client =8.0

Thank you so much in advance!

Outcomes