Quick script to display df as a CSV

pobman · 11-20-2008, 06:50 PM

Hi ,

Can some one show me how to display a df -k as a CSV.

I am guessing it is something like:

df -kP /home | awk ' {print $1 "," $2 "," $3 "," $4 "," $5 "," $6} '
but it does not output correctly as the fields are not in line.
I could try to use a delimiter but there is a space in the word "Mounted On"

Is their an easy way to achieve this?

MensaWater · 11-20-2008, 07:09 PM

You pretty much had it but.

I've adjusted it as follows:

Code:

df -kP /home | awk '{print $1","$2","$3","$4","$5","$6" "$7}'

First I took out all your unnecessary spaces.
Second I put the literal commas surround by quotes between each of the first 6 fields.
Last I inserted a space with quotes around it between field 6 and 7. This makes it print the "Mounted on" as single field in your CSV. It works for the subsequent lines as well because there is no field 7 so it just outputs field 6 for the actual /home line followed by an extra space which doesn't hurt the CSV for when you open it in MS-Excel.

When I ran that on one of my RHEL5 systems it resulted in:

Quote:

Filesystem,1024-blocks,Used,Available,Capacity,Mounted on
/dev/mapper/VolGroup00-LogVol03,2063763,84550,1874356,5%,/home