Searching string with case insensitive

I have data in excel I need to filter the data in excel based on input given by the user without case insensitive.

For example, user can Enter “Oneplus” or “OnePlus” or “ONEPLUS”.I need to search for the same word entered by the user.

str=“OnePlus 8 5G UW 128GB 8GB RAM Verizon (Locked) Smartphone”

Kindly help me in fixing this.

Hi @kavya_mamidishetti
You can try this way to filter it

let’say u had an excel with column2 having the data u need to search,

then storing the excel in dt1, and userinput is stored in data varable

use the below assign activity
dt1 = dt1.AsEnumerable().Where(Function(row) row(“column2”).ToString.Trim.ToLower.Contains(data.ToLower)).CopyToDataTable

This way you can filter the datatable

Nived N
Happy Automation

1 Like

Thanks @NIVED_NAMBIAR .Though i didn’t understand it much,I tried.It is displaying “The source contains no DataRows”.I have used Filter Data Table.Stored the user input in “pname” variable and searching the value(pname) in “Product name” which is column in Excel but it is searching with Case sensitive.

Hi @kavya_mamidishetti

Sorry I had used equals instead of contains

That is why you don’t get tey results

I had updated my answer in my first response

Check out that


Nived N

Happy Automation