Completed

SQL project

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

Example:

a) 'COLOR:pink,green,purple,bluernSIZE:s,m,lrnFABRIC:100%cottonrnWEIGHT:[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,

offer_no varchar(32),

brand varchar(32),

category varchar(32),

subcategory varchar(32),

quantity int not null default 0,

quantity_min int not null default 0,

price varchar(32),

style varchar(32),

weight varchar(32),

details tinytext,

image_1 varchar(128),

image_2 varchar(128),

image_3 varchar(128),

image_4 varchar(128),

primary key (id))

pm for more details

Skills: ASP, PHP

About the Client:
( 1 review ) Chelmsford, United States

Project ID: #128722

Awarded to:

codepros

I can do it easyly. Check pm plz

$110 USD in 1 day
(1 Review)
2.2

7 freelancers are bidding on average $137 for this job

ITservice

Hi, Pls. check PMB. Thanks

$150 USD in 1 day
(124 Reviews)
7.3
nickjurukov

i can help you

$200 USD in 1 day
(29 Reviews)
5.1
programingmaster

I can make the script to cleanup your database. Thanks :)

$100 USD in 1 day
(14 Reviews)
4.9
ramesh82p

plz check pmb.

$100 USD in 0 days
(7 Reviews)
3.2
enfinet

Hi, I can do this for you in 1 day. Thanks.

$200 USD in 1 day
(1 Review)
3.0
shishirmba

I want to do the project with quality, therefore I'll require atleast 4 days in completing. I have expertise in MySQL.

$100 USD in 4 days
(0 Reviews)
0.0