Challenge #54: Data Prep Address Parsing

[Pang_Hee_Choy]

solution

[apathetichell]

I'm sure there was a much easier way than 3 Regex tools but I can use the experience...

[thaodinh95]

Here is my solution! Since I don't have address parse tool, I used string formula and RegEx and text input (Street, Avenue,...) to separate street and city.

[rcarog]

Solution attached.

[garrettlem1017]

Solution has been attached.

[JP_SDAK]

I love RegEX!  This would have used only 2 tools if I weren't trying to use EQ to match nulls 😁

Spoiler

[lkclooney]

[Luke_C]

Spoiler

Spoiler

 

[vPir]

This is my contribution.

[jdbartosh]

Solution Uploaded