Extract word using regex

Help Activities
1

i have string
str = “Text sopp+sopp Ref: 123456 Text”
i want to extract “sopp+sopp Ref: 123456”
i have have this so far
System.Text.RegularExpressions.Regex.Matches(strText,“((sopp+\sopp\s\Ref:\s)\w+)”)
but when i run i get this error

image
image732×181 3.69 KB

can anyone help?
Thanks

2

try this instead
(sopp\+sopp\sRef:\s\w+)

if you print
System.Text.RegularExpressions.Regex.Matches(strText,"(sopp\+sopp\sRef:\s\w+)")(0).Value
you should get
sopp+sopp Ref: 123456

3

That works perfectly.
i dont suppose i could have help with one more?
strText = “Text TSM001-123456 Text”
im trying to extract “TSM001-123456”
i have this so far
System.Text.RegularExpressions.Regex.Matches(strText, “TSM001–\S*”)

Thank you

4

you can use (TSM001-\S+)

seems like you jsut want to extract the text between "Text " like this
image

if thats the case just use the below regex to handle all your cases, that way you dont need a separate regex for each case
Text\s(.*?)\sText

5

System.Text.RegularExpressions.Regex.Matches(strText,“(TSM001-\d+)”)(0).Value

6

sometimes it may not be between ‘text’
it could be between any string

7

It will only look for what we have given in the expression

1 Like
9

thank you

1 Like
10

Your Welcome @Rowley101 and thanks to @jack.chan

11

My bad this one now is perfect
System.Text.RegularExpressions.Regex.Matches(str,“(TSM001-\d+)”)(0).Value
Happy Automation…!

Regards,
Shaf

12

what is the difference from the previous one?

13

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.