How to ignore a character while Splitting a string in C#

Question

I've a string like this

 1,2,3,"a,b,c",4,"5,6"

I want split above string using .Split(',');

Expected:

Actual: As usual, it is splitting 4 and 6 also. It is default behaviour. But any other ways where can i get ehat i am expecting?

CSV parsers are extremely common. A simple google search of the terms `C# CSV` will yield a huge amount of results. — Pierre-Luc Pineault, Nov 05 '15 at 06:38
I got it. Thanks. Ref: http://stackoverflow.com/questions/7854550/csv-parser-to-parse-double-quotes-via-oledb, Method: ParseRowToList — Prasad Kanaparthi, Nov 05 '15 at 06:38

Rahul Tripathi · Accepted Answer · 2015-11-05T06:43:06.737

1

Try like this:

var result = Regex.Split(myString, ",(?=(?:[^\"]*\"[^\"]*\")*[^\"]*$)\");

edited Nov 05 '15 at 06:43

answered Nov 05 '15 at 06:37

Rahul Tripathi

Thanks Rahul for your Solution, save more time of mine :) – Shailesh Jun 14 '17 at 11:30

1 Answers1