I have a cronjob that run monthly to generate some report from our system. However, the current output is as below:
Uptime
100
45
50
Average CPU
2.36
15.6
70.8
How can I generate the output into a CSV file in a table format, something like
Uptime Average CPU
100 2.36
45 15.6
50 70.8
Use below command:
pr -2 l.txt | sed '/^$/d' | sed -r "s/\s+/ /g" |sed '1d'
l.txt contains the text which you have mentioned in post. Output:
$ pr -2 l.txt | sed '/^$/d' | sed -r "s/\s+/ /g" |sed '1d'
Uptime Average CPU
100 2.36
45 15.6
50 70.8
pr is the right tool. You don't need sed: just add -T and -s options to pr: pr -2Ts file
Using the rs (reshape) command: given
$ cat output
Uptime
100
45
50
Average CPU
2.36
15.6
70.8
then
$ rs -et 0 2 < output
Uptime Average CPU
100 2.36
45 15.6
50 70.8
You can change the output delimiter with -C e.g.
$ rs -et -C, 0 2 < output
Uptime,Average CPU,
100,2.36,
45,15.6,
50,70.8,
