UNIX for Beginners Questions & Answers

Try also

Code:

awk -vDT=$(date +"%d-%b-%Y") 'BEGIN {print "Date         stat1 stat2 stat3 stat4 stat5"} {print DT, $0; DT="           "}' file
Date         stat1 stat2 stat3 stat4 stat5
30-Jun-2017 2878042 455134 3333176 24.231979  23.81
            2880246 453022 3333268 24.141338  23.81
            2879677 453495 3333172 24.310986  23.81

Hello scriptor,

That is one of the way to change digits01to12 to Jan,FEB...Dec, we could do with Rudi's code too.

Now coming on the troubleshooting part for code is not working, it is working fine for me, I am getting output when I am running it without mailx and when I am using mailx getting email too successfully. Could you please try following points.

A- Do following steps.
i- Check if any carriage characters present into your Input_file by following command.

Code:

cat -v Input_file

If you see ^M characters then you should go further.
ii- Remove carriage characters by running following commands.

Code:

awk '{gsub('\r/,"");print} Input_file > temp_file && mv temp_file Input_file

B- If option is A is NOT valid for you and your Input_file doesn't have carriage characters then you may check things like:

1- If your Input_file have any other delimiter rather than space?
2- Check if your Input_file is same as what you have posted in very first post or not?
3- Last but not the least, you haven't mentioned your O.S name so commands which me and Rudi have given will nicely work on *NIX but on a Solaris/SunOS system, change awk to /usr/xpg4/bin/awk , /usr/xpg6/bin/awk , or nawk .

Let me know how it goes then.

Thanks,
R. Singh