【问题】

I have a CSV File, The contents are like this:

Country,Player,Runs,ScoreRate,MatchDate,Weekday,Ground,Versus,URL

Afghanistan,Mohammad Shahzad,118,97.52,16-02-2010,Tue,Sharjah CA Stadium,Canada,../Matches/MatchScorecard_ODI.asp?MatchCode=3087

Afghanistan,Mohammad Shahzad,110,99.09,01-09-2009,Tue,VRA Ground,Netherlands,../Matches/MatchScorecard_ODI.asp?MatchCode=3008

Afghanistan,Mohammad Shahzad,100,138.88,16-08-2010,Mon,Cambusdoon New Ground,Scotland,../Matches/MatchScorecard_ODI.asp?MatchCode=3164

Afghanistan,Mohammad Shahzad,82,75.92,10-07-2010,Sat,Hazelaarweg,Netherlands,../Matches/MatchScorecard_ODI.asp?MatchCode=3153

I have to find the Total Scores by Afganisthan Player in the year 2010.

I wrote a code, But its shows and exception and outputs

java.lang.NumberFormatException: For input string: ""

    at java.lang.NumberFormatException.forInputString(Unknown Source)

    at java.lang.Integer.parseInt(Unknown Source)

    at java.lang.Integer.parseInt(Unknown Source)

    at A.main(A.java:38)

35135

However, the output should be 28 something.

Here is the code.

import java.io.BufferedReader;

import java.io.FileNotFoundException;

import java.io.FileReader;

import java.io.IOException; 

public class A {

    public static void main(String args[]) throws FileNotFoundException

    {

        String csv="C:\\Users\\Dipayan\\Desktop\\odi-batting.csv";

        BufferedReader br=new BufferedReader(new FileReader(csv));

        String line=" ";

        int sum=0;

        int count=0;

        int []a=new int[10000];

        try {

            br.readLine();

        } catch (IOException e) {

            // TODO Auto-generated catch block

            e.printStackTrace();

        }

        try {

            while((line=br.readLine())!=null)

                    {

                String [] f= line.split(",");

                if((f[4]="2010") != null)

                {

                a[count]=Integer.parseInt(f[2]);

                sum=sum+a[count];

                count++;

                }

                    }

        } catch (NumberFormatException | IOException e) {

            // TODO Auto-generated catch block

            e.printStackTrace();

        }

        System.out.println(sum);

    }

}

【回答】

       针对csv的结构化数据计算，直接Java太麻烦了，建议用SPL，脚本如下：

 A1：读取文本

 A2：对满足条件的 ScoreRate汇总

写好的脚本如何在应用程序中调用，可以参考Java 如何调用 SPL 脚本