How to match words to excel columns table and rank number the match according to the number matched

Help Community
1

Sample data.xlsx (11.8 KB)
Hi I am a super newbie to programming in UiPath.
We are students trying to do counting on specific words on a data table. Based on the matched word count from each column. Based on the count, rank the columns according to the counts of matched words. Please see the attached file for same data input and desired output…

2

Hi @Benson1

Using the following query in the Invoke code, you shall be able to get the count of the work ‘Car’ & ‘Red’, as per this use case:

in_dt.AsEnumerable.ToList.ForEach(Sub(row)
row("Car") = System.Text.RegularExpressions.Regex.Matches(row("Sentence description").ToString.ToLower, "\bcar\b").Count
row("red") = System.Text.RegularExpressions.Regex.Matches(row("Sentence description").ToString.ToLower, "\bred\b").Count
End Sub)

The output looks like this:

image
image1230×401 21.7 KB

And the arguments that you should send inside the Invoke Code panel:

image
image695×198 7.74 KB

Once you finish the count extraction, you can proceed with the ‘Ranking’ mechanism as per your requirements.

Hope this helps,
Best Regards.

1 Like
3

@Benson1

use for each row in datatable

inside use regex expression to find the cars and red in each row

redcount=System.Text.RegularExpressions.Regex.Matches(yourstring,“(red)”).Count
carcount=System.Text.RegularExpressions.Regex.Matches(yourstring,“(car)”).Count

pass the value in the columns of the car and red

to get total values of red and car in to the column

currentrow(“Total”)=carcount+redcount

cheers

1 Like
4

@Benson1

if you face any issues let me know

cheers

5

Thanks for the suggestion…

1 Like
6

Thank you for your help. However, as we are very new to these… i am facing some variable declaration errors… anyway to guide us? Thank you :slight_smile:

image
image1920×1023 255 KB

7

Thanks Shiva. But we are stuck with the following issues… as indicated in our previous post.

8

@Benson1

Can you check the values of redcount and carcount which you have passed in the invoke code