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.
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
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.
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