Quick script to display df as a CSV

pobman · #1 (**permalink**) 11-20-2008

Hi ,

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

I am guessing it is something like:

Code:

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"

I have also tried

Code:

for i in `df -kP` ; do echo $i |awk ' {print $1 "," $2 "," $3 "," $4 "," $5 "," $6 "," $7 } '; done

Again with bad results.

Is their an easy way to achieve this?

UPDATE:
I have the code almost working doing this:

Code:

         COUNTLINES=0
         NUM=`df -kP |wc -l`
         COUNTLINES=`expr $COUNTLINES + $NUM - 1`
         df -kP |head -n 1| awk ' {print $1 "," $2 "," $3 "," $4 "," $5 "," $6 " " $7} '
         df -kP |tail -n $COUNTLINES| awk ' {print $1 "," $2 "," $3 "," $4 "," $5 "," $6} '
         df -kP |tail -n $COUNTLINES| awk ' {print $1 "," $2 "," $3 "," $4 "," $5 "," $6} '

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
Quick Question on sed command in shell script	luft	Shell Programming and Scripting	4	09-10-2008 06:36 PM
Guidance needed for quick script	senthilkumar_ak	UNIX for Advanced & Expert Users	4	08-08-2008 07:59 AM
quick script C shell	ajp7701	Shell Programming and Scripting	1	03-18-2008 04:31 PM
Quick help needed in the Shell Script	namishtiwari	Shell Programming and Scripting	1	02-01-2008 09:44 AM
need a quick basic shell script help	eb222	Shell Programming and Scripting	6	11-22-2007 09:00 AM

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode	Rate This Thread:


	Powered by