Project 15-3 File Cleaner
Project 15-3: File Cleaner
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
Save your time - order a paper!
Get your paper written from scratch within the tight deadline. Our service is a reliable solution to all your troubles. Place an order on any task and we will take care of it. You won’t have to worry about the quality and deadlines
Order Paper NowSource file: prospects.csv
Cleaned file: prospects_clean.csv
Congratulations! Your file has been cleaned!
The prospect.csv file
FIRST,LAST,EMAIL
james,butler,jbutler@gmail.com
Josephine,Darakjy,josephine_darakjy@darakjy.org
ART,VENERE,ART@VENERE.ORG
…
The prospect_clean.csv file
First,Last,email
James,Butler,jbutler@gmail.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.