[Solved] How to count the number of characters in a line in a csv file

by


I suggest you to read the javadoc of String.split. I think that you misunderstood the concept when you did this:

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

a[count]=Integer.parseInt(f[2]); //–> java.lang.NumberFormatException here!

Avoid using ‘magic’ numbers in your code like int[] a = new int[24];. Why 24?

Well, here comes a version that do what you want to do. Maybe it isn’t the best way to do this but it works.

public void convertCSVToFlat () throws Exception {
    String csv="Justice_League.csv";
    BufferedReader bReader = new BufferedReader(new FileReader(csv));
    
    //We're storing the values at this 3 arraylists, 
    //but a better approach is using an object to hold'em
    ArrayList<String> lines = new ArrayList<String>();
    ArrayList<Integer> chars = new ArrayList<Integer>();
    ArrayList<String> hex = new ArrayList<String>();
    
    String line = "";
    try {
        while((line = bReader.readLine()) != null) {
            lines.add(line);
            //I'm assuming that you don't want to count the commas and spaces.
            //If you want to, comment the next line
            line = line.replaceAll(",", "").replaceAll(" ", "");
            int c = line.length(); //count remaining chars...
            chars.add(c);
            hex.add(Integer.toHexString(c));
        }
    } catch (IOException e) {
        e.printStackTrace();
    }
    bReader.close();
    
    //Just to show the results
    for (int i = 0; i < lines.size(); i++) {
        System.out.print(lines.get(i));
        System.out.print("\t" + chars.get(i));
        System.out.println("\t" + hex.get(i));
    }
}

Like I said previously, this is a way to solve this. You should try another options to solve this in order to improve your knowledge…

1

solved How to count the number of characters in a line in a csv file