* Barry wrote, On 30-7-2007 12:22:

[^\",\r\n]+ in your Field definition requires at least one character in
to match (+ means one or more). Change this to * (zero or more) and
things should start working.

Regex regex = new
    Regex("((?<field>[^\",\r\n]*)|\"(?<field>([^\"]|\"\")*)\")(,|(?<rowbreak>\\r\\n|\\n|$))");

From the regex it looks like you're trying to read multiple lines with
one Regex.Match call. This could become very expensive.

You could also give this a try:
(?:(?:^|,)(?:"(?<field>(?:[^"]|"")*)"|(?<field>[^"\r\n,]*)))*\r?$

(\r? at the end is to compensate for a bug in the .NET 2.0
implementation of the regex parser.)

It will match a whole line in one match object. You can extract the
values with the following code:

Regex rx = new Regex("...", RegexOptions.MultiLine);

Match m = rx.Match(input);
if (m.Success) // while (m.Success)
{
    foreach (Capture c in m.Groups["field"].Captures)
    {
        string extracted = c.Value;
    }
    // m = m.NextMatch();
}

If you have an input string that contains multiple lines you can use the
while(m.Success) in combination with m = m.NextMatch(); which I've
commented out in the code above to loop through all the results in the
input.

I'm not sure exactly what you're doing with the values you've captured,
but you might also want to have a look at the OleDB delimited text
driver which allows you to load the contents of a comma delimited text
file into a dataset, saving you the trouble. Or you could try and use
SQL Server Integration Services to load the data directly into a database.

Jesse