[jira] [Created] (ZEPPELIN-2956) Downloaded CSV/TSV data will get unexpected division when the column value contains both delimiter and quotation mark.

[bruce xu (JIRA)]

bruce xu created ZEPPELIN-2956:
----------------------------------

             Summary: Downloaded CSV/TSV data will get unexpected division when 
the column value contains both delimiter and quotation mark.
                 Key: ZEPPELIN-2956
                 URL: https://issues.apache.org/jira/browse/ZEPPELIN-2956
             Project: Zeppelin
          Issue Type: Bug
          Components: front-end
    Affects Versions: 0.7.3, 0.7.2, 0.6.2
         Environment: zeppelin 0.7.2
jdk 1.7
            Reporter: bruce xu
            Priority: Critical



After downloading csv/tsv data from paragraph, I opened the file through excel 
and found that the data is not seperated as expected. 

Then I found that's because the colunm value contains both  *{color:red} 
delimiter and quotation mark{color},* so excel could not recognize and seperate 
the value well.

Here is a csv data example:

hello,beijing,i,love,you   ->  can be well recognized
hello,beijing,i,lo"v"e,you   ->  can be well recognized
hello,beijing,i,lo"v,"e,you   ->  can not be well recognized








--
This message was sent by Atlassian JIRA
(v6.4.14#64029)