I’m trying to do a case insensitive Linq search in a DataTable and return the first row. For example the value in the DataTable could be “Apple”, but I need to match with “APPLE”, or “AppLE”, etc. I’m trying to use the following to return the first DataRow found: dt.AsEnumerable().Select(Function(x…

Hi @carlor Try this: matchingRow = dt.AsEnumerable().Where(Function(x) x("Column0").ToString().ToLower() = strString.ToLower()).FirstOrDefault() matchingRow is of DataType System.Data.DataRow If you want to return boolean value then use the below syntax: isDataRowFound = dt.AsEnumerable().Any(F…

[image] carlor: dt.AsEnumerable().Select(Function(x) x(“Column0”).ToString.ToLower.Equals(strString.ToLower)).FirstOrDefault() (From d in dt.AsEnumerable() Where d("Column0").ToString().ToLower().Trim().Equals(strString.ToLower) Select r = d).FirstOrDefault() [image] …

[image] carlor: I’m trying to use the following to return the first DataRow found: ensure also that the variable which receives the LINQ returned result is of DataType: DataRow

Hey @carlor try this: dt.AsEnumerable().FirstOrDefault(Function(x) x("Column0").ToString().ToLower() = strString.ToLower()) If you want to know something more about LINQ, I can recommend @ppr tutorials: [HowTo] LINQ (VB.Net) Learning Catalogue - News / Tutorials - UiPath Community Forum

Hi @carlor Try this: dt.AsEnumerable.Where(Function(x) x("Column0").ToString.ToLower.Equals(strString.ToLower)).FirstOrDefault() Hope it will helps you :slight_smile: Cheers!!

@carlor YourDataRowVariable = dt.AsEnumerable().FirstOrDefault(Function(x) x("Column0").ToString().ToLower() = strString.ToLower())

This worked! Thank you. Looks like I have some reading to do :slight_smile: Carlo.

[image] carlor: This worked! Perfect, so the topic can be closed Forum FAQ - How to mark a post as a solution - News / Tutorials - UiPath Community Forum

This worked too! Thank you, Carlo.

This worked. I’m also flagging it as the solution because I like that it has FirstOrDefault to ensure I only get one. Plus you added the bonus boolean solution :slight_smile: Thank you, Carlo.

This also worked. Looks like there were many ways to accomplish the same thing. Carlo.

Case Insensitive Linq search help

Help Activities

ppr (Peter Preuss) February 19, 2024, 9:52pm 2

(From d in dt.AsEnumerable()
Where  d("Column0").ToString().ToLower().Trim().Equals(strString.ToLower)
Select r = d).FirstOrDefault()

Topic		Replies	Views
Linq to check Studio studio , question , activities_panel	11	548	June 12, 2023
Is there a way to do a caseInsensitive search or query on a Datatable in Uipath Studio datatable , activities , question	6	4812	March 30, 2020
Ignore case while searching the data table Activities uiautomation , activities , question	7	264	December 10, 2024
Filter datatable with non sensitive value Activities datatable , excel , activities , question	9	913	September 27, 2023
Linq Query to Filter datatable - Contains Studio datatable , uiautomation , data_manipulation , linq , linq-query , linq-quey	9	2854	May 16, 2023

Case Insensitive Linq search help

Related topics