Parsing sar output text file, tab delimited
Just hired onto law firm IT team and gave me a flat file with sar command output that is roughly 1+ MB (contains cpu, memory, network and other stats). I heard perl is good to parse the necessary information but unsure how to go about this since a noob to programming in general.
The files sit on a linux server (v2.6) in the following file structure: mainfolder | subfolder(abcd format)| subfolder(yyyymm format )| File (ab00 format).
What I need to do:
Tell script to run on specific folder for a given date
Make tab delimited file comma delimited for import into excel (graph)
Parse specific information eg: memory
An example of sar output file for memory:
00:00:01 kbmemfree kbmemused %memused kbbuffers kbcached kbcommit %commit
00:10:01 513224 71524200 99.52 1724160 49148988 14336464 23.33
Any help with this would be greatly appreciated!