I have List<String> which I'm writing to a csv file but each row is written on one cell. How can I split them through "," ? I tried to set the delimiter but still it isn't working.
Code
Writer writer = new FileWriter("D://new.csv", true);
CSVPrinter csvPrinter = new CSVPrinter(writer, CSVFormat.DEFAULT);
csvPrinter.printRecords(myList);
As the documentation states, when you give a List<String> it'll use it a one record, ie one row, ie each String in a cell.
If the given collection only contains simple objects, this method will print a single record like printRecord(Iterable)
You need a code that use the fact that each String is in fact a row, like
passing each String splitted a separate record
List<String> myList = new ArrayList<>();
for (String row : myList)
csvPrinter.printRecord(row.split(","));
Split all String then pass the whole list as a list of records
List<String> myList = new ArrayList<>();
List<String[]> myListSplitted = myList.stream().map(row -> row.split(",")).collect(Collectors.toList());
csvPrinter.printRecords(myListSplitted);
myList?