Search Results

What happens if you do not SED the file? And email it.
Can you open it then?

By the way, xls files can be funny. I often work with csv files which are easier to manipulate and without fear of...

tr -d '\015' < abc.csv > def.csv
mv def.csv abc.csv

If you don't have header in your input file then remove NR > 1 from awk

Hello karthik,

Seems you are using a Solaris/SunOS system, on a Solaris/SunOS system, change awk to /usr/xpg4/bin/awk , /usr/xpg6/bin/awk , or nawk.

Thanks,
R. Singh

If you are on Solaris/SunOS system, change awk at the start of the script to /usr/xpg4/bin/awk or /usr/xpg6/bin/awk or nawk .