3 Replies Latest reply on Aug 6, 2015 3:52 AM by Peter Spier

    Split merge fields with tabs, how to remove if there is no data

    reemprive

      Hi,

       

      I have an Idesign document that merges field from an csv file. The documents merge fields are seperated with a tab, for example:

      {1001}     {1002}     {1003}

      {2001}     {2002}     {2003}

      {3001}     {3002}     {3003}


      etc.

       

      In some cases there is no data available in the csv file. This results in a blank line in the document with only 2 tabs. Because the actual number of generated letters is huge we have to remove the blank lines. How do I resolve this problem? Is there a way to only use tabs if there is data in the fields and remove the line if there is no data available?