I have a situation where I have 2 excel files that I need to associate.
Unfortunately the only common field between the 2 is the persons name. Most of the names match between the 2 files. However, I have situation where the person is a Jr. or Sr. and this only appears in one of the files.
Is there a way that I can strip out the components of the name fields and then compare the parts that I know match?
Or is there a fuzzy match function?
I realize that even this could have issues. But it is all that I have to work with. I just need to get as close as I can with what I have to work with.
Check subfield. This will let you break up a field into pieces. Assuming the max parts - prefix, first, middle, last, suffix you can use space as the delimiter. You can also use substringcount to see how many pieces you have