while writing -
vDTCheatSheet.Asenumerable.Where(Function(r) r(“Supplier Name”).Tostring.Trim.equals(InArgSupplierName.Trim)).Copytodatatable
I want to convert to lowercase and check but I am not able to convert it for r(“SupplierName”).ToString
Can you let me know how to do it?
Could you just append
.ToLower to the above and check ?
We also would mention that when checking case insensitive, we would convert both operands to the same case, In your case,
InArgSupplierName.Trim.ToLower would also be required, For a case sensitive operation, we could keep the words/strings as it is.
You are almost there just append .ToLower Use this expression
vDTCheatSheet.Asenumerable.Where(Function(r) r(“Supplier Name”).Tostring.Trim.ToLower.equals(InArgSupplierName.Trim)).Copytodatatable
Please check the below post.
I have a problem that is a bit more complicated than just transferring from uppercase to lowercase.
The automation begins with getting famous soccer player’s names from a excel workbook and then in a for each loop searches for each player on a web page, and then lastly click on the correct soccer player using a selector which is combined with row(1).ToString.
The problem that I encountered however is that the names in the list are not exactly structured properly. Some names are written like “B…
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.