How to scrape zip code from address

Help Activities
, ,
1

Hello Friends,

Please help me in bellow, I wanted to scrap zip code from below address

Kath Smith
317 County Rd
Torrington, CT 06790-4206

Need OUTPUT: 06790

I want only 06790 in variable

2

Hi @Bot_Learner

How about the Regular expression?

System.Text.RegularExpressions.Regex.Match(YourString,"\d.*(?=\D\b\d{4}\b)").Tostring

image

Regards
Gokul

1 Like
3

RegEx

(?<!\d)\d{5}(?!\d)
1 Like
4

Try using this regular expression \D(\d{5})\D

System.Text.RegularExpressions.Regex.Match(YourString,"\D(\d{5})\D").Tostring
1 Like
5

@Bot_Learner
(?<=CT\s)(.*?(?=-))

1 Like
6

Hi @Bot_Learner

Try using the following Regex expression:

[0-9]+(?=-)

image
image1077×313 15.9 KB

Hope it helps!!

Regards,

1 Like
7

Thanks all @Gokul001 @postwick @aquinn @raja.arslankhan @Parvathy for reply …could you plz let me know…how can i extract state name…like CT in above example…everytime time i have different sate of 2 letters only.

8

Google is your friend on these things.

https://www.google.com/search?q=regex+to+get+2+letter+state+from+address

1 Like
9

Hi @Bot_Learner

Use this regex to scrap state name

System.Text.RegularExpressions.Regex.Match(inputString, “(?<=\b)[A-Z]{2}(?=\s\d)”).Value

Thanks!!

1 Like
11

@Nitya1 thanks for u r response.

1 Like
12

@postwick sir i dont know how to use it…but i extracted state name by split string

13

You can do that as long as the address is always formatted exactly the same.

14

Hi @Bot_Learner

Try using the following regex expression

[A-Z]+\s

image
image903×335 17.3 KB

Hope it helps!!

Regards,

15

check this post

looks related for your request

Regards