• Post Reply Bookmark Topic Watch Topic
  • New Topic

loading a csv file  RSS feed

 
Hasnain S
Greenhorn
Posts: 17
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Greenhorn
Posts: 17
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Greenhorn
Posts: 17
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
bump?
 
Ilja Preuss
author
Sheriff
Posts: 14112
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 547
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!