AWK is a brilliant little program for processing delimited (any kind of delimiter you like really) data very quickly and easily. Its great for cleaning data before passing trying to push it into a database.

I have a large data file from a client in CSV format that needs cleaning up before trying to import into Ubercart.