Output sar command results to a csv file
I know this is kind of old but you should, or could, use sadf -dh -- <sar command>. It is part of the sysstat package and it will give you the csv output without any need for awk and regex. Actually, the latest versions are also able to output the info to JSON and XML. You can just pick your poison :)
Simple example:
$ sadf -dh -- -plocalhost.localdomain;-1;2014-06-13 08:47:02 UTC;LINUX-RESTART# hostname;interval;timestamp;CPU;%user;%nice;%system;%iowait;%steal;%idle[...]localhost.localdomain;600;2014-06-13 09:00:01 UTC;-1;8.80;0.01;1.65;9.51;0.00;80.03localhost.localdomain;600;2014-06-13 09:10:01 UTC;-1;3.03;0.71;2.41;0.81;0.00;93.05
sar -d -u -w 1 1 | grep -v Average | grep -v Linux |awk '{if ($0 ~ /[0-9]/) { print $1","$2","$4","$5","$6; } }'22:14:04,CPU,%nice,%system,%iowait22:14:05,all,0.00,8.53,0.0022:14:04,proc/s,,,22:14:05,0.00,,,22:14:04,DEV,rd_sec/s,wr_sec/s,avgrq-sz22:14:05,dev8-0,0.00,0.00,0.00outputs above enjoy