How to check particular string in a datatable

Help Studio
, ,
4

Hi

Let’s make it in a simple method of using AsEnumerable if you have a datatable named dt

Use a IF activity like this with a condition

dt.AsEnumerable().Where(Function(a) a.Field(of String)(“yourcolumnname”).ToString.ToUpper.Contains(“MD/GEC”) OR a.Field(of String)(“yourcolumnname”).ToString.ToUpper.Contains(“GEC”)).CopyToDatatable().Rows.Count > 0

If it’s true it goes to THEN block which means there are records with those texts
So send mail to one mail I’d

Or goes to ELSE block where send to another mail I’d

Cheers @kavya.s16