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 …

Hi, [image] Vinit_Mhatre: ToUpper. Perhaps you should use uppercase like Contains(“TOTAL ADD ON”) becuase of ToUpper. Regards,

How to extract data of particular row using Linq?

Vinit_Mhatre (BotBuilder) August 30, 2022, 6:28am 3

Lol thanks now its giving proper ouput

1 Like