C++ programming language. Complete a C++ project that reads and writes .csv files. Write code that manipulates data read from a .csv file. Create and write a comma separated value file.

#1: Complete the project. Insert the necessary code to complete the project. Your project should perform the following steps:

a.		Open the input file.
b.		Open the output file.
c.		Create a loop that runs until the last line of the input file has been read.
d.		Read each line of the input file.
e.		Multiply the wage and hours date of each line to produce a pay value.
f.		Write the data read from the input file into the output file as well as the new pay data (pay should be the last field in each record) in .csv format.
g.		Close the input file.
h.		Close the output file.

Hint: The code you have been given reads all of the fields in each record as strings. You will need to convert wage and hours to float (or double) and perform the multiplication before writing the pay data to the output file.

#2: Test your code. Run the program and compare the input file to the output file to make sure that you have not modified any of the data fields and that the extra data field is correctly appended to the end of each line.

-------------------------------------------------------------------------------------------------------------

Below is a start on the code.

-------------------------------------------------------------------------------------------------------------

#include "stdafx.h" #include #include #include

using namespace std;

int _tmain(int argc, _TCHAR* argv[]) { ifstream inFile; string szSourcePath = // path of input file, change to your file location, if necessary "test.csv";

ofstream outFile; string szDestPath = "out.csv"; // path of output file, change to your file location, if necessary

string szLastName; string szFirstName; string szAddress; string szCity; string szState; string szZip; string szWage; string szHours; string szPay;

inFile.open(szSourcePath); outFile.open(szDestPath);

// this code reads the first line of the input file only // insert loop to read entire file here getline( inFile, szLastName, ','); getline( inFile, szFirstName, ','); getline( inFile, szAddress, ','); getline( inFile, szCity, ','); getline( inFile, szState, ','); getline( inFile, szZip, ','); getline( inFile, szWage, ','); getline( inFile, szHours, ' ');

// calculate pay here // insert write to output file here

inFile.close(); outFile.close();

system("Pause"); return 0; }

-------------------------------------------------------------------------------------------------------------

The .cvs file contains the text below.

-------------------------------------------------------------------------------------------------------------

Cross,Shaina,12 Corrigan Ct,Benicia,CA,94510-2578,12.25,10.25 Weiner,Alysha,1748 Legend Cir,Vacaville,CA,95688,10.25,14 Son,Bernardo,1031 Rodondo Avenue,Oakley,CA,94561,10.25,21 Pearce,Georgene,1005 Bayside Ct,Fairfield,CA,94533-3147,13,21.75 Doucette,Ted,1115 Estes Ct,Suisun City,CA,94585,10.5,16.5 Spooner,Denny,2530 Gina Ct,Vallejo,CA,94591-4934,15.5,21 Galbraith,Santos,307 Amberwood Circle,Fairfield,CA,94533-1681,10.5,13.5 Castellanos,Kristyn,165 Hayes St,Fairfield,CA,94533,8.25,20.5 Jue,Martin,419 Tulip St,Fairfield,CA,94534,18.25,25.25 Tucker,Olga,209 Pine Valley Drive,Fairfield,CA,94533-2301,20.25,12.5 Silvers,Damon,1020 Kildare Way,Napa,CA,94558,15,26.75 Hogan,Starr,2961 Gonzaga Ave,Vallejo,CA,94591,10.25,9.5 Anderson,Terry,1910 Indiana St,Vacaville,CA,95687,11,20 Junstrom,Larry,237 1st St,Fairfield,CA,94533,13.75,20.5 South,Jerald,514 Minnesota St,Fairfield,CA,94533,18,21.75 Montez,Terrence,1636 Raven Dr,Vacaville,CA,95687,12.5,18.25 Herbst,Aidan,114 Madrone Pl,Davis,CA,95618,10.25,9.75 Ferrara,Caitlynn,1023 Kelly Way,Oakley,CA,94561,13.75,24 Blum,Zelda,660 Bluebird Way,Fairfield,CA,94533,10.75,13.25 Fanning,Jeramy,1189 Beelard Dr,Suisun City,CA,94585,11.25,18.25 Evers,Nathan,1307 Normandy Dr,Vacaville,CA,95687,10.5,20.5 Courtney,Isabel,2793 Florida St,Vallejo,CA,94591,10.5,18.25 Kidder,Harris,1112 Bering Ct,Suisun City,CA,94585,11.5,16.25 Snyder,Omayra,2219 Oakwood Ave,Vallejo,CA,94591,9.75,22.5 Fournier,Ashli,89 Carlisle Way,Benicia,CA,94510,15.25,24 Fultz,James,351 Gulf Dr,Fairfield,CA,94533,10.25,8 Simon,Phyllis,131 Valley Glen Dr,Dixon,CA,95620,10.25,8.25 Katz,Gaynell,2472 Whitney Ave,Vallejo,CA,94590-3765,11,16.75 Valladares,Claudio,1706 Alabama St,Vacaville,CA,95687,15.5,24.5 Hinkle,Kassie,1042 Ashwood Dr,Suisun City,CA,94585,10.95,14.25 Chan,Sierra,1115 Rio Verde,Suisun city,CA,94585,10.5,17.5 Savoy,Daron,184 Bluebird Way,Fairfield,CA,94533,11.25,14.25 Stevenson,Shaniya,1550 Yale Ave,Vacaville,CA,95687,10.5,14.25 Langlois,Darin,426 Rayburn Ct,Fairfield,CA,94533,10.5,18.25 Layne,Casandra,1435 Madrone St,Vacaville,CA,95687,10.25,20 Backus,Felipe,902 E. Atlantic Ave.,Fairfield,CA,94533-8412,12,26.75 Anderson,Andrew,1910 Indiana St,Vacaville,CA,95687,11,20.75 Brody,Irwin,1589 Fremont Drive,Vacaville,CA,95687-4707,14.25,16.25 Polanco,Belva,130 Madera Dr,Dixon,CA,95620,11.25,16 Cummings,Savanna,131 La Esperanza Dr,Dixon,CA,95620,10.75,16.5 Nevarez,Cecile,354 Grande Cir,Fairfield,CA,94533-2238,10.25,15.5 Winfrey,Humberto,1962 Fleming Ave.,Vacaville,CA,95687,10.25,14 Quinn,Shamika,3107 Benica Rd.,Vallejo,CA,94591,14.75,27 Crocker,Leanne,1573 Fall River Trl,Vacaville,CA,95687,10.5,14.5 Strassberg,Gerson,2220 Donegal Dr.,Vallejo,CA,94590,11.25,14.5 Mcnair,Alena,751 Nightingale ct.,Fairfield,CA,94534-3408,10,12.5 Harper,Brennon,225 Baltic Dr,Fairfield,CA,94533,10.25,9.5 Tomlin,Ellen,2513 Bergwall Way,Vallejo,CA,94589-3425,11,7.25 Zeller,Lavern,151 Huber Dr,Elmira,CA,95625-0177,10.25,10.5 Barnett,Rosalyn,2162 Oddstad Dr,Vallejo,CA,94590-4712,11.25,21 Couture,Tremayne,713 Zaragoza Dr,Fairfield,CA,94533,10.95,11.75 Mccool,Deon,223 Bay Tree Ct,Fairfield,CA,94534,13.5,8.5 Powell,Neta,464 Whitney Drive,Fairfield,CA,94533,10.5,13.75 Steel,Fletcher,310 E Travis Blvd,Fairfield,CA,94534,10.25,11 Anderson,Valary,1910 Indiana St,Vacaville,CA,95687,11,23.75 Brown,Michael,606 Barton Dr,Fairfield,CA,94533,10.5,17.75 Youngblood,Maribeth,800 Woolner Ave,Fairfield,CA,94533,10.75,14.75 Cedeno,Dusty,4160 Mira Loma St,Vallejo,CA,94589-3239,13,21.75 Flanagan,Giselle,419 E Atlantic Ave,Fairfield,CA,94533,11,12.5 Cosgrove,Mitch,860 Tulip St,Fairfield,CA,94533,10.5,5 Lear,Shande,2017 Falcon Dr,Vallejo,CA,94590,10.95,12 Field,Jill,1131 Stillspring CT.,Suisun City,CA,94585-0824,10.25,11.5 Ellington,Jame,403 Argelles CT,Fairfield,CA,94533-7104,12.5,17 Layman,Lanny,1148 Sunridge Way,Suisun City,CA,94585,19,25 Mccormick,Sonia,830 Beck Ave.,Fairfield,CA,94533,10.25,16.75 Knapp,Zelda,1595 Newcastle Dr,Vacaville,CA,95687,11,12.75 Hogg,Darrien,349 Santa Maria Dr,Fairfield,CA,94533,10.25,20.5 Rey,Alvino,1915 Stonewood Ct.,Vacaville,CA,95687,13,14.25 Ridley,Fannie,401 E Tabor Ave,Fairfield,CA,94533-0090,11,11.5 Wheaton,Ronnie,403 Butternut Ct,Fairfield,CA,94533,21.25,27.75 Crandall,Walker,414 Baltic Dr,Fairfield,CA,94533-3914,10.25,9 Garero,Devon,1612 Catalina Ct,Vacaville,CA,95687,10.5,13.25 Rupert,Barrett,215 Candleberry Way,Fairfield,CA,94533-4529,17.5,20.5 Johnsen,Damian,118 La Esperanza Dr,Dixon,CA,95620,11.25,16.5 Wildon,Sarah,1037 Scoter Way,Pinole,CA,94564,11,20 Ruff,Alma,4732 Ridge Ave,Vallejo,CA,94591,13.25,13.25 Kearns,Ashanti,766 N Texas St,Fairfield,CA,94533,10,9.75 Donohue,Brook,2518 Granada St,Vallejo,CA,94591,10.5,16.5 Lopez,Dudley,1195 Quail Ct,Suisun City,CA,94585,13,20.75 Larue,Emogene,151 Nightingale Dr,Fairfield,CA,94533,11,24.5 Beatty,Jaylene,285 E Atlantic Ave,Fairfield,CA,94533,10.5,17.75 Walsh,Joe,989 Capell Valley Rd,Fairfield,CA,94533,10.5,15.5 Hoyt,Laquita,2407 Rae Ct,Vallejo,CA,94589,10.25,18.25 Gaddis,Rand,1360 Quail Ct,Vacaville,CA,95687,10.5,21.5 Dillon,Trena,2780 Oakwood Ave,Vallejo,CA,94589,10.25,12.75 Simpson,Ona,1042 Redhead Way,Rio Vista,CA,94571,10.75,15 Conger,Garett,1012 Warhol Way,Fairfield,CA,94533,11.5,17.25 Lanham,Malcolm,2031 Baxter St,Vallejo,CA,94591,12.5,5.75 Tindall,Jacob,1233 Madison Ave,Travis AFB,CA,94535,16,18.75 Parkinson,Carl,1037 Scoter Way,Pinole,CA,94564,11,20 Warez,Amber,240 Brookdale Cir,Fairfield,CA,94533,10.25,23.5 Gibbons,Guillermin,956 Del Sur Ct,Fairfield,CA,94533,16.75,20.5 Sun,Altha,360 Bailey Dr,Fairfield,CA,94533,11,23 Whelan,Evelyn,831 Tabor Ave,Fairfield,CA,94533,10.95,13.75 Shuman,Robert,2518 North Regatta Dr,Vallejo,CA,94589,10.5,15 Tallman,Vera,1601 Crystal Springs Dr,Vacaville,CA,95688-2710,21,23.75 Joe,Sven,1348 Weatherly Way,Vacaville,CA,95688-9239,10.5,27.5 Menzel,Donald,205 New Hampshire St,Fairfield,CA,94533-0871,17,18.25 Willard,Krista,1101 West St,Suisun City,CA,94585,11,10 Hunt,Walter,286 Brookside Cir,Fairfield,CA,94534-6866,10.75,11.5