Challenge #54: Data Prep Address Parsing
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
catarina_pimpao
8 - Asteroid
12-31-2018
07:34 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
prislam
8 - Asteroid
01-02-2019
08:49 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Tom_Luthi
8 - Asteroid
01-03-2019
08:00 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
KatyP
7 - Meteor
01-03-2019
01:27 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
AndrewLehm
8 - Asteroid
01-04-2019
03:06 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
13 - Pulsar
01-07-2019
04:24 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
My solution:
Spoiler
Not totally happy with this because I did the parsing by keyword: Street, Avenue, etc. Works for the sample provided but isn't the best solution.

sachin02
8 - Asteroid
01-08-2019
03:54 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
ipeng
8 - Asteroid
01-08-2019
07:16 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
sachin02
8 - Asteroid
01-08-2019
08:54 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
EW
11 - Bolide
01-11-2019
12:01 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
My solution:
Spoiler
I started with a list of street terms (Street, Avenue, DR) and did find and replace to add |s after them. I suspect there's a way to get the RegEx tool to do most of the other steps itself (output null for missing zip codes, for one) but I added extra tools instead.
