title: OpenCSV Get Value from last row and specific column
body: <p>I am trying to get the values from the second last row and third column in a semicolon separated file.  I can't seat to get the values from the second last row and the third column.  </p>
  
  <p>I have searched for a method to achieve this but it has been fruitless.  I would greatly appreciate if someone could point me in the right direction with an example.</p>
  
  <p>This is the code I have so far:</p>
  
  <pre><code>private static void readmyfile() throws IOException {
  
      String csvFilename = "C:/test.csv";
  
      CSVReader reader = new CSVReader(new FileReader(csvFilename), ';', '\'', 1);
      String[] nextLine;
  
      int rowNumber=-1;
  
      nextLine=reader.readNext();
      while (nextLine!=null){
          rowNumber++;
          String speed = nextLine[rowNumber];
          System.out.println(speed);
          nextLine=reader.readNext();
      }
  }
  </code></pre>
  
  <p>My file is formatted like this:</p>
  
  <pre><code>Number; ID; NUM; Counter; Time
  1;CCF;9999;1;18:07:05
  1;CC8;8888;1;18:07:15
  1;CC1;8888;1;18:07:15
  1;DC7;1111;1;18:07:15
  Date:;01/01/2000; Read:;5; on:;01.05; off:;02.04
  </code></pre>