clear out duplicate data in two fields of same contact record?

J

Jim5941

I recently upgraded from Lotus Organizer to Outlook.
I was able to export the Organizer contact data to vCard then import
the vCards to Organizer.

I have found that many (several hundred) of the contact records have
duplicated data in either the "home phone" and "other phone" or the
"work phone" and "other phone" fields.

That is to say the home/work field and other field have the same data
repeated again for a given contact record.

Even from phone list view it would be tedious to remove the duplicate
data as there are so many records. Is there another way to clear the
duplicate data? Is scripting allowed? Something like:

For contact records 1 to last
If home phone == other phone then set other phone == null
If work phone == other phone then set other phone == null


Thanks,
Jim
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top