Home / Questions / 181996
Accepted
ortiga
Asked: 2020-07-18 07:53:27 +0800 CST 2020-07-18 07:53:27 +0800 CST

How to save in variables fields of a csv in c # and delete the first line?

  • 772

In my code I pass a number of lines that I want to take from the csv and then, for each line, iterates the elements that make up the csv but I am not getting it, I put the code

test.csv

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

C# class Program {

    static void Main(string[] args)
    {


        int contador = 0;
        int num_lineas;
        string[] array = null;


        var ruta = Directory.GetCurrentDirectory();

        ruta += "/articulo.csv";



        num_lineas = File.ReadAllLines(ruta).Length;



        array = File.ReadAllText(ruta).Split(';');

        while (contador < num_lineas)
        {


            while (true)
            {

                var a = array[contador].Split(',')[0];
                var b = array[contador].Split(',')[1];
                var c = array[contador].Split(',')[2];
                var d = array[contador].Split(',')[3];
                var e = array[contador].Split(',')[4];
                var f = array[contador].Split(',')[5];
                var g = array[contador].Split(',')[6];
                var h = array[contador].Split(',')[7];
                var i = array[contador].Split(',')[8];

                var imagen = array[contador].Split(',')[9];



                Console.WriteLine(c);



                Thread.Sleep(6000);
                break;

            }

            File.Replace(array[contador]); //aqui tengo que borrar la linea que esta dentro del archivo csv


            contador++;

        }





        Thread.Sleep(6000);


    }
}

}

I have modified it like this now I want to delete the first line of the csv any idea....

c#

1 Answers

  1. Best Answer

    Another solution could be to use Linq to read all the lines and in turn output them to a list of a defined class (for better object manipulation) instead of a array. For example, having the following class:

    public class Lista
{
    public string a { get; set; }
    public string b { get; set; }
    public string c { get; set; }
    public string d { get; set; }
    public string e { get; set; }
    public string f { get; set; }
    public string g { get; set; }
    public string h { get; set; }
    public string i { get; set; }
    public string imagen { get; set; }
}

    Using Linq, you will be able to read the file, skip the first line, and in turn, evaluate that the file content contains the proper positions and length.

    var ruta = Directory.GetCurrentDirectory() + "/articulo.csv";

var lista = (from p in System.IO.File.ReadAllLines("").Skip(1)
                  // El método .Skip(1) omite la primer línea que sería el encabezado
              let parts = p.Split(new[] { ',' }, StringSplitOptions.RemoveEmptyEntries)
              where parts.Length == 10
              select new Lista
              {
                  a = parts[0].ToString(),
                  b = parts[1].ToString(),
                  c = parts[2].ToString(),
                  d = parts[3].ToString(),
                  e = parts[4].ToString(),
                  f = parts[5].ToString(),
                  g = parts[6].ToString(),
                  h = parts[7].ToString(),
                  i = parts[8].ToString(),
                  imagen = parts[9].ToString(),
              });
    • 2