Home / Questions / 181964
Accepted
ortiga
Asked: 2020-07-18 05:54:27 +0800 CST 2020-07-18 05:54:27 +0800 CST

How to select elements inside a csv in C#?

  • 772

My problem is the following, I have a csv with two lines separated at the end by ; and each word separated by , such that:

test.csv

gato,casa,http,antonio;
perro,abanico,https,libro;

Now I want to select the first row and put each name in variables, for example string cat = cat that comes from the csv only from the first row and then the same with the second I have tried with this code but it is only getting the letters:

c#

   static void Main(string[] args)
    {

        int contador;
        string datos;


        var ruta = Directory.GetCurrentDirectory();

        ruta = ruta + "/prueba.csv";


        var lineas = File.ReadAllText(ruta);

        Console.Write(lineas.Split(';'));


            Console.ReadKey();



    }
c#

1 Answers

  1. Best Answer

    Having these test values:

    gato,casa,http,antonio;
perro,abanico,https,libro;

    I have modified the code to achieve what I understand you are looking to achieve with your program:

    Example:

    static void Main(string[] args)
{
   int contador;
   string datos;

   // Arreglo de strings que guardará las líneas que terminen en punto y coma (;).
   string[] arreglo_lineas = null;

   var ruta = Directory.GetCurrentDirectory();
   ruta = ruta + "/prueba.csv";
   arreglo_lineas = File.ReadAllText(ruta).Split(';');

   Console.log('Esta es la primera línea: ' + arreglo_lineas[0]);
   // Imprimiría: Esta es la primera línea: gato,casa,http,antonio;

   Console.ReadKey();

}
    • 1