Parsing Apt, Unit, etc. from street

[kduong1]

Hi guys!

I am trying to parse out apt/unit/spc etc. from street addresses field. 

Example: 123 Main St Apt 2

Ideal Result:

Street_Address	Apt/Unit
123 Main St	Apt 2

I know to use RegEx but not sure what expression to use. Any help is appreciated!

Thank you!

[mceleavey]

Hi @kduong1 ,

the problem you will have here is you have only provided one line of data, and so we don't know how consistent your data is.

I have attached a workflow which parses out the apartment then removes it from the original value, creating a separate column, but this will only work if all records are in this format.

Hopefully this will get you started though.

M.

[randreag]

hi @kduong1 

I attached a workflow to show you how could be.

Depends on the second part you can change Apt for something more general [a-z] and the length {2,} 

I hope it helps