I need help with amalgamating primary keys to uniformity so that they are no longer stored in a variety of formats. These are the primary Keys are for my HoH data structures therefore; I will need to replace the old keys with the updated key. ie.
I have multiple hrefs with similar primary keys but they are not exactly alike do to their database formatting. I am having difficulty comparing the keys since they are all not uniform. Example of key data:
Altering the database formatting is outside of my control. I am seeking the best algorithm for accomplishing this task.