Regex matches in rows in excel table

Help Forms
, , , , ,
1

Hi, Masters! Need Help! I have to look for matches in each table rows, and if matches finded i have to write match near current row. I tried it by “read range” then with “for each row in data table” tried match every row step by step but had an error
Regex working good
i will happy for any advice!

2

image
regex

3

sequence

image
image522×673 15.8 KB

4

Hi @Nursultan ,

Could you please provide us an example of the expected output?

Kind Regards,
Ashwin A.K

5

match activity

image
image943×564 9.98 KB

6

image
image804×240 3.52 KB

like this

7

Kindly note: match(1) is taking the second match from the matches collection
Also in case of no matches it will result within a reference not set exception

we would recommend to handle it more defensive by prechecking if there was a match
Also check if maybe the acces of a group from the match was intended

[CheatSheet] - System.Text.RegularExpressions | RegEx - News / Tutorials - UiPath Community Forum

8

i also tried match(0).Value but it gives a reference not set exception

9

am i trying right logic? how do u think?

10

do not mix up groups and match occurences

we check with isNothing(…), matchesOutPutVar.Count > 0 or matchVar.Success different scenario

e.g. myMatches - output from Matches activity where no match was found
grafik

as we told

11

please check the immediate panel samples from above. we introduced some initial defensive prechecks

12

thx for advices! i will explore that topic [CheatSheet] - System.Text.RegularExpressions | RegEx - News / Tutorials - UiPath Community Forum and text later :grin: