Parsing Apt, Unit, etc. from street

Question

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_AddressApt/Unit123 Main StApt 2

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

Thank you!

randreag · Answer

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

ExampleRegex.yxmd

mceleavey · Answer

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.

Regex solution.yxmd