Challenge #54: Data Prep Address Parsing

[clmc9601]

My solution

Spoiler

Worked backwards to parse and remove zip, then state, then city-- all within the formula tool

[jalizmaldonado]

Writing expressions is not a skill I have so attached is a work around I was able to figure out.

[ajimenez]

Challenge #54: Data Prep Address Parsing

A tricky one, initially I thought about using RegEx with Formula but couldn't make it worked and I ended up checking the solution. I changed the last RegEx for ^.+(\d{5})$ to add something

[alexnajm]

Very nice challenge!

[rajenderk18]

Here is my Solution:

Spoiler

[keng]

I did my parse a little differently so I used a data cleanse tool at the end! Still got the same results though! 

[jfrg125]

Spoiler

[CRM66]

Completed

[Toons]

My solution :

Spoiler

[uk_msmt]

Spoiler

Solution attached.