Project 15-3 File Cleaner

    0

    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,[email protected]

    Josephine,Darakjy,[email protected]

    ART,VENERE,[email protected]

    …

    The prospect_clean.csv file
    First,Last,email

    James,Butler,[email protected]

    Josephine,Darakjy,[email protected]

    Art,Venere,[email protected]

    …

    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.

                                                                                                                                      Order Now