Search In Excel Data Table using linq

[sharazkm32 (Sharaz K M)]

Try using invoke code method with following arguments

1. Data Table → Input
2. Charges → Input String
3. Price → Input Double/ Int / String
4. ou_RowCount → Output Filtered Row Count

Code to be pasted in the invoke code method.
ou_RowCount= dtInput.AsEnumerable().Where(Function(row) row(“Charges”).ToString()= in_Charges and row(“Price”).ToString= in_Price.ToString).ToList().count

Kindly note that - use regex and format price value before passing to this code segment. Once the code run is completed - get the output to a variable and check whether the count is greater than 1 or not