[CASSANDRA-7639] Cqlsh cannot use .csv files exported by Excel

• Type: Bug
• Status: Resolved
• Priority: Low
• Resolution: Won't Fix
• Fix Version/s: 1.2.19, 2.0.10, 2.1.1
• Component/s: Legacy/Tools
• Labels: osx

Environment

Mac OSX

• Severity: Low
• Assignee: Joshua McKenzie
• Reporter: Philip Thompson

Authors

Joshua McKenzie

• Tester: Philip Thompson
• Created: 29/Jul/14 19:37
• Updated: 16/Apr/19 09:31
• Resolved: 12/Aug/14 16:36

Description

When performing COPY table FROM 'test.csv' on cqlsh across any of the three major branches (1.2, 2.0, 2.1), the following error is thrown:

new-line character seen in unquoted field - do you need to open the file in universal-newline mode?

This happens if the .csv file has windows style line endings, such as if it was created by saving a .csv from excel. This reproduces in both unix and windows environments. This is a simple enough fix. I found that running dos2unix on csv files generated by excel was not sufficient to correct the issue.