This post is about data scrubbing/cleansing example. The project involved the separation of the first and last names stored in one column name customer_name into 2 separate columns named as First_name and Last_name. There were 80 thousand rows or eighty thousand customers.
The data was first exported data from customer_name column to text file along with prime keys, then re-imported into access database using space delimiter which separated first name and last name into 2 columns.
