How to extract a value from a string?

Help
, , ,
1

I need to extract 34 from the string “1 to 34 out of 34 candidates”.
I am using "(?<=1 to) [\s\S]+?(?= out) " to extract 34 and I use “Matches” activity in UiPath to execute the same.

What I am getting is :slight_smile:
System.Linq.Enumerable+d__97`1[System.Text.RegularExpressions.Match]

image

2

Hi @sivapriya.s,

Can you try this
Regex.Match("1 to 34 out of 34 candidates","(?<=1 to) [\s\S]+?(?= out)").Value

3

(?<=1 to\s)[\s\S]+?(?= out)

4

Hi @sivapriya.s
try this

\d{2}

Thanks
Ashwin S

5

Hi
we can use a simple assign activity like this
stroutput = System.Text.RegularExpressions.Regex.Match(TotalResults.ToString,“(?<=to).*(?=out)”).ToString.Trim

Cheers @sivapriya.s

6

I tried all the above expressions. But getting the same error.

I am able to get value in Regex editor.
But while executing in UiPath, I am getting the error.

I am using Match Activity here.
Is there any other Activity?

7

did this expression helped you on this
may i know the error if any on this or the output we get
@sivapriya.s

8

@sivapriya.s

Use assign activity
var1 = Regex.Match("1 to 34 out of 34 candidates","(?<=1 to) [\s\S]+?(?= out)").Value

9

@aanandsanraj

Thank you so much. It worked. :slight_smile:

10

You are Welcome @sivapriya.s :slightly_smiling_face: