Address Split Issue

[sanjit11]

I am trying to achieve the result shown below. If someone can assist it would be quite helpful. Thanks 🙂

[Jean-Balteryx]

If you don't use the (?:) part then the expression is : ".* Street" or "Avenue".

With the parenthesis it's : ".* Street" or ".* Avenue"

[atcodedog05]

Hi @Emil_Kos 

---

@Jean-Balteryx wrote:

"?:" means it's an unmarked group so it's not parsed on its own but it rather allows to create a group where a value can be different from one row to another.

---

So this unmarked group is used only as keyword list and it wont be parsed on it owns. 

Amazing method @Jean-Balteryx 🙂👏

[Emil_Kos]

Wow, that is super cool! Thank you for explaining @Jean-Balteryx 

[Jean-Balteryx]

You're welcome @Emil_Kos !

[atcodedog05]

I remember see this in one of the interactive lessons don't remember which 🤔😅

[Emil_Kos]

Hi @sanjit11,

Based on the 4 lines of the data that you have used you need to use the below regex. 

(.* (?:Street|Avenue|Road|Ave)) (.*), (.*?) (.*)

Please mark one of the @Jean-Balteryx posts as a solution as he created a working solution for you. 

[sanjit11]

Hi @Jean-Balteryx , @Emil_Kos  and @atcodedog05 ,

Thanks alot for all your inputs.

@Jean-Balteryx thanks for the solution, worked fine ! 🙂

[Emil_Kos]

Awesome @sanjit11 Happy to help and I am happy that I have learned something cool along the way 😀