EZY 10 Rating--Manipulate .CSV File. Split first and last names in one column into 2 columns.
$30-5000 USD
Completed
Posted about 15 years ago
$30-5000 USD
Paid on delivery
I have .CSV file of data that has as a header Contact_Name and it includes both the first and the last name in that column.?
?
I would like to solve this issue by having a utility written that will allow me to upload the .CSV file--- indicate the number of the Contact_Name column is in----and the utility would make the "first? name" a new? First_Name Column and then the "second name" a new Last_Name Column and then delete the old Contact_Name column.
It would then place the Last_Name column to the right of the First_Name column and slide all other columns that are in the uploaded .csv file to the right and output the new .csv.
?
There will be some issues with A) middle initials that have to be considered or 2) when people use as a first name a letter.
A) If Contact_Name column has: Mary J. Brown? the First_Name should include the first name and the middle initial like: Mary J. and the Last_Name should include just : Brown
B) T. Boone Pickens
Same concept the [login to view URL] goes in First_Name and Pickens goes in Last_Name.