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: 3324.84 sample current: Construction+Area%3A%09309+M2%2F3%2C324.84+Feet2 sample desired: 3324.84 optional_field_7 :== Lot/Land Area, decimal representing sqyare feet. sample current: Lot%2FLand+Area%3A%09240.00 sample desired: 240.00 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%[login to view URL]%2Fproperties%2F+mls%2F483772+ sample desired: http%3A%2F%[login to view URL]%2Fproperties%2Fmls%2F483772 readable: [login to view URL] 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.