I have tried searching for a simple VB script that would go through a DataTable (derived from excel) looking for a specific value and returning a boolean, however, I have not been able to find one. I feel as though this should be a simple script but I can’t seem to master it. Does anyone have a solution or suggestions? Thank you.
may you give us an example of table ?
Your request is a “value exists” result?
The table is literally one column that has a header and 7-8 values, that’s it haha.
This code will work: if you change valueExpected
dataTable.Rows.Cast(of DataRow).Any(function(row) row(0) = valueExpected)
dataTable is a DataTable and valueExpected is an object if you want it to be a sstring you must add .tostring after row(0).tostring
Thank you very much. One last thing…so how does this return a boolean for “value exists”? Would that be handled with the arguments?
Any is a linq expression that give you true if it exist a value in the list that fullfills the expression
You can also use Where instead, in case you want to get a list of all rows matching the expression.
Ok that makes sense. So could you store the result of this code into a variable in order to use in an “if” statement later on?
write it in the if statement and it will works in case you want to store it you must declare a boolean variable and use an assign activty but its not required.
Great. Thank you!!
@Ignacio_Insua_Feito Based on your replies, the expression u have given works for datatable with one column. Is it works if we want to search for a value in datatable with multiple coulmns also.
My statement works fine always but may change if you want to validate more than one condition i will search and edit to reffer to another comment where i explain further