New Line Issues with CSV Files (Windows / Unix conversion)

Some files exported on Windows/Dos machines have a different new-line format.

Because SQream uses the UNIX new-line format, it is recommended that you convert your file before bulk inserting.

You can do this on your own machines by using the dos2unix executable commonly found on

On CentOs or Ubuntu:

$ sudo yum install dos2unix
or
$ sudo apt-get install tofrodos
On Windows machines, you can use this native port.

Syntax

dos2unix <file_name>

Example

$ dos2unix test.csv
  • 49
  • 09-Aug-2015
  • 339 Views