Regex expression help to capture string in between key words or punctuation

[cherylwinschuh]

Hello,

I am trying to find a regex expression that will capture the billing and shipping addresses and parse them to separate columns. This information comes imbedded in the body of an email. I would like to capture all the data the words "Billing Address" and "Shipping Address" as column Billing Address, and then capture the data between "Shipping Address" and "[http" as Shipping Address.

Currently using:

(Billing\sAddress:[\w\s\-?]+\,[\w\s\-?]+[\w\s\-?])

(Shipping\sAddress:[\w\s\-?]+\,[\w\s\-?]+[\w\s\-?])

The expressions do not capture the data for all orders due to punctuation spaces etc.

Is there a better expression to capture the data between?

sample string:

DETAILSBilling Address:Jeff Smith8400 Main Ave.St. Marie, VA 23434(555) 555-5555Shipping Address:Jeff Smith400 Wicker Ave.Billings, IN 89373(555) 555-1234[http://

Thanks for any help or suggestions.

[binuacs · Accepted solution]

@cherylwinschuh One way of doing this

[Felipe_Ribeir0]

@cherylwinschuh 

Another possible way