Parse Zip code with Regex.

I am trying to parse and address to pull out the zip code from and address and it have written this regex \s(\d{5}[^a-zA-Z]*)\s and it works perfect until I hit an address that has a house number that matches that pattern.

Example:

David Rose PO Box 31741 Little Rock, Arkansas 72148 Unites States

74168 River Bend Road Searcy, Arkansas 72149 United States

I don't know if there a work around or if that is just something i just have to live with.

Regex

Accepted answers

Christine_Assaad

Hi @lbolin

Is it safe to say that the "," will always be included?

Option1:

.*,.*(\d{5}).*

If it will always end with United States (one record is misspelling United) so perhaps this could work

Option 2:

(\d{5})\s\w+\s\w+$

All comments

Christine_Assaad

Hi @lbolin

Is it safe to say that the "," will always be included?

Option1:

.*,.*(\d{5}).*

If it will always end with United States (one record is misspelling United) so perhaps this could work

Option 2:

(\d{5})\s\w+\s\w+$

Qiu

@lbolin
Agree with @christine_assaad , we need a flag to differ the zip code with other five digits number.

Or try a hard way, Use Find and Replace with Zip Code list.

http://phaster.com/zip_code.html

PhilipL

Hi @lbolin

If the data always ends with "United States" you could use GetWord to isolate the Zipcode.

Getword ([Full Address], CountWords([Full Address])-3)

JPSeagull

5 years later and Option 1 was the perfect solution for me with a mix of full addresses using either 5 digits or the 5+4 and it saved me the extra step to reduce it to 5 digit! Thanks!

Gaurav_Dhama_

I did not realise it was 5 year old until i read the comment 😂.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703