parse csv file in csharp

main.cs
using Microsoft.VisualBasic.FileIO; // add this namespace to your code file

// define the CSV file path
string filePath = @"C:\path\to\file.csv";

// create a TextFieldParser object and set its properties
TextFieldParser parser = new TextFieldParser(filePath);
parser.TextFieldType = FieldType.Delimited;
parser.SetDelimiters(",");

// read the CSV file line by line
while (!parser.EndOfData) {
    // get the current line and split it into fields
    string[] fields = parser.ReadFields();

    // do something with the fields (e.g. print them to the console)
    foreach (string field in fields) {
        Console.Write($"{field}\t");
    }
    Console.WriteLine();
}

// close the TextFieldParser object
parser.Close();
724 chars
25 lines