Regex pattern to extract address from string

[MasterOfLogic (David Oku)]

Hello guys Please I would love to extract the highlighted address from the string . The address is always going to start the string and end with a zip code as seen

thanks in advance

[Yoichi]

HI,

How about the following expression?

System.Text.RegularExpressions.Regex.Match(yourString,"^.*?\b\d{5}\b").Value

This assumes zip code is 5 digit.

OR, if “Phone:” always follows Address, the following might be better.

System.Text.RegularExpressions.Regex.Match(yourString,"^.*?(?=Phone:)").Value

Regards,

[Gokul001 (Gokul Balaji)]

HI @MasterOfLogic

How about this Regex expression

System.Text.RegularExpressions.Regex.Match(yourString,".*(?=\sPhone:)").Value

You can also try with Split expression

Split(YpourString,"Phone")(0)

Regards
Gokul

[Gokul_Jayakumar (Gokul Jai)]

@MasterOfLogic

The address is always going to start the string and end with a zip code as seen

Hello @MasterOfLogic ,
Try this Regex

System.Text.RegularExpressions.Regex.Match(yourString,".*(?=\sPhone:)").Tostring.Trim

System.Text.RegularExpressions.Regex.Match(YourString,".*\D\s\d{4,8}").Tostring.Trim