Example: reading a CSV file
The following
C# example tries to demonstrate how a CSV file might be parsed:
//
// csc -r:Microsoft.VisualBasic.dll read-csv.cs
//
using System;
using System.IO;
using Microsoft.VisualBasic.FileIO;
class Prg {
static void Main() {
using TextFieldParser fieldParser = new TextFieldParser($@"{Directory.GetCurrentDirectory()}\data.csv");
fieldParser.TextFieldType = FieldType.Delimited;
fieldParser.Delimiters = new string[] {";"};
while (! fieldParser.EndOfData) {
string[] fields = fieldParser.ReadFields();
Console.WriteLine(String.Format(" {0,3} | {1,-15} | {2,-3}", fields[0], fields[1], fields[2]));
}
}
}
This is a CSV that was correctly and successfully parsed. (Note the quoted text that contains the semicolons):
5;five;foo
100;one hundred;baz
42;forty-two;bar
-4;"quoted;text";xyz