Parse a csv String and map to a java object

Question

I am trying to parse a csv string like this

    COL1,COL2,COL3
    1,2,3
    2,4,5

and map columns to a java object-

    Class Person{
       COL1,
       COL2,
       COL3;
     }

Most of the libraries I found on google are for csv files but I am working with google app engine so can't write or read files. currently I am using split method but problems with this approach is

column that I am getting in csv string could vary as
```
COL1,COL3,COL2
```
don't want to use boiler plate code of splitting and getting each column.so what I need is list of column header and read all columns in a collection using header mapper. While iterating, map column value to a java object.

There are several question based on similar type of requirement but none of them helped me. If anyone has done this before please could you share the idea? Thanks!

User regular expression to split the csv string. docs.oracle.com/javase/tutorial/essential/regex txt2re.com Use the regex grouping () operator. — TheBetaProgrammer
– TheBetaProgrammer, Commented Sep 17, 2014 at 13:07

Neelam Kapoor · Accepted Answer · 2014-09-17 14:25:00Z

3

After searching and trying several libraries, I am able to solve it. I am sharing the code if anyone needs it later-

    public class CSVParsing {

      public void parseCSV() throws IOException {

      List<Person> list = Lists.newArrayList();

      String str = "COL1,COL2,COL3\n" +
                   "A,B,23\n" +
                   "S,H,20\n";

      CsvSchema schema = CsvSchema.emptySchema().withHeader();

      ObjectReader mapper = new CsvMapper().reader(Person.class).with(schema);

      MappingIterator<Person> it = mapper.readValues(str);
      while (it.hasNext()) {
          list.add(it.next());
      }

      System.out.println("stored list is:" + (list != null ? list.toString() : null));
  }}

answered Sep 17, 2014 at 14:25

Neelam Kapoor

791 silver badge7 bronze badges

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

Comments

Bui Dinh Ngoc · Accepted Answer · 2014-09-19 01:39:11Z

0

Most of the libraries I found on google are for csv files but I am working with google app engine so can't write or read files

You can read file (in project file system). You can read and write file in blobstore, google cloud storage

answered Sep 19, 2014 at 1:39

Bui Dinh Ngoc

4174 silver badges10 bronze badges

Comments

Ross Drew · Accepted Answer · 2014-09-17 13:20:20Z

-1

Use a Tokenizer to split the string into objects then set them to the object.

 //Split the string into tokens using a comma as the token seperator
 StringTokenizer st = new StringTokenizer(lineFromFile, ",");

 while (st.hasMoreTokens()) 
 {
     //Collect each item  
     st.nextElement();
 } 

 //Set to object
 Person p = new Person(item1, item2, item3);

If the columns can be reversed, you parse the header line, save it's values and and use it to decide which column each token falls under using, say, a Map

String columns[] = new String[3]; //Fill these with column names

Map<String,String> map = new HashMap<>();
int i=0;

while (st.hasMoreTokens()) 
{
    //Collect each item  
    map.put(columns[i++], st.nextElement());
}

Then just, create the Person

 Person p = new Person(map.get("COL1"), map.get("COL2"), map.get("COL3"));

edited Sep 17, 2014 at 13:20

answered Sep 17, 2014 at 13:09

Ross Drew

8,2563 gold badges44 silver badges53 bronze badges

2 Comments

Neelam Kapoor Over a year ago

thanks for the reply. but as I said in my question I don't want to get the values, instead want to use an iterator.

Ross Drew Over a year ago

you want something that takes a CSV line and turns it into an object without you having to do any of the coding for it?

Collectives™ on Stack Overflow

Parse a csv String and map to a java object

3 Answers 3

Comments

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related