Challenge #54: Data Prep Address Parsing

[caltang]

Done! Used Regex as well:

Spoiler

 
For anyone curious: ^(.*?)\s*~\s*(.*?)\s*([A-Z]{2})(?:\s*(\d{5}))?$

[mithily]

Spoiler

Spoiler flex the regex

[CVCurcurato]

An almost exlusively RegEx solution from me

[rachel_lynch]

Spoiler

 

[Sebastian_Chaieb2]

With bigger dataset (and more cases or roads, circles, streets, etc) it would be better to use lookup table instead Formula with Replace functions

Spoiler

 

[Amy_smart]

Here is my solution.

[josedlr00]

Nice Challenge

[H_a_n_g_C_h_e_n__x3]

Speed

[Dani_Lin]

solved

[AndreeaS]

Spoiler