Forums Register Login

loading a csv file

+Pie Number of slices to send: Send
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
+Pie Number of slices to send: Send
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 ]
+Pie Number of slices to send: Send
bump?
+Pie Number of slices to send: Send
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 ]
+Pie Number of slices to send: Send
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
Friends help you move. Good friends help you move bodies. This tiny ad will help:
a bit of art, as a gift, that will fit in a stocking
https://gardener-gift.com


reply
reply
This thread has been viewed 1404 times.
Similar Threads
Arrays
What Compiler can tell and can't tell
Why is this thread closed?
A flatland puzzle
overloaded func, both accept same no and type of parameters
More...

All times above are in ranch (not your local) time.
The current ranch time is
Mar 28, 2024 03:41:41.