9 Replies Latest reply on Oct 29, 2013 11:11 AM by markgordie

    Remove empty fields (with bullets) in a 'Merge Field'

    markgordie

      Title

      Remove empty fields (with bullets) in a 'Merge Field'

      Post

           I am able to create a list with bullet by creating a single field [Outcome_Lists] with the following calculation:

           Char (8226) &  " "  & Outcomes & "¶" & Char (8226) &  " "  & Outcomes Copy & "¶" & Char (8226) &  " " &  Outcomes Copy2 & "¶" & Char (8226) &  " "   & Outcomes Copy3 & "¶" & Char (8226) &  " " & Outcomes Copy4 & "¶" & Char (8226) &  " " &  Outcomes Copy5

           This give me a list with a bullet in front of each line.  However, not all the fields within this calculation are necessarily populated.  On a blank layout, I inserted a text box with a Merged Field [Outcome_List] with the above calculation.  The problem is, every field from the calculation is inserted on the layout due to the fact there is a bullet in each field.  

           My question is, is there a way to remove the fields that do not have any data (other that the bullet) removed from the layout or at least when you go into Preview?

           Thank you,

           Mark