I have a mySQL .SQL data file which needs some cleaning up, with a script (not manually).
What needs to be done:
1) The 'Details' field is currently a messy aggregation of five information fields.
Color, Size, Fabric, Weight, Producing Time
a) 'COLOR:pink,green,purple,blue\r\nSIZE:s,m,l\r\nFABRIC:100%cotton\r\nWEIGHT:[url removed, login to view]'
b) 'Color:blue,size:S,M,L,Fabric:100%cotton,weight:[url removed, login to view],ProducingTime:7days'
The table needs to be redefined and this field needs to be parsed/split out into the 5 separate fields.
2) There are some spelling errors and typos within the fields. I need the unique values (groupBy) list of each field so I can provide input on what needs to be cleaned up/reconciled to an approved list of Correct values. Then you need to be able to apply that 'correct list' to the data.
Here is the current [url removed, login to view] and there are 13000 records in the table.
This is the [url removed, login to view]
create table products (
id int not null,
quantity int not null default 0,
quantity_min int not null default 0,
primary key (id))