1 Reply Latest reply on Dec 1, 2016 4:22 AM by [Jongware]

    Need to Delete Particular Column in .csv

    BEGINNER_X Level 3

      Hi All,

       

      1. My Script will read the first line or column Heading,

      if the first line match with the "Report" content, that column should be delete.

       

      For more clarification, please refer the screenshot below (REPORT column need to be delete)

       

      Screen Shot 2016-12-01 at 09.58.44.png

       

      var csvFile=File(Folder.desktop + "/sample.csv");
      csvFile.open("r");
      
      alert(csvFile.readln().split("\r"))
      
      while(csvFile.eof == false)
      {
          var myColumn = csvFile.readln().split(",");
          
          alert(myColumn[2])
          
          myColumn[2].remove();   //Help this line
          
      }
      

       

      Kindly help for the above request.

       

      Regards

      Siraj