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 [image] thanks in advance

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:)").V…

Regex pattern to extract address from string

Help Something Else

Gokul001 (Gokul Balaji) November 7, 2022, 4:58am 4

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

Topic		Replies	Views
Extract Address from String with RegEx Studio studio , string , question , string-manipulation	11	4669	October 10, 2021
Extracting house number from address including characters - 1A, 1B etc Help	14	7624	April 18, 2019
Separate street name from street number Help activities , regex	1	5935	October 18, 2017
How to use spilt or regex? Please guide me Studio	16	991	June 2, 2021
I want extract particular part of string? Studio	4	474	May 30, 2023

Regex pattern to extract address from string

Related topics