How to use Regex for this sentence

Help Studio
, , , ,
1

I want to extract the text in between last occurrence of sent to & as on
What will be the regex code for this…
The answer must be
9876_India
9876_Bangalore Electronic City 17

This test session has been sent to 9876_India and except the cases that related to be and has been sent to 9876_India as on the way.

This test session has been sent to 9876_Bangalore and except the cases that related to be and has been sent to 9876_Bangalore Electronic city 17 as on the way.

IMG_20221107_161430
IMG_20221107_1614301080×252 39.9 KB

IMG_20221107_164110
IMG_20221107_1641101080×225 44.4 KB

2

Hi @Praveen_Vs

9876_india is the static output?

Do you have any static value in the input?

3

You can try with regex expression @Praveen_Vs

System.Text.RegularExpressions.Regex.Match(YourString,"(?<=sent\sto\s)\d{1,6}\w\S+(?=\sas\son)").Tostring

image

4

The text in between sent to & as on will be dynamic.

5

HI @Praveen_Vs

Try this

System.Text.RegularExpressions.Regex.Match(StrVariable,"(?<=sent to )\S+(?=\sas on)").ToString

image

Regards
Sudharsan

6

Check out this expression @Praveen_Vs

7

Hi,

How about the following expression?

System.Text.RegularExpressions.Regex.Match(yourString,"(?<=sent\s+to\s+).*?(?=\s+as\s+on)",System.Text.RegularExpressions.RegexOptions.RightToLeft)

Regards,