How many times have you found yourself in a situation where you had to deal messy data, especially reconciliate mispellings, short forms of popular names, leading/trailing blanks and so on? I’m talking about something like this: Does this look familiar? It is A-N-N-O-Y-I-N-G, R-I-G-H-T?
I have a good suggestion for you…