Regex code to transform CSV in strings

Question

I need to write a Java program that transform a CSV file into an array list. A CSV line looks like this:

5/3/2010,"Behrens, Michael Lakeside Apts","Lisle, IL 60532",PD: Noise or domestic reports for 3/25 to 4/28 for specific apt.,5/10/2010, 5/10/2010,1

I need it like this:

DATE RECEIVED:5/3/2010  
NAME / COMPANY:Behrens, Michael Lakeside Apts  
CITY, STATE, ZIP:Lisle, IL 60532  
Department / Documents:PD: Noise or domestic reports for 3/25 to 4/28 for specific apt.   
Due Date 5 Days 10 Days:5/10/2010  
DATE COMPLETED:5/10/2010  
Hours Spent Fulfilling Request:1

So far I've got this: ,|[\"] but I need to remove , from ""

Johan Sjöberg · Accepted Answer · 2011-02-16 10:25:02Z

4

What you need isn't regex, it's a csv parser (openCSV).

Alternatively you could do this manually using something like

String[] arr = string.split("(\\\",\\\"|(?<!\\\"),)");
String output = "DATE RECEIVED: " + arr[0] + 
                "\nZIP: " + ...
                "...  " + ...;

edited Feb 16, 2011 at 10:25

answered Feb 16, 2011 at 10:11

Johan Sjöberg

49.4k22 gold badges135 silver badges150 bronze badges

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

7 Comments

gigadot Over a year ago

he has comma inside a quote so simple spliting does not work well. i doubt any csv parser could do this.

Johan Sjöberg Over a year ago

You're right, I didn't pay enough attention, changed it to some magic regex :)

Luke Woodward Over a year ago

The parentheses in your regex are mismatched - there's one more ) than (.

proactif Over a year ago

The parser suggested by Johan (openCSV) can parse this correctly. It will work fine as long as commas only appear in quoted values.

gigadot Over a year ago

Then the csv parser should be used.

|

Collectives™ on Stack Overflow

Regex code to transform CSV in strings

1 Answer 1

7 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

7 Comments

Your Answer

Sign up or log in

Post as a guest

Related