5 Replies Latest reply on Sep 15, 2017 11:25 AM by davescm

    PS Variables errors on empty cells

    Chuck-ND

      I am working on a data sheet design where we will be outputting 700 or so sheets. After much trouble shooting and reading online I have solved all but one of my problems when importing data from a CSV file. Hopefully one of you can help me out.

       

      I have a section where I am listing application properties, the excel data has a variation of 1 to 5 applications per data sheet, so in my excel sheet it looks like this:

       

       

      Applications_01
      Applications_02Applications_03
      Applications_04Applications_05
      abcdefxyz123
      abcdef
      abcdefxyz123456
      abcdefxyz

       

       

      The problem I am having is the empty cells cause an error "Data set 1 was Incomplete" because when opening up the CSV it looks like the line ends with a comma. A few things I have tried are putting a couple of spaces in each empty cell ( gives me a "program error") and using the bullet special character (outputs as • instead of ).

       

      Any help on this would be great.