String.split() regular expression

Regular expression escapes me. I have a line of a CSV file that looks like this:

1,,3,2,45.00,"This & That, LLC",0

I want the string split by commas but the problem with the line above is there's a comma in the name of the company...I obviously don't want the company name split in half...what would the regular expression be that I would provide to the split method to ensure that only commas not found in between double quotes are used to split the string into an array of Strings? is this possible?

Thanks in advance!

Rob

[561 byte] By [rlb3778a] at [2007-10-1 5:01:36]
# 1
There are a few libraries for reading CSV files.One even allows you to perform SQL queries and up dates on the CSV file.google is your friend.
Peter-Lawreya at 2007-7-9 5:40:49 > top of Java-index,Administration Tools,Sun Connection...
# 2
Telling someone to google might be deserved, but it is mean and unhelpful.If you want to find a regex for CSV's see O'Reilly's "Mastering Regular Expressions" Section 8.4.4.3. Either buy the book - it's worth it - or subscribe to safari.
sbeynona at 2007-7-9 5:40:49 > top of Java-index,Administration Tools,Sun Connection...
# 3
I have written a parser for CSV files and found it much simpleir to just process the line one character at a time.for example, if you have a " and a , in a cell then it appears something like"a "" and a , "
Peter-Lawreya at 2007-7-9 5:40:49 > top of Java-index,Administration Tools,Sun Connection...