reading a csv file into string array list

i have a csv file with highlighted pattern below.

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

- REPORT: SSA ISSUANCE REPORT

- USER: 12324

- BUSINESS PARTNER:

- DATE/TIME: 06/03/2013 14:20:10

- START DATE:

- END DATE:

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

IssuenceID ,RSO code ,RetailerID ,Inventory Name ,MSISDN ,Serial No

2369 ,NISB1203-0007 ,796254 , ,03479713443 ,8941006090008095228

All i need is to read it in array list in java. The condition of reading is to skip it first from start till first column (IssuenceID). after that i want it to store in arraylist , every column would have a single array list , it means i should read it out in six array list (six columns) along with data of each column as list.

need a code block for above

thanks in advance

Try the following:

import java.io.*;

import java.util.*;

public class Test

{

public static void main(String[] args)

{

ArrayList IssuenceID = new ArrayList();

ArrayList RSO_Code = new ArrayList();

ArrayList RetailerID = new ArrayList();

ArrayList Inventory_Name = new ArrayList();

ArrayList MSISDN = new ArrayList();

ArrayList Serial_No = new ArrayList();

try

{

BufferedReader br = new BufferedReader(new FileReader("faraz.csv"));

String line;

Boolean started = false;

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

{

if(!started)

{

if(line.startsWith("IssuenceID")) started = true;

}

else

{

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

if(items.length != 6) continue; // something wrong with line

IssuenceID.add(items[0].trim());

RSO_Code.add(items[1].trim());

RetailerID.add(items[2].trim());

Inventory_Name.add(items[3].trim());

MSISDN.add(items[4].trim());

Serial_No.add(items[5].trim());

}

br.close();

}

catch(IOException e)

{

System.out.println("I/O Error : " + e);

}

// do something with ArrayLists

}

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Vulpes13y ago
Try the following:

import java.io.*;
import java.util.*;

public class Test
{
public static void main(String[] args)
{
ArrayList IssuenceID = new ArrayList();
ArrayList RSO_Code = new ArrayList();
ArrayList RetailerID = new ArrayList();
ArrayList Inventory_Name = new ArrayList();
ArrayList MSISDN = new ArrayList();
ArrayList Serial_No = new ArrayList();

try
{
BufferedReader br = new BufferedReader(new FileReader("faraz.csv"));
String line;
Boolean started = false;

while ((line = br.readLine()) != null)
{
if(!started)
{
if(line.startsWith("IssuenceID")) started = true;
}
else
{
String[] items = line.split(",");
if(items.length != 6) continue; // something wrong with line
IssuenceID.add(items[0].trim());
RSO_Code.add(items[1].trim());
RetailerID.add(items[2].trim());
Inventory_Name.add(items[3].trim());
MSISDN.add(items[4].trim());
Serial_No.add(items[5].trim());
}
}

br.close();
}
catch(IOException e)
{
System.out.println("I/O Error : " + e);
}

// do something with ArrayLists
}
}