Hi All,
i have a .Csv file in the below format
startTime, endTime, delta, gName, rName, rNumber, m2239max, m2239min, m2239avg, m100016509avg, m100019240max, metric3min, m100019240avg, propValues
11-Mar-2012 00:00:00, 11-Mar-2012 00:05:00, 300.0, vma3550a, a-1_CPU Index<1>, 200237463, 0.0, 0.0, 0.0, , , , ,
11-Mar-2012 00:05:00, 11-Mar-2012 00:10:00, 300.0, vma3550a, a-1_CPU Index<1>, 200237463, 0.0, 0.0, 0.0, , , , ,
11-Mar-2012 00:10:00, 11-Mar-2012 00:15:00, 300.0, vma3550a, a-1_CPU Index<1>, 200237463, 0.0, 0.0, 0.0, , , , ,
i want to delete 3rd and 14th field and then the following field headers are to be renamed
m2239max, m2239min, m2239avg, m100016509avg, m100019240max, metric3min, m100019240avg
My expected file format should be look like this
startTime, endTime, gName, rName, rNumber, M1max, M1min, M1avg, M2avg, M3max, M3min, M3avg,
11-Mar-2012 00:00:00, 11-Mar-2012 00:05:00, vma3550a, a-1_CPU Index<1>, 200237463, 0.0, 0.0, 0.0, , , , ,
11-Mar-2012 00:05:00, 11-Mar-2012 00:10:00, vma3550a, a-1_CPU Index<1>, 200237463, 0.0, 0.0, 0.0, , , , ,
11-Mar-2012 00:10:00, 11-Mar-2012 00:15:00, vma3550a, a-1_CPU Index<1>, 200237463, 0.0, 0.0, 0.0, , , , ,
I am newbie to Unix and sed.. Let me know if any inputs required.
This is kinda urgent.
Thanks in Advance,
Mahi