Devam Ediyor

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

Beceriler: ASP, PHP

Daha fazlasını görün: sql price, sql create table price, project details example, php script null, php price project, int size c, int i, create category and subcategory in php, Cotton on, blue cotton, split sql file, on sql, sql, sql script , sql project , sql mysql, sql l, sql data, sql c, sql and c, purple, Project m, pink, parsed, null

İşveren Hakkında:
( 1 değerlendirme ) Chelmsford, United States

Proje NO: #128722

Seçilen:

codepros

I can do it easyly. Check pm plz

1 gün içinde 110$ USD
(1 Değerlendirme)
2.2

7 freelancer bu iş için ortalamada 137$ teklif veriyor

ITservice

Hi, Pls. check PMB. Thanks

1 gün içinde 150$ USD
(124 Değerlendirme)
7.3
nickjurukov

i can help you

1 gün içinde 200$ USD
(29 Değerlendirme)
5.1
programingmaster

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

1 gün içinde 100$ USD
(14 Değerlendirme)
4.9
ramesh82p

plz check pmb.

in 0 gün içinde100$ USD
(7 Değerlendirme)
3.2
enfinet

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

1 gün içinde 200$ USD
(1 Değerlendirme)
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.

in 4 gün içinde100$ USD
(0 Değerlendirme)
0.0