Substitute ‘\r’ in Excel output to ‘\n’ for Unix

When outputing tsv from Excel directly, it added an unpleasant ‘\r’ at the end of each line. And you won’t even notive it by opening the file in TextWrangler. It can be checked by head -n 2 input.txt, you will see the difference.

Here is how to replace the ‘\r’ with ‘\n’:

cat input.txt | tr '\r' '\n' > output.txt
cat input.txt | tr '^M' '\n' > output.txt

While typing ^M in the command, do not use shift+6 & M. You should use ctrl+v+m