ibmcom/commons-csv-ppc64le repository overview

cd /commons-csv/target/classes

Create users.csv and BasicCSVReader.java



....Input CSV file i.e. users.csv....

Rajeev Kumar Singh ?,[email protected],+91-9999999999,India

Sachin Tendulkar,[email protected],+91-9999999998,India

Barak Obama,[email protected],+1-1111111111,United States

Donald Trump,[email protected],+1-2222222222,United States





....BasicCSVReader.java.................

import org.apache.commons.csv.CSVFormat;

import org.apache.commons.csv.CSVParser;

import org.apache.commons.csv.CSVRecord;

import java.io.IOException;

import java.io.Reader;

import java.nio.file.Files;

import java.nio.file.Paths;



public class BasicCSVReader {

    private static final String SAMPLE_CSV_FILE_PATH = "./users.csv";



    public static void main(String[] args) throws IOException {

        try (

            Reader reader = Files.newBufferedReader(Paths.get(SAMPLE_CSV_FILE_PATH));

            CSVParser csvParser = new CSVParser(reader, CSVFormat.DEFAULT);

        ) {

            for (CSVRecord csvRecord : csvParser) {

                // Accessing Values by Column Index

                String name = csvRecord.get(0);

                String email = csvRecord.get(1);

                String phone = csvRecord.get(2);

                String country = csvRecord.get(3);



                System.out.println("Record No - " + csvRecord.getRecordNumber());

                System.out.println("---------------");

                System.out.println("Name : " + name);

                System.out.println("Email : " + email);

                System.out.println("Phone : " + phone);

                System.out.println("Country : " + country);

                System.out.println("---------------\n\n");

            }

        }

    }

}







$ javac BasicCSVReader.java

$ java BasicCSVReader





OUTPUT:



Record No - 1

---------------

Name : Rajeev Kumar Singh ?

Email : [email protected]

Phone : +91-9999999999

Country : India

---------------





Record No - 2

---------------

Name : Sachin Tendulkar

Email : [email protected]

Phone : +91-9999999998

Country : India

---------------





Record No - 3

---------------

Name : Barak Obama

Email : [email protected]

Phone : +1-1111111111

Country : United States

---------------





Record No - 4

---------------

Name : Donald Trump

Email : [email protected]

Phone : +1-2222222222

Country : United States

---------------