How to read specific columns in CSV file java

Question

my CSV file looks like this:

Id;date;code;type;category;name;position;formula
10;;;2010-02-01;;000010;P;W;NormalDays;10;#formelTest
55;;;2050-05-02;;000055;D;C;SpecificDays;55;#formelTest2
60;;;2301-08-03;;000060;A;C;NotNormalDays;60;#formelBlablblabla
75;;;2012-01-08;;000075;P;W;VulgaryDays;75;@formellbalbalbalbababa

I would like to read from it lines by line only from only first column id and last column formula. How can I do this? Thanks for help.

The code:

File file = new File("Filename.csv");
List<String> lines = Files.readAllLines(file.toPath(), StandardCharsets.UTF_8);
for (String line : lines)
   { 
     String[] array = line.split(",");
     System.out.println(array[0]);
   }

File file = new File("Filename.csv"); List<String> lines = Files.readAllLines(file.toPath(), StandardCharsets.UTF_8); for (String line : lines) { String[] array = line.split(","); System.out.println(array[0]); } — Kima321
– Kima321, Commented Jul 14, 2017 at 10:57
Simple read file. I dont have idea how can I read specific columns... — Kima321
– Kima321, Commented Jul 14, 2017 at 10:57
It would be better to edit your question and add the code, for StackOverflow question guidelines — Albert Lazaro de Lara
– Albert Lazaro de Lara, Commented Jul 14, 2017 at 10:58

rlinden · Accepted Answer · 2017-07-14 11:52:23Z

3

Completing your code:

File file = new File("Filename.csv"); 
List<String> lines = Files.readAllLines(file.toPath(), StandardCharsets.UTF_8); 
for (String line : lines) { 
   String[] array = line.split(";"); 
   System.out.println(array[0]+" "+array[array.length-1]); 
}

You will notice that I changed the comma to a semi-colon as the split separator and added a bit to the println, which will be the last item in your split array.

I hope it helps.

answered Jul 14, 2017 at 11:52

rlinden

2,0511 gold badge12 silver badges13 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Kima321 Over a year ago

Yes, it helps :) Thanks

user10651772 · Accepted Answer · 2018-11-14 11:51:45Z

0

String filename = "matches.csv";
    File  file = new File(filename);
    try {
        Scanner sc = new Scanner(file);
        while (sc.hasNext()) {
            String data = sc.next();
            String[] values = data.split(",");
            System.out.println(data);
        }
        sc.close();
    } catch (FileNotFoundException e) {
        e.printStackTrace();
    }
}

answered Nov 14, 2018 at 11:51

user10651772

1

Collectives™ on Stack Overflow

How to read specific columns in CSV file java

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related