I want to check if "Message text" column has few keywords like terminated or blocked? If anyone can help?

[anjasing (Anjali)]

[ppr (Peter Preuss)]

on datarow level:

{“TERMINATED”,“BLOCKED”}.Any(Function (x) YourDataRowVar(“Message text”).toString.ToUpper.Contains(s))

will return true or false when keyword was found

[VIDHATHA_THADURI]

use for each row then use if activity with row(“Message text”).ToString.contains(“blocked”).contains(“terminated”)

[ppr (Peter Preuss)]

on datatable level:

YourDataTableVar.AsEnumerable.Any(Function (d) {"TERMINATED","BLOCKED"}.Any(Function (x) d("Message text").toString.ToUpper.Contains(x)))

[anjasing (Anjali)]

@ppr

{“TERMINATED”,“BLOCKED”}.Any(Function (x) YourDataRowVar(“Message text”).toString.ToUpper.Contains(s))

It’s giving issue attached in image

Can u explain what is s here?

[ppr (Peter Preuss)]

i updated the statement above. x instead of s was needed

d,x… are like local variables within the LINQ

[HowTo] LINQ (VB.Net) Learning Catalogue - Help / Something Else - UiPath Community Forum

[Rahul_Unnikrishnan]

@anjasing Do you want to check whether entire excel contains terminated or blocked? or do you want the row details also?

If you just want to find terminated or blocked, you can use output datatable actiivity to convert datatable to string and then use Yourstringvariable.ToString.Contains(“Text to check”)