c# csv 데이터에 콤마가 있는 경우 처리 방법

String Test = "SomeEmail@Email.com, FirstName, Last Name, \"Some words, words after comma\", More Stuffs";

// extract the fields

Regex CSVParser = new Regex(",(?=(?:[^\"]*\"[^\"]*\")*(?![^\"]*\"))");

String[] Fields = CSVParser.Split(Test);

// clean up the fields (remove " and leading spaces)

for (int i = 0; i < Fields.Length; i++)

{

Fields[i] = Fields[i].TrimStart(' ', '"');

Fields[i] = Fields[i].TrimEnd('"');

}