macos - Converting newline formatting from Mac to Windows

Question

I need a conversion utility/script that will convert a .sql dump file generated on Mac to one readable on Windows. This is a continuation of a problem I had here. The issue seems to be with newline formatting in text files, but I can't find a tool to make the conversion...

Answer 1

Windows uses carriage return + line feed for newline:

Unix only uses Line feed for newline:

In conclusion, simply replace every occurence of by .
Both unix2dos and dos2unix are not by default available on Mac OSX.
Fortunately, you can simply use Perl or sed to do the job:

sed -e 's/$/
/' inputfile > outputfile                # UNIX to DOS  (adding CRs)
sed -e 's/
$//' inputfile > outputfile                # DOS  to UNIX (removing CRs)
perl -pe 's/
|
|
/
/g' inputfile > outputfile  # Convert to DOS
perl -pe 's/
|
|
/
/g'   inputfile > outputfile  # Convert to UNIX
perl -pe 's/
|
|
/
/g'   inputfile > outputfile  # Convert to old Mac

Code snippet from:
http://en.wikipedia.org/wiki/Newline#Conversion_utilities