Kapalı

Mysql DB Cleanup

I have a set of tables in a MySql database.

I need to re-organize the information of the columns and do some

re-formatting of the information in the columns.

I will provide exported data to be reformatted.

Part of the need, is to have the DB analyzed, to help define what information is there so that

it can be re-organized properly.

The end result is:

A portion of the task is to determine the state of the disorder.

In this problem, there are columns named:

optional_field_1 thru optional_field_2 , etc through to 20

The information in these columns is scattered.

That is, the Size information and the Bedroom information is not consistent amongst the rows of

data. There's no order to what column has what.

Here is the desired end column assignments and formatting notes.

optional_field_1 :== Property Number, simple text string single line.

sample current: Property+%2323129

sample desired: 23129

sample current: MLS%23%3A+486562

sample desired: MLS486562

optional_field_2 :== Number of Baths, decimal, {full}.{half}

sample current: Bathrooms%3A%09+4

sample desired: 4.0

sample current: Baths+%28full%2Fhalf%29%3A++%095+%2F+1

sample desired: 5.1

optional_field_3 :== Number of Bedrooms, integer

sample current: Bedrooms%3A%09+3

sample desired: 3

optional_field_4 :== "size", urlencoded string, single line, example readable: "450 m²/ 4,844 ft"

sample current: Size%3A+450+m%C2%B2%2F+4%2C844+ft%C2%B2

sample desired: 450+m%C2%B2%2F+4%2C844+ft%C2%B2

optional_field_5 :== square feet, integer

sample current: Sq.+ft.%3A+++%093907

sample desired: 3907

optional_field_6 :== construction area, decimal representing Feet-Squared, sample: [url removed, login to view]

sample current: Construction+Area%3A%09309+M2%2F3%[url removed, login to view]+Feet2

sample desired: [url removed, login to view]

optional_field_7 :== Lot/Land Area, decimal representing sqyare feet.

sample current: Lot%2FLand+Area%3A%[url removed, login to view]

sample desired: [url removed, login to view]

optional_field_8 :== Parkings

sample current: Parkings%3A%09+2

sample desired: 2

optional_field_9 :== Lot Size in Square Feet, decimal

sample current: Lot+Size%3A+++7750+sq.+ft.+++

sample desired: 7750

sample current: Lot+Size%3A++%0959X157

sample desired: 9263

sample current: Lot+Size%3A++%0948X217X165X132X191

sample desired: 0

optional_field_10 :== Construction Year, integer

sample current: Year+Built%3A++%092005

sample desired: 2005

optional_field_11 :== External URL, simple text string single line.

sample current: http%3A%2F%[url removed, login to view]%2Fproperties%2F+mls%2F483772+

sample desired: http%3A%2F%[url removed, login to view]%2Fproperties%2Fmls%2F483772

readable: [url removed, login to view]

optional_field_12 :== feature specification, conventional string, single line.

{not yet implemented}

optional_field_13 :== Subdivision, simple text string single line.

sample current: Subdivision%3A+++SEASIDE+10+

sample desired: SEASIDE+10

optional_field_14 :== unused.

optional_field_15 :== unused.

optional_field_16 :== unused.

optional_field_17 :== unused.

optional_field_18 :== unused.

optional_field_19 :== unused.

optional_field_20 :== unused.

I would expect to have the consultant provide further analysis of data found in these 20 columns that is

not re-assigned and report back.

The arrangement of the columns and formatting my be revised before work begins.

Beceriler: Veri İşleme

Daha fazlasını görün: mysql database cleanup, mysql cleanup, cleanup data mysql, string problem, mysql db, m string, construction consultant, single line, mysql report, db, cleanup, bedroom, b2, simple notes database, work lot size, order number mysql, mysql area, string integer, mysql tables rows, data information organize, help mysql, simple mysql processing, 7750, string processing, area square

İşveren Hakkında:
( 0 değerlendirme ) Flagstaff, United States

Proje NO: #750821

5 freelancer bu iş için ortalamada 167$ teklif veriyor

JatinNCSTech

I can do your work Thanks & Regards

in 10 gün içinde250$ USD
(0 Değerlendirme)
0.0
presip

Good working knowledge on MySql and URI coding and decoding.

in 7 gün içinde225$ USD
(0 Değerlendirme)
0.0
Maruthisri

Hi I am an experienced DBA. I can do this project for you. Thanks

in 2 gün içinde30$ USD
(0 Değerlendirme)
0.0
dataprocessingit

I would be very interested in getting the job done for you. I guarantee 100% satisfaction and the job will be finished on time. I am currently working on a project which has GWT on its client side programming and JAVA/ Daha fazlası

in 7 gün içinde250$ USD
(0 Değerlendirme)
0.0
Samadansari

Hello! I'm very interested in this job and ready to start right now!.plz see pm..

in 5 gün içinde80$ USD
(0 Değerlendirme)
0.0