using System;

using System.IO;

using System.Collections.Generic;

using CsvHelper;

public class Program

{

    public static void Main()

    {

        string text = @"Magasin,Type1,Ville,Type2,Bornes ,mydate,Commentaires

CT01645,- O2K ,HESDIN,Base,- BORNE WIFI,2020-03-02 14:00:00,

CT00046,- O2K ,MULHOUSE,HD,  - 3 BORNE WIFI,2020-03-02 09:00:00,

CT03571,- O2K ,LILLERS,Base, - BORNE WIFI,2020-03-02 09:00:00,

CT00949,- O2K ,RIXHEIM,Base, - BORNE WIFI,2020-03-03 14:00:00,

CT01655,- O2K ,BOULOGNE SUR MER,Base, - 2 BORNE WIFI,2020-03-03 14:00:00,

CT00818,- O2K ,BRUNSTATT,Base, - 2 BORNE WIFI,2020-03-03 09:00:00,

CT02079,- LIS,SCHILTIGHEIM,Base, - BORNE WIFI,2020-03-05 14:00:00,BOITIER 110 DÉJÀ INSTALLE (en prêt)

 ChD 10/01/2020 Attente de RDV dans 1 mois.

CT02768,- O2K ,BETHUNE,Base, - 2 BORNE WIFI,2020-03-05 14:00:00,BOITIER FP110 DÉJÀ INSTALLE

CT01496,- O2K ,OBERNAI,Base, - BORNE WIFI,2020-03-05 09:00:00,";

​

        File.WriteAllText(@"test.txt", text);

​

                List<string> result = new List<string>();

        string value;

        using (TextReader fileReader = File.OpenText(@"test.txt"))

        {

            var csv = new CsvReader(fileReader);

            //csv.Configuration.HasHeaderRecord = false;

            while (csv.Read())

            {

                for (int i = 0; csv.TryGetField<string>(i, out value); i++)

                {

                    result.Add(value);

                }

            }

        }

​

        foreach (var val in result)

        {

            Console.WriteLine(val);

        }

    }

}