search

shancarter / mr-data-converter

Takes CSV or tab-delimited data from Excel and converts it into several web-friendly formats, include JSON and XML.
http://shancarter.github.com/mr-data-converter/
Other
1.96k stars 777 forks source link

BUG on 5th colum #50

Open Testato opened 7 years ago

Testato commented 7 years ago

if you use a .tsv file divided in 5 colums, but: 1) only the first colum have a value on colum 5 2) have >10 rows

The system made error in create json file, the first key:value pair of TEST5Colum do not have "" And all the other TEST5Colum value is Null instead of ""

Try the bug with this:

NAME    VALUE   COLOR   DATE    TEST5Colum
Alan    12  blue    Sep. 25, 2009   Pippo1
Shan    13  "green  blue"   Sep. 27, 2009   
John    45  orange  Sep. 29, 2009   
Minna   27  teal    Sep. 30, 2009   
Alan    12  blue    Sep. 25, 2009   
Shan    13  "green  blue"   Sep. 27, 2009   
John    45  orange  Sep. 29, 2009   
Minna   27  teal    Sep. 30, 2009   
Alan    12  blue    Sep. 25, 2009   
Shan    13  "green  blue"   Sep. 27, 2009   
Shan    13  "green  blue"   Sep. 27, 2009

Result:

[{"NAME":"Alan","VALUE":12,"COLOR":"blue","DATE":"Sep. 25, 2009","TEST5Colum":Pippo1},
{"NAME":"Shan","VALUE":13,"COLOR":"green\tblue","DATE":"Sep. 27, 2009","TEST5Colum":null},
mrthan commented 6 years ago

I'm getting this issue too, I thought it was naming. But regardless of the output type, the 5th column output is missing quotes.