Regex Partial Addresses

[Brian_Stoffel]

I've checked the community and found some similar questions/answers but none are exactly what I need. 

How do I parse out a certain word plus number from a string into a new column with a space in between?

For example, I want to parse out the abbreviation for apartment of "APT" (case insensitive) plus the apartment number with a space in between. 

[AbhilashR]

@Brian_Stoffel - I have used regex tool to parse out the text APT along with the numbers following it, and then used a formula tool to add a space between them. Hope this helps.

[Jonathan-Sherman · Accepted solution]

Hi @Brian_Stoffel,

Here's a solution, not the most efficient (i'm going to keep working on another solution) but works nonetheless!

If this solves your issue please mark the answer as correct, if not let me know! I've attached my workflow for you to download if needed.

Regards,

Jonathan

[Brian_Stoffel]

This works perfectly. Thanks!