AnsweredAssumed Answered

Contanation Calculation

Question asked by director@charlesmoore.org on Sep 28, 2016
Latest reply on Sep 30, 2016 by philmodjunk

Can anyone offer advice for best practice for simply concatenating several fields, but not including a field and a carriage break if a field is empty?

 

Field 1

Field 2

Field 3

Field 4

Field 5

 

Id like to simply concatenate as shown above.

 

But if any field is EMPTY, then it and its carriage break is not included in the calculation.

 

So if Field 2 is EMPTY, then

 

Field 1

Field 3

Field 4

Field 5

 

Or if Field 2 and Field 3 is EMPTY, then

 

Field 1

Field 4

Field 5

 

Thanks so much!

Outcomes