Comparing addresses

[22strider]

Hello Friends

I need your help in comparing two columns in two different tables containing addresses.
Format 1: Addresses in the first table are in the format of:
1234 22nd Street
4565 21st Street
Format2: Addresses in the second table are in the format of:
1234 22 Street
4565 21 Street

You may notice that "nd" after 22 is missing in the second format. And "st" after 21 is also missing. I am trying to find a way of comparing them, so that they appear as a match.

Thanks
Rajesh

 

[SydneyGeek]

Build an expression to remove the ordinals. Something like...

NewAddress: Replace(Replace(Replace(Replace([Address],"st "," "),"nd "," "),"rd "," "),"th "," ")

Assuming that the table is Clients and the original field is Address.

Denis

 

[22strider]

Thanks one more time; that worked very well

 

[SydneyGeek]

You're welcome

Denis