Parsing string from a CSV file to an integer

Question

I have a CSV file which displays a name followed by 3 integers as shown below.

"John","12","37","1000"

I have the 3 number values indexed as values[1], values[2] and values[3].

I am trying to parse the strings from the CSV file by using the following:

int wins = Integer.parseInt(values[1]);
int losses = Integer.parseInt(values[2]);
int money = Integer.parseInt(values[3]);

My problem is that the values in the CSV file already are surrounded by " ", so when I try to parse the string it is trying to parse ""12"", ""37"" and ""1000"".

Is there any way in which I could ignore the " " in the CSV file without deleting them manually in the file?

cwhsu · Accepted Answer · 2013-03-16 15:09:55Z

2

You could use str.replace("\"","") to replace all the " in the string.

answered Mar 16, 2013 at 15:09

cwhsu

1,52325 silver badges32 bronze badges

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

1 Comment

cwhsu Over a year ago

My mistake it should be replace!

brianestey · Accepted Answer · 2013-03-16 15:11:18Z

1

You could take the substring between the quotes

values[1].substring(1, values[1].length() - 1)

answered Mar 16, 2013 at 15:11

brianestey

8,3325 gold badges35 silver badges48 bronze badges

Comments

user2030471 · Accepted Answer · 2013-03-16 15:10:11Z

0

You can use String.substring(int, int) method.

answered Mar 16, 2013 at 15:10

user2030471

Collectives™ on Stack Overflow

Parsing string from a CSV file to an integer

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related