Output Set values of zero not being entered into columns when downloaded

I assumed this would have come up before, but I couldn't find any reference in a search.  If I have an output set element that returns a 1 or a 0, then it appears to work properly when viewed in Tessitura:

But when saving to CSV or TAB, the zeros are converted into nothing:

This seems like a big problem?

Parents
  • I've run into this before, with plus 4 postal code data maybe, and I worked around it changing format of the column from number to text.  Once Excel believes it's a number, it removes 'leading' zeros. In other words, I believe it's a problem of Excel, not Tess, but can't speak to how big a problem, since that depends on who's using Excel and whether they know about the zeros, which I suppose are common in your data. If there's a way to make excel always show leading zeros, I don't know what it is. 

  • It's not Excel in this case, I'm looking at the newly downloaded file in Notepad.  I have had issues in the past with Excel "cleverly" removing leading zeros, but in this case there's simply nothing there.  "0" is being replaced with "".

    In this particular case I'm trying to feed values to Wordfly.  As far as I can tell, Wordfly is dealing with this mess appropriately, at least for some value types, but it's certainly not helping my debugging.

Reply
  • It's not Excel in this case, I'm looking at the newly downloaded file in Notepad.  I have had issues in the past with Excel "cleverly" removing leading zeros, but in this case there's simply nothing there.  "0" is being replaced with "".

    In this particular case I'm trying to feed values to Wordfly.  As far as I can tell, Wordfly is dealing with this mess appropriately, at least for some value types, but it's certainly not helping my debugging.

Children
No Data