Csv Parser

CsvParser.cs

using (Microsoft.VisualBasic.FileIO.TextFieldParser parser = new Microsoft.VisualBasic.FileIO.TextFieldParser("C:\\testfile.txt")) {
  parser.TextFieldType = Microsoft.VisualBasic.FileIO.FieldType.Delimited;
	parser.SetDelimiters(",");
	string[] currentRow = null;
	while (!parser.EndOfData) {
		try {
			currentRow = parser.ReadFields();
			string currentField = null;
			foreach (string field in currentRow) {
				currentField = field;
				Interaction.MsgBox(currentField);
			}
		} catch (Microsoft.VisualBasic.FileIO.MalformedLineException ex) {
			Interaction.MsgBox("Line " + ex.Message + "is not valid and will be skipped.");
		}
	}
}