Address Split issue(2)

[sanjit11]

Hi,  

I am trying to achieve the result as shown in the attached file. I tried doing it using regex but I am unable to get accurate result.

Can someone assist?

Thanks.

[atcodedog05 · Accepted solution]

Hi @sanjit11 

You can use regex like below in regex tool parse mode.

.+\s(\w{3})\s\w{3}

Workflow:

Hope this helps : )

[JoaoLeiteV · Accepted solution]

Hello @sanjit11,

You can use a formula to do that:

Just make sure all addresses have the last 7 numbers being the ZIP code.

[sanjit11]

Awesome!! Thanks alot @JoaoLeiteV and @atcodedog05 .

I suppose i really need to practice regex in depth 😅

[JoaoLeiteV]

Try taking a loot at Regexr. It's a good tool to check your Regex formulas and on the left panel, you can open a cheat sheet to see the possible commands.