• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Jeanne Boyarsky
  • Liutauras Vilda
  • Campbell Ritchie
  • Tim Cooke
  • Bear Bibeault
Sheriffs:
  • Paul Clapham
  • Junilu Lacar
  • Knute Snortum
Saloon Keepers:
  • Ron McLeod
  • Ganesh Patekar
  • Tim Moores
  • Pete Letkeman
  • Stephan van Hulst
Bartenders:
  • Carey Brown
  • Tim Holloway
  • Joe Ess

loading a csv file  RSS feed

 
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?
 
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 ]
 
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!