I have referred this document and installed csv driver and gave connection to csv driver.
Previously we have used csv files and to read the data from csv files we have used the following code.
new File("path of the csv file").splitEachLine(",") {
fields ->//fields[0]-->extracted first column from the csv file
}
Now we want to use csv driver database to fetch the data from the csv file. I want to know how to modify the above code to fetch the columns of the csv file and what all the libraries I have to import for the csv driver.
Hi @Sanjana Nalam , welcome on the community. Do you really need to access the CSV as DB tables? I think it is valid for complicated CSV files and I never used it to be honest.
We use following library to read CSV files in groovy:
https://github.com/xlson/groovycsv
It is really simple to use it...
I like opencsv for this:
Here is a simple implementation
import com.opencsv.CSVReader
@Grapes(
@Grab(group='com.opencsv', module='opencsv', version='5.5.2')
)
def reader = new CSVReader(new FileReader(new File('path to csv')))
def csvAsArrayOfMaps = reader.collect { it }.with { rows ->
def header = rows.head()
def dataRows = rows.tail()
dataRows.collect { row ->
[header, row].transpose().collectEntries()
}
}
This this, if you file contains something like this:
colA,colB,colC
1,value1b,value1c
2,value2b,value2c
You can get the total number of rows with "csvAsArrayOfMaps.size()"
And you can get any of the rows with "csvAsArrayOfMaps[rowIndex]"
And you can get a specific column with csvAsArrayOfMaps[0].colB == 'value1b'
There are other fancier methods like "CsvToBeanBuilder" and CSVReaderHeaderAware, but I found the simplest case to be the easier to use.
More info available here: http://opencsv.sourceforge.net/
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.