I use Regular Express to translate address format. I found some problems.

 

1) If East, West, North, South in the middle of the address, then translation is wrong

  for example: 123 ABC West Road -> 123 Abc WRd

 

2) Street is in the middle of the address, Street won't be translated

for example: 123 ABD Street West -> 123 Abd Street W   I need it to be 123 Abd St W

 

3) How to translate 123 ABD St. Paul St. West to 123 Abd St. Paul St W

I would love to know this as well. I am updating some profiles and noticed we had regular expressions to change St. to Street but are now going with abbreviations and no punctuation.