Hi all,

I have a database of mailing address that I need to do some cleaning on it. Some of the addresses come with some information (e.g. STE 240 , RM A145 , BLDG # 500, FL 876, # 2B, etc.) that I need to put them in a separate column. I am using Stata 14.2 and would greatly appreciate any help with this.

Thanks so much in advance,
Z