I searched the board and found useful tools for checking for duplicates, but have a challenge when data is coming from two diffent sources. I would like "AM BEST", "A.M. Best" and "A. M. Best" to show up as duplicates, but could not find an elegant way.
My current solution is to replace (CTRL-H) all periods, commas, and spaces with null.
Any more insightful solutions?
My current solution is to replace (CTRL-H) all periods, commas, and spaces with null.
Any more insightful solutions?