Matching across variables

Hi, I have a dataset with two phone numbers and I'd like to find records with matching phone numbers regardless if it's the first or the second. For example:

Record# Phone1 Phone2

1 123456789 111111111

2 222222222 123456789

I'd like to say record 1 and 2 is a match

What could you do to find that match? Thanks for any suggestion!

Best,

Hong

Fuzzy Match

Accepted answers

Qiu

@Hong_Hu
I would think a bit more complicated case though I am not sure whats your real data look like.

0805-Hong_Hu.yxzp

All comments

binu_acs

@Hong_Hu may be Find and Replace tool is an option

Phone_Match_04082025.yxmd

Hong_Hu

That's a great solution, thanks!

Qiu

@Hong_Hu
I would think a bit more complicated case though I am not sure whats your real data look like.

0805-Hong_Hu.yxzp

Hong_Hu

Wow Yes this is exactly what I need. Thanks!

Quick Links

Unanswered
Community Events
Groups

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703