Hi Forum, I'm cleaning about 100,000 addresses and the address variable contains the house number, street direction, street, street type, and unit numbers. I only need the house number, street direction, street, and street type with one space and without periods. I do not need any 1/2, 1/4, or 3/4 with the housing number. Here's an example of the type of addresses I have: 12345 1/2 SAS ST APT C 111 COMPUTER GREEN LN APT1 2222 N. N PROCEDURE RD #2 2255 N N PROCEDURE RD # 3 333 W W. MACRO DR UNIT4 44444 1/4 SEMICOLON AVE STE 5 STE 5 5555 FREQ BLVD 57 There are leading and trailing blanks and multiple spaces . This is the output I want: 12345 SAS ST 111 COMPUTER GREEN LN 2222 N PROCEDURE RD 2255 N PROCEDURE RD 333 W MACRO DR 44444 SEMICOLON AVE 5555 FREQ BLVD How do I do this? Thanks you very much!
... View more