How to collect CSV row as array of strings using simpleflatmapper

Question

I'm trying to collect CSV row as array of strings using simpleflatmapper:

try (Reader in = Files.newBufferedReader("path")) {
    return org.simpleflatmapper.csv.CsvParser
//  .mapTo(String[].class)
    .stream(in)
//  .parallel()
//  .flatMap(Arrays::stream)
    .map(line -> {return new ArrayList<>(Arrays.asList(line));})
//  .map(Arrays::asList)
    .collect(Collectors.toList());
} catch (Exception e) {
    e.printStackTrace();
}

As I debug, the line is String[] but the value is entire row (one element) instead of many strings (many cells). How can I got the array of cells?

The CSV file is no special. Ex:
a\t b\t 1\t 2
x\t y\t 3\t 4

The issue as I see in this code .map(line -> {return new ArrayList<>(Arrays.asList(line));}) that the line contains one string value that is the whole line (with tab, space, ...) instead of many strings (each string is the value of each cell).

The whole result I want is List<List<String>> (List of lines). Each line is List<String> (list of cells). The current result is list of lines (rows), each line/row is the whole string.

What CSV parser are you using? Web search seems to only find CSVParser classes. No CsvParser. Since your question is about the Stream generated by CsvParser, how do you expect us to help, when we have no clue what it is? — Andreas
– Andreas, Commented Oct 16, 2017 at 5:00
I have written that I'm using simpleflatmapper but there are three down votes because of this. — aviit
– aviit, Commented Oct 16, 2017 at 6:29
Because few on here know of simpleflatmapper, and you didn't link to it or show import statement. "simpleflatmapper" sounds like something related to the Stream flatMap method, which threw us all for a loop. Also, you haven't shown us the input, so how would we know what you're expecting to see. Perhaps if you provided a Minimal, Complete, and Verifiable example, you wouldn't get down-votes. — Andreas
– Andreas, Commented Oct 16, 2017 at 6:36
Possible duplicate of Java accessing specific element in array of strings — metar
– metar, Commented Oct 16, 2017 at 6:40

Basil Battikhi · Accepted Answer · 2017-10-16 07:20:40Z

0

since the file is CSV, you don't need to use any external lib, so simply you have to read the file as you read a txt file like this

Scanner scanner=new Scanner(new File("MyFile.csv"));
while(scanner.hasNextLine()){
myArray=scanner.nextLine().split(",");
}

answered Oct 16, 2017 at 7:20

Basil Battikhi

2,6682 gold badges23 silver badges36 bronze badges

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

4 Comments

aviit Over a year ago

We must use a library here.

Basil Battikhi Over a year ago

No you don't to use any external lib unless if that the requirment

aviit Over a year ago

Yes, that is the requirement.

Jeronimo Backes Over a year ago

This will only work if the CSV has no quoted fields with delimiters and line breaks inside. Also, it will be way slower than using a proper library.

aviit · Accepted Answer · 2017-10-16 07:46:23Z

0

I have found the solution:

return org.simpleflatmapper.csv.CsvParser
                    .separator('\t')    //<-- solution
                    .stream(in)
                    .map(Arrays::asList)
                    .collect(Collectors.toList());

Thanks all!

answered Oct 16, 2017 at 7:46

aviit

2,1191 gold badge30 silver badges54 bronze badges

Collectives™ on Stack Overflow

How to collect CSV row as array of strings using simpleflatmapper

2 Answers 2

4 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

4 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related