This is my excel data, i want to extract that “5454” value using “Total add on” row… [image] Using this query: InputDT.AsEnumerable().Where(Function(x) x(0).ToString.ToUpper.TrimEnd.TrimStart.Contains("Total add on")).Select(Function(y) y)(0)(2).tostring.trimend.trimstart But its giving me this …

How to extract data of particular row using Linq?

Yoichi (Yoichi) August 30, 2022, 6:25am 2

Hi,

Perhaps you should use uppercase like Contains(“TOTAL ADD ON”) becuase of ToUpper.

Regards,

2 Likes

Forum Engagement Daily Reports