Question

I need help with this Java question. Please only answer in Java.

Also, please answer it as simple as possible thanks.

Create an application that reads a file that contains an email list, reformats the data, and writes the cleaned list to another file.

Console

File Cleaner

Source file:  prospects.csv

Cleaned file: prospects_clean.csv

Congratulations! Your file has been cleaned!

The prospect.csv file

FIRST,LAST,EMAIL

james,butler,jbutler@random.com

Josephine,Darakjy,josephine_darakjy@darakjy.org

ART,VENERE,ART@VENERE.ORG

The prospect_clean.csv file

First,Last,email

James,Butler,jbutler@random.com

Josephine,Darakjy,josephine_darakjy@darakjy.org

Art,Venere,art@venere.org

Specifications

Your instructor should provide a CSV file named prospects.csv that contains a list of prospects.

Your application should fix the formatting problems and write a file named prospects_clean.csv.

All names should use title case (an initial capital letter with the rest lowercase).

All email addresses should be lowercase.

All extra spaces at the start or end of a string should be removed.

Criteria

Fix formatting. Your application should fix the formatting problems.

Write File. Your application should write a file named prospects_clean.csv.

Use title case. All names should use title case (an initial capital letter with the rest lowercase).

Fix email addresses. All email addresses should be lowercase.

Trim spaces. All extra spaces at start or end of a string should be removed.

Answer 1

SOURCE CODE IN JAVA:

import java.util.Scanner;

import java.io.File;

import java.io.FileWriter;

class Main

{

public static void main(String[] args)

{

try

{

Scanner in=new Scanner(new File("prospects.csv")); //to read from input file

FileWriter out=new FileWriter(new File("prospects_clean.csv")); //to write into output file

while(in.hasNextLine()) //while input file has more lines to read

{

String line[]=in.nextLine().split(","); //reading a line and spliting it into an array

line[0]=line[0].trim(); //trimming whitespaces from beginning and ending

line[0]=line[0].substring(0, 1).toUpperCase()+line[0].substring(1).toLowerCase(); //converting to title case

line[1]=line[1].trim(); //trimming whitespaces from beginning and ending

line[1]=line[1].substring(0, 1).toUpperCase()+line[1].substring(1).toLowerCase(); //converting to title case

line[2]=line[2].trim(); //trimming whitespaces from beginning and ending

line[2]=line[2].toLowerCase(); //converting to lower case

out.write(line[0]+","+line[1]+","+line[2]+"\n"); //writing to file

}

in.close(); //closing input file

out.close(); //closing output file

}

catch(Exception e) //catching Exceptions

{

System.out.println(e);

}

}

}

INPUT FILE:

OUTPUT FILE: