sqlldr not recognizing new line/row
The obvious solution is to have your tool generate the output in the proper format.

If that is not possible, just use dos2unix or unix2dos on the file before processing, depending on the direction you need. Both utilites are provided as part of the dos2unix package that can be installed from the default Linux repositories, or downloaded seperately.

Other alternatives involve perl, sed or tr: https://en.wikipedia.org/wiki/Unix2dos

unix2dos:


perl -i -p -e 's|[\r\n]+|\r\n|g' file

  
  or

sed -i -e 's/\r*$/\r/' file



dos2unix:


tr -d '\r' &lt; file &gt; file2 # For ASCII and other files which do not contain multibyte characters (Not utf-8 safe).

  
  or

perl -i -p -e 's/\r//g' file

  
  or

sed -i -e 's/\r//g' file