Split issues

[arijit1213 (Arijit Chowdhury)]

i want to extract data from a excel.i want data between keyword “Verified Purchase” to"4 people found this helpful ".the contain between this key word very time to time.but the fix things are the keyword-Verified Purchase and people found this helpful.

how can i extract this.?

[Yoichi]

Hi,

How about the following regex expression?

System.Text.RegularExpressions.Regex.Match(strData,"(?<=Verified Purchase)[\s\S]+(?=people found this helpful").Value

Regards,