Splitting out existing records into separate fields

Hi zaba,

We're in luck if the full addresses are separated by <br> tags as we can use explode with the <br> tag as our delimiter. For example:

$fullAddress = "address 1 <br> address 2 <br> city  <br> postcode <br> country";
$addressPieces = explode('<br>', $fullAddress);


The code above will give us an array values for $addressPieces that we can use to save the "separated" address to their own field:

/* array values of $addressPieces
Array (
[0] => address 1
[1] => address 2
[2] => city
[3] => postcode
[4] => country
)
*/
$columnToValues = array(
'address_line1' => $addressPieces[0],
'address_line2' => $addressPieces[1],
'city ' => $addressPieces[2],
'postcode ' => $addressPieces[3],
'country' => $addressPieces[4],
)
mysql_update($tableName, $recordNum, null, $columnToValues);


And using the sample code above, what I would do is I will write a one-time script  that I will run once to loop through all the old records that needs the full address field to be separated into several fields. Explode their full address, and put them in the right field.

For example:

foreach($accoutnRecords as $record){
    if ($record['full_address']){
        $addressPieces = explode('<br>', $record['full_address']);
        
        $columnToValues = array(
            'address_line1' => $addressPieces[0],
            'address_line2' => $addressPieces[1],
            'city'          => $addressPieces[2],
            'postcode'      => $addressPieces[3],
            'country'       => $addressPieces[4],
        )
        mysql_update($tableName, $record['num'], null, $columnToValues);
    }
}


Hope this help!

Cheers,