echo "Month"
echo "Feb_2014"
echo "March_2014"
echo "Apr_2014"
echo "No of files"
grep ,y, Feb_2014.csv |wc -l
grep ,y, Mar_2014.csv |wc -l
grep ,y, Apr_2014.csv |wc -l
echo "Total no of success"
awk -F"," '{x+=$4}END{print x}' Feb_2014.csv
awk -F"," '{x+=$4}END{print x}' Mar_2014.csv
awk -F"," '{x+=$4}END{print x}' Apr_2014.csv
echo "Total no of failure"
awk -F"," '{x+=$5}END{print x}' Feb_2014.csv
awk -F"," '{x+=$5}END{print x}' Mar_2014.csv
awk -F"," '{x+=$5}END{print x}' Apr_2014.csv
Actual output:
Month
Feb_2014
March_2014
Apr_2014
No of files
10
12
12
Total no of success
8
8
8
Total no of failure
6
8
8
But i need the output in columns separated.As this is my 1st week of shell training Please help
Needed output:
Month No of files Total no of sucess Total no of failure
Feb_2014 6 5 7
Mar_2014 8 6 6
Apr_2014 4 4 7