Challenge #54: Data Prep Address Parsing

[JoeChan619]

I basically used Regex to solve it.

Spoiler

[katejoyce87]

:)

[CurtisPaterson]

Spoiler

[VeronikaVaraksina]

Spoiler

[tmich20]

Spoiler

 

[sylviayang]

Fun exercise practising the parsing tool

Spoiler

[CeliaC_Silje]

Spoiler

[ed_hayter]

Spoiler

[mgaronson]

Spoiler

Tried 3 times before settling on 'Best Method'. Reviewed others solutions. An improvement would be to add in a Text Input with the Street Suffixes as I noted that new Street Suffixes would have to be added to the formula.

Agree with others that it seems easy but is not! Not a beginner challenge!

[jnpac]

My approach was using left/right string functions. I believe regular expression is a better approach.