I have following script to get vmstat output . I want each column of output in seperate column of Excel file. I have added .xls extension along with output file and checked the file . It was showing each full line per one row which format I don't need? I think some seperator need to introduce in the script? any help on this please?
####### cat /backup/vmstat/vmstat_col.
##This is to collect the vmstat output
/usr/bin/vmstat 60 1440 > /backup/vmstat/vmstat.`dat
2 0 * * * /backup/vmstat/vmstat_col.
ksh >/dev/null 2>&1
I have attached current output file for reference