Java - Splitting a CSV file into an Array

Question

I have managed to split a CSV file based on the commas. I did this by placing a dummy String where ever there was a ',' and then splitting based on the dummy String.

However, the CSV file contains things such as:

something, something, something
something, something, something

Therefore, where there is a new line, the last and first values of each line get merged into their own string. How can I solve this? I've tried placing my dummy string where \n is found to split it based on that but to no success.

Help?!

Why didn't you split directly using commas? Anyway, post a sscce.org to get better help. — jalopaba
– jalopaba, Commented Feb 2, 2012 at 11:59

Kris · Accepted Answer · 2012-02-02 12:00:30Z

6

I would strongly recommend you not reinventing the wheel :). Go with one of the already available libraries for handling CSV files, eg: OpenCSV

answered Feb 2, 2012 at 12:00

Kris

5,7923 gold badges29 silver badges47 bronze badges

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

Comments

dogbane · Accepted Answer · 2012-02-02 12:25:06Z

5

I don't see why you need a dummy string. Why not split on comma?

BufferedReader in = new BufferedReader(new FileReader("file.csv"));
String line;
while ((line = in.readLine()) != null) {
    String[] fields = line.split(",");
}

edited Feb 2, 2012 at 12:25

answered Feb 2, 2012 at 11:58

dogbane

276k77 gold badges407 silver badges415 bronze badges

2 Comments

mino Over a year ago

This doesn't help me split based on lines. That was the question.

dogbane Over a year ago

you're supposed to read each line and split each one separately. Then you wouldn't have the problem of lines merging.

xiaolei yu · Accepted Answer · 2015-05-17 00:32:12Z

As per the dummy strings you mentioned, it could be easily processed with the help of an existing library. I would like to recommand the open source library uniVocity-parsers, which procides simplfied API, significent performance and flexibility.

Just refer to few lines of code to read csv data into memory with array:

private static void parseCSV() throws FileNotFoundException {
    CsvParser parser = new CsvParser(new CsvParserSettings());
    List<String[]> parsedData = parser.parseAll(new FileReader("/examples/example.csv"));

    for (String[] row : parsedData) {
        StringBuilder strBuilder = new StringBuilder();
        for (String col : row) {
            strBuilder.append(col).append("\t");
        }
        System.out.println(strBuilder);
    }
}

user2158173 · Accepted Answer · 2013-03-11 18:55:23Z

-1

use the followin it will split lines

               String[] a=scanner.next().split(" ");

answered Mar 11, 2013 at 18:55

user2158173

1

Collectives™ on Stack Overflow

Java - Splitting a CSV file into an Array

4 Answers 4

Comments

2 Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

2 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related