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

    PS Variables errors on empty cells


      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:






      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.