Member Avatar for Xessa

Hello

I have a csv file and i want to read data from it and pass the data to the database.

Now.

I have values that are seperated with semicolons.

The file is like this.

customerID;name;surname;phoneNumber

1;Gokhan;Terzioglu;333444333
2;Melih;Terzioglu;555444333


There are 100.000 columns like this. How can I read the data effectively?

I also don't know how to read from csv file. The problem here seems that the columns are seperated with semicolons instead of commas...

Edited by Xessa because: n/a
  • 2 Contributors
  • 1 Reply
  • 105 Views
  • 6 Hours Discussion Span
  • Latest Post Latest Post by parry_kulk
Member Avatar for parry_kulk

Hi,

You can use the opencsv library. It will help in read/write csv files.
It also has constructors that let you supply your own seperator. i.e. you can specify semicolon as the seperator

http://opencsv.sourceforge.net

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.