Address Parsing

Hello Community,

I need help to parse addresses. Please refer the example below.

Example: STREET_NAME
E FRANKLIN ST #1
DWIGHT AVE 2F

HILLSIDE APT 3

N LIBERTY #11

23RD DR W

Expected results :

STREET_NAME STREET_TYPE UNIT
E FRANKLIN ST #1
DWIGHT AVE AVE 2F

HILLSIDE APT 3

N LIBERTY #11

23RD W DR

Datasets

Expression

Data Investigation

Accepted answers

Parse_060223.yxmd

All comments

You can use the Parse Output Method of the Regex Tool to get your desired results. I've attached an example workflow that uses the Regex Tool to achieve your expected results.

I hope this helps!

Thanks,

Wes

Address Parsing.yxmd

@EvansM One way of doing this

Thanks @WesCannon But still is not working I need Street_type names also.

Hi @EvansM , sorry about that, was trying to post too fast. This should get you a little closer, you'll still have a few exceptions that will need to be handled when there is no street type.

Address Parsing.yxmd

N. LIBERTY #11

HILLSIDE APT 3

EXPECTED RESULT

STREET_NUMBER STREET_TYPE UNIT

N.LIBERTY #11

HILLSIDE APT 3

23RD DR

Parse_060223.yxmd

@binu_acs Thanks this works for me.

Quick Links

Tags

This months top contributors

atcodedog05 19458

Qiu 15866

MarqueeCrew 13708

apathetichell 13703