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?

system (system) Closed September 2, 2022, 6:29am 4

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.

Topic		Replies	Views
Linq Query for extracting excel from row containing specific string till row containing specific string Studio studio , question , workflow_diff	4	1309	February 4, 2023
Linq query to Extract the Matched Values from the Datatable (Not Specific Column) Studio studio , question , activities_panel	4	304	December 23, 2023
How to extract complete DataRow given using Linq? Something Else question , linq , data-row , linq-quey , datarow , extract-datarow , extract-data-row	6	1065	September 18, 2022
How to get the above data of the value using linq query Studio studio , question , workflow_diff	9	3186	February 28, 2022
GET NUMBER OF ROW Studio studio , question , activities_panel	5	109	June 2, 2024