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

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@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.

You can leave a response, or trackback from your own site.