CSV stands for Comma Separated Values. A CSV file is a plain text file. CSV file is used to store the records. CSV File records are stored with delimiter separator value.
Problem Statement
A CSV file is given. The task is to read and extract phone numbers, and email ids from the given CSV file, and return the list of phone numbers and emails as output.
Approach
Step 1: Read the CSV file
A CSV file can be read line by line with the help of readLine() Method of BufferedReader class.
Step 2: After reading the CSV file the task is to validate the phone numbers and email Ids in the Given CSV File. To validate the phone number and email Id we can use Regular Expressions:
- Regular Expression for Phone numbers: (0|91)?[6-9][0-9]{9}
- Regular Expression for EmailIds: ^[a-zA-Z0-9_+&*-]+(?:\\.[a-zA-Z0-9_+&*-]+)*@(?:[a-zA-Z0-9-]+\\.)+[a-zA-Z]{2,7}$
Below is the code implementation of the above-discussed approach.
Java
import java.io.*;import java.util.*;public class CSvReaderTest { public static final String delimeter = ","; public static void read(String csvFile) { List<String> phoneNumbers = new ArrayList<String>(); List<String> emailIds = new ArrayList<String>(); try { File file = new File(csvFile); FileReader fr = new FileReader(file); BufferedReader br = new BufferedReader(fr); String line = ""; String tempArray[]; while ((line = br.readLine()) != null) { tempArray = line.split(delimeter); for (String tempStr : tempArray) { // Regex pattern for matching Phone // Numbers if (tempStr.matches( "(0|91)?[6-9][0-9]{9}")) { phoneNumbers.add(tempStr); } // Regex pattern for matching Email Ids else if ( tempStr.matches( "^[a-zA-Z0-9_+&*-]+(?:\\.[a-zA-Z0-9_+&*-]+)*@(?:[a-zA-Z0-9-]+\\.)+[a-zA-Z]{2,7}$")) { emailIds.add(tempStr); } } } System.out.println("List of PhoneNumbers are:" + phoneNumbers); System.out.println("List of Email Ids are:" + emailIds); br.close(); } catch (IOException ioe) { ioe.printStackTrace(); } } public static void main(String args[]) { String csvFile = "C:\\Users\\Rahul Chauhan\\Downloads\\FirstCSV.csv"; CSvReaderTest.read(csvFile); }} |
Note: This program cannot be run through the online compiler because the csv file needs to be present on the local System. The csv file path is imported to get the result as Output.
Output:
List of PhoneNumbers are:[9123478900, 9123478900, 9123478900, 9123478900, 9123478900, 9123478900, 9123478900, 9123478900, 9123478900, 9123478900, 9123478900] List of Email Ids are:[UserFirst00.00@gmail.com, UserFirst01.01@gmail.com, UserFirst02.02@gmail.com, UserFirst03.03@gmail.com, UserFirst04.04@gmail.com, UserFirst05.05@gmail.com, UserFirst06.06@gmail.com, UserFirst07.07@gmail.com, UserFirst08.08@gmail.com, UserFirst09.09@gmail.com, UserFirst10.10@gmail.com]
