1 2 Previous Next 16 Replies Latest reply on Sep 30, 2016 6:44 PM by philmodjunk

    Contanation Calculation

    director@charlesmoore.org

      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!

        1 2 Previous Next