Unable to fetch the right index

Help Studio
, ,
1

Hi Team,

I want to fetch the index value of a datatable row based on a column value and I am using the below code

Index =(PRStatusReportDT.Rows.IndexOf(PRStatusReportDT.AsEnumerable().Where(Function(row)
(row(“Submission Number”).ToString.Contains(Transactionitem.SpecificContent(“Submission Number”).ToString) And
row(“Mail Subject”).ToString.Contains(Transactionitem.SpecificContent(“Mail Subject”).ToString) And
row(“Mail Receiving Date”).ToString.Contains(Transactionitem.SpecificContent(“Mail Receiving Date”).ToString) And
DateTime.FromOADate(Convert.ToDouble(row(“Mail Receiving Time”).toString)).toString(“hh:mm:ss”).Contains(Transactionitem.SpecificContent(“Mail Receiving Time”).ToString)And
row(“SF_Dashboard_Status”).ToString.Equals(“”))).ToArray()(0)))

The last condition to check for empty column cell value is not working I believe .

The input file looks like :

image
image1028×375 8.09 KB

2

Hi @Yoichi

Can you please help