AWK One-liners
I was printing out the sizes of different databases and trying to sum them.  The command I was using was:
  
This prints out a two column list of files sizes and file names.  I wanted to turn this into a csv.  What is the best way to do this?  AWK of course.
  
This prints the file name first, comma, file size:
  
You can either cut and paste the output into a spread sheet or redirect it into a csv like so:
  
$ du -s /var/lib/mysql/* | sort n
...
6040    u_labs2
7632    dnvtech3
7828    courtwatch1
19664   statusnet2
23044   drupaldbc1
84896   managingnews0
248056  ibdata1AWK to the Rescue
This print just the file sizes:$ du -s /var/lib/mysql/* | sort n | awk '{print $1}'$ du -s /var/lib/mysql/* | sort n | awk '{print $2 ", " $1}'
u_labs2, 6040
dnvtech3, 7632
courtwatch1, 7828
statusnet1, 19664
drupaldbc2, 23044
managingnews0, 84896
ibdata1, 248056$ du -s /var/lib/mysql/* | sort n | awk '{print $2 ", " $1}' > db-sizes.csv