Regex match a CSV file

I am trying to create a regex to match a CSV file of records in the form of:

optional value, , ,, again some value; this is already, next record;

Now there is an upper limit of commas (10) separating attributes of each record and unlimited number of ; separating each record. Values might or might not b开发者_开发百科e present. I am unexperienced with regex and my effort is rather futile so far. Please help. If necessary, I will include more details.

EDIT

I want to verify that the file is in the required form and get the number of records in it.

---

Do you really need to use regular expressions for this? Might be a little bit overkill. I'd just perform one String.Split() to get the records, then another String.Split() on each record to get the values. Also rather easy to get the number of elements etc. then.

If you really want to use Regexps, I'd use two steps again: /(.*?);/ to get the datasets; /(.*?)[,;]/ to get the values.

Could probably be done with one regexp as well but I'd consider this overkill (as you'd have to find the sub matches etc. identify their parent record, etc.).

Escaped characters would be another thing but rather similar to do: e.g. /(.*?[^\\]);/

---

try this

bool isvalid = csv.Split(';')
                    .Select(c => c.Split(',')
                        .Count())
                    .Distinct()
                    .Count() == 1;

---

Reminds me to the famous article form Coding Horror: Regular Expressions: Now You Have Two Problems.

FileHelpers saved my day when dealing with CSV or other text format.