Challenge #54: Data Prep Address Parsing

[Bobbyt23]

Still don't enjoy Regex.

[Jon-Knepper]

Here is my solution!

Spoiler

[mshishido]

REGEX

[danielhoge]

Spoiler

[zraposoaandm]

Spoiler

[AndrewPowell]

Spoiler

Well that regex drove me mad for a while, guess I'd best getting some more studying done 😉

 

[michael_apau]

Spoiler

 

[Mikeimbi]

Challenge 54

[fluteman]

I made it difficult by really thinking about the syntax of a street address.

A reference table for street long and short names was used.

A reference table for state long and short abbrev was used.

A comment was made that in the US, we use SE, SW, NE, NW after the street type ST NE (for example).

To build out the reference table further inserting rows for SE SE, SW, SW, NE NE and NW NW should suffice.

We also did a check where the state may come in long format (even though it wasn't required).

The idea was to get the address into a standardised format.

We used reversestring() function and find/replace tool heavily!