Data match (Take 2)
 

I have a list of 19-digit account numbers, like such:

1205000458476190000

I also have a list of 20-digit account numbers, like such:

01205000458476194300

The above examples belong to the same account - that is, they are the same
account number. They simply differ by 1 leading zero and the last 4 digits
("0000" in the first, "4300" in the second). I need to take all the account
numbers in one list and match them with the numbers in the other list.
What's the best way to do this?

Thanks in advance for any help.

Data match (Take 2)
 

I am not sure what you are trying to accomplish exactly when you say match
them. However, you can trim down the longer one by using the MID() forumla
and picking the string of digits out in the middle that you want.

"martinbarnes" wrote:

I have a list of 19-digit account numbers, like such:

1205000458476190000

I also have a list of 20-digit account numbers, like such:

01205000458476194300

The above examples belong to the same account - that is, they are the same
account number. They simply differ by 1 leading zero and the last 4 digits
("0000" in the first, "4300" in the second). I need to take all the account
numbers in one list and match them with the numbers in the other list.
What's the best way to do this?

Thanks in advance for any help.