You have been asked to help. Could you please develop automated way (bash script) and create new accounts_new.csv file based on current accounts.csv and following:
Definition of done: Developed bash script which automatically creates accounts_new.csv and updates columns name and email based on the rules above.
Script should not use any additional installed packages!
Example: ./task.sh accounts.csv
Was: 2,1,Christina Gonzalez,Director,, 8,6,Bart Charlow,Executive Director,, 9,7,Bart Charlow,Executive Director,,
Became: 2,1,Christina Gonzalez,Director,cgonzalez@abc.com, 8,6,Bart Charlow,Executive Director,bcharlow6@abc.com, 9,7,Bart Charlow,Executive Director,bcharlow7@abc.com,
At index 0 diff: 'id,location_id,Name ,title,ndepartment@abc.com,\n' != 'id,location_id,name,title,email,department\n'
Full diff:
[
- 'id,location_id,name,title,email,department\n',
? ^ ^^^^^^
+ 'id,location_id,Name ,title,ndepartment@abc.com,\n',
? ^ + ^ +++++++++
- '1,1,Susan Houston,Director of Services,shouston1@abc.com,\n',
? -
+ '1,1,Susan Houston,Director of Services,shouston@abc.com,\n',
'2,1,Christina Gonzalez,Director,cgonzalez@abc.com,\n',
- '3,2,Brenda Brown,"Director, Second Career Services",bbrown@abc.com,\n',
? -------------------------
+ '3,2,Brenda Brown,"Director,bbrown@abc.com,\n',
- '4,3,Howard Lader,"Manager, Senior Counseling",hlader@abc.com,\n',
? --------------------
+ '4,3,Howard Lader,"Manager,hlader@abc.com,\n',
'5,4,Kimberly Pesavento,Commercial director,kpesavento@abc.com,\n',
'6,5,Joe Bloom,Financial Empowerment Programs Program '
'Director,jbloom@abc.com,\n',
'7,6,Peter Olson,Director,polson@abc.com,\n',
- '8,6,Bart Charlow,Executive Director,bcharlow6@abc.com,\n',
? -
+ '8,6,Bart Charlow,Executive Director,bcharlow@abc.com,\n',
- '9,7,Bart Charlow,Executive Director,bcharlow7@abc.com,\n',
? -
+ '9,7,Bart Charlow,Executive Director,bcharlow@abc.com,\n',
'10,7,Barbara Kalt,Director,bkalt@abc.com,\n',
'11,8,Marilyn Baker-Venturini,Director,mbaker-venturini@abc.com,\n',
'12,8,Graciela Hernandez,Assistant Manager,ghernandez@abc.com,\n',
'13,8,Julie Avelino,Assessment Specialist,javelino@abc.com,\n',
- '14,9,Dave Genesy,Library Director,dgenesy9@abc.com,\n',
? -
+ '14,9,Dave Genesy,Library Director,dgenesy@abc.com,\n',
- '15,9,Maria Kramer,Library Divisions Manager,mkramer9@abc.com,\n',
? -
+ '15,9,Maria Kramer,Library Divisions Manager,mkramer@abc.com,\n',
- '16,10,Dave Genesy,Tester,dgenesy10@abc.com,\n',
? --
+ '16,10,Dave Genesy,Tester,dgenesy@abc.com,\n',
- '17,10,Maria Kramer,Library Division Manager,mkramer10@abc.com,\n',
? --
+ '17,10,Maria Kramer,Library Division Manager,mkramer@abc.com,\n',
- '18,11,Dave Genesy,Head of office,dgenesy11@abc.com,\n',
? --
+ '18,11,Dave Genesy,Head of office,dgenesy@abc.com,\n',
- '19,11,Elizabeth Meeks,Branch Manager,emeeks11@abc.com,\n',
? --
+ '19,11,Elizabeth Meeks,Branch Manager,emeeks@abc.com,\n',
'20,12,Kathy Endaya,Director,kendaya@abc.com,\n',
- '21,13,Dave Genesy,Library Director,dgenesy13@abc.com,\n',
? --
+ '21,13,Dave Genesy,Library Director,dgenesy@abc.com,\n',
- '22,14,Andres Espinoza,"Manager, Commanding Officer",aespinoza@abc.com,\n',
? ---------------------
+ '22,14,Andres Espinoza,"Manager,aespinoza@abc.com,\n',
'23,15,Jack Phillips,Administrator,jphillips@abc.com,\n',
'24,16,James Lee,Commanding Officer,jlee@abc.com,\n',
'25,17,Kenneth Gibson,Tester,kgibson@abc.com,\n',
- '26,18,Sharon Petersen,Administrator,spetersen18@abc.com,\n',
? --
+ '26,18,Sharon Petersen,Administrator,spetersen@abc.com,\n',
- '27,19,Sharon Petersen,Administrator,spetersen19@abc.com,\n',
? --
+ '27,19,Sharon Petersen,Administrator,spetersen@abc.com,\n',
- '28,21,Moncef Salah,Tester,msalah@abc.com,Office of Innovation\n',
+ '28,21,Moncef Salah,Tester,msalahoffice of innovation@abc.com,\n',
- '29,22,Suzanne Badenhoop,Tester,sbadenhoop@abc.com,Referrals\n',
? ---------
+ '29,22,Suzanne Badenhoop,Tester,sbadenhoopreferrals@abc.com,\n',
? +++++++++
- '30,20,Sean Houston,Director of new Services,shouston20@abc.com,\n',
? --
+ '30,20,Sean Houston,Director of new Services,shouston@abc.com,\n',
- '31,8,David Genesy,Account Manager,dgenesy8@abc.com,\n',
? -
+ '31,8,David Genesy,Account Manager,dgenesy@abc.com,\n',
- '32,8,Elizabeth Feeney,CEO,efeeney@abc.com,Operations\n',
? ----------
+ '32,8,Elizabeth Feeney,CEO,efeeneyoperations@abc.com,\n',
? ++++++++++
- '33,8,Erika Meeks,Tester,emeeks8@abc.com,Operations\n',
? ^ ----------
+ '33,8,Erika Meeks,Tester,emeeksoperations@abc.com,\n',
? ^^^^^^^^^^
]
E At index 0 diff: 'id,location_id,Name ,title,ndepartment@abc.com,\n' != 'id,location_id,name,title,email,department\n'
E
E Full diff:
E [
E - 'id,location_id,name,title,email,department\n',
E ? ^ ^^^^^^
E + 'id,location_id,Name ,title,ndepartment@abc.com,\n',
E ? ^ + ^ +++++++++
E - '1,