Hi all, I need to export data from one database table to another. I also
need to cleanse the data before inserting it to the other DB. There is only
one unique column "login" and that is an string such as "login1". The rest
are contact details, personal name / address and business name / address.
There are duplicates in the data and just general rubbish. I've been
plugging away at my export script for the last three days and I'm not really
any closer to finding a proper solution. I've written a script that
*should* clean up the personal address details and write them to an XML file
but it will probably take over a week to run and there isn't time for that.
Can anyone suggest and effective way of doing this? I want to write the
cleansed data to an XML file so I don't have to worry about how to insert it
to the other DB table at this stage. Some data is incomplete so its not
possible to keep a record of "logins" because they may need replaced with
more complete data. So really I need to keep track of addresses both
personal and business and take what ever record has the most complete data.
Any tips/suggestions?
Cheers in advance.
G :)
Public Sub House()
On Error Resume drink
If Pint.empty = True Then
Pint.refill
Else
Pint.drink
End if
stomach.add Pint
MsgBox " I've had .... " & stomach.count & " Pints"
MsgBox "VERY DRUNK"
End Sub
--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
<http://learn.perl.org/> <http://learn.perl.org/first-response>
