loading a csv file

[Hasnain S]

i need to load a csv file

which goes like this

F1,F2,F3,F4,F5,F6,F7,x
F8,F9,F10,F11,F12,F13,F14,x

where x is as /n (or next line)
and F1 represent field 1 and the first line is the first record

F1 will go in Jlist1
F2 will go in JList2...and so on until 7 where F8 will go in Jlist1 again but as record 2

how do i achive this using scanner or buffer reader

[Hasnain S]

here is the scanner code but it is not correct

in2 is the input stream

the xxxxModel represent the JList Models, which will add the field to the Jlist

Item is a class i made in which get and set methods for 7 variables are defined
----**************-----------
Scanner scan = new Scanner(in2);
scan.useDelimiter(",");

while(scan.hasNext())
{
Item store = new Item();

store.setType(scan.next());
typeModel.addElement(store.getType());

store.setName(scan.next());
nameModel.addElement(store.getName());

store.setCity(scan.next());
cityModel.addElement(store.getCity());

store.setBox(scan.next.nextInt());
boxModel.addElement(store.getBox());

store.setTelephone(scan.nextInt());
telModel.addElement(store.getTelephone());

store.setFax(scan.nextInt());
faxModel.addElement(store.getFax());

store.setNet(scan.next());
adyModel.addElement(store.getNetAddress());

}

}

[ July 20, 2006: Message edited by: Hasnain SS ]
[ July 20, 2006: Message edited by: Hasnain SS ]

[Hasnain S]

bump?

[Ilja Preuss]

This is not a Swing question. Moving to Java in General, where you are more likely to get an answer....

Take a look at http://faq.javaranch.com/view?HowToAskQuestionsOnJavaRanch to get some tipps on improving your chance to get an answer even further.
[ July 26, 2006: Message edited by: Ilja Preuss ]

[pascal betz]

whats not working ? exception ? stacktrace ?


if the record is of fixed width (seven elements, then a newline symbol in your example), then just read seven elements and add them in the corresponding list and then drop the 8th element and start all over.

perhaps adding a scan.next() as last statement in the loop is good enough ?


pascal