How to pic two value from regex

Help
1

Hi Frnds
I have a text “June 2009 - September 2014 (5 years 4 months)” from this I have to only pic the year value like -2009 and 2014 however while using matches activity I am only able to pick first value using the regex expression "(\d){4} ".
I am only receiving 2009

2

Format is same for all records ?

Thanks
@manish0077

3

yes it is same

4

Use this regex

(\d{4})\s.*(\d{4})

Group 1 and Group 2

Thanks
@manish0077

5

use matches activities to get the multiple matches.
string matches activities in UiPath.

6

its picking “2005 - April 2007” I only need 2005 and 2007 because I need to put the information into the system like started year and end year

7

\d{4} this will work fine!

8

its only picking first value from line I need both value

9

Yeah its getting full match but ive done it in groups i.e Group 1 is 2005 and Group 2 is 2007

Use it in for each loop and to access groups in regex use
item.group(0).value

Check the below link

Thanks
@manish0077

10

you can use for each loop and give regex out put value
and print it like this Item.ToString

11

Still confused how to implement this into uipath while use the provided regex its returning the full match value .
image

12

image

13

image

14

can you try this \d{4} @manish0077

15

The for Each type argument should be RegularExpressions.Match and inside loop write
item.Groups(0).Value

Thanks
@manish0077

2 Likes
16

Thanks a Lot @hasib08

1 Like
18

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