How to get specific value from each row of excel file?

Learning Hub Academic Alliance
1

I am trying to get the value from the column called description in excell file. I use foreach row to loop through the excell file then I use assign activiy inside the foreach loop. In the assign activity I use this argument “Regex.Match(row(0).ToString,”(waive\sannual).*?(?=/)“,RegexOptions.Multiline).Value” to get only the sentence start from waive annual until the first “/” sign. But when I use message box to show the result, it shows an empty message box. What is the problem? that row(0) is where the description located. Here is the sample of the data in the excell file
image

2

here is how I made tthem in uipath
2

1 Like
3

@anwar_ipul

Check as below

image
image1185×738 14.2 KB

Regex is not matching with any value

thanks

5

I have fond the solution, I have to use another loop inside the foreach loop to get the value. The problem is not with the pattern expression

6

@anwar_ipul

Yes, if you want always first value then you can use nilai(0).Tostring

OR

You can use For each Loop

Thanks