Hello Everyone. I have a data table and 2 string variables and need to filter the data table using these two variables for different columns column1 and column2 but sometimes there will be null value in either variables. Eg: Variable A = abc, and variable B =“” | Variable A = abc, and variable B …

Hi, Can you try the following sample? [image] varA2 =if(String.IsNullOrEmpty(varA),".*","^"+System.Text.RegularExpressions.Regex.Escape(varA)+"$") varB2 = if(String.IsNullOrEmpty(varB),".*","^"+System.Text.RegularExpressions.Regex.Escape(varB)+"$") Then arrDR = dt.AsEnumerable.Where(Function(r…

Filter Data Table using multiple variables in LINQ

Help Studio

RK_0 (RK) December 24, 2022, 3:30am 5

Thanks for the quick response and solution.

Topic		Replies	Views
Filter DataTable using Linq Studio studio , question , workflow_diff	14	4894	June 29, 2022
Filter Data Table Activity not working with variables Help	3	2063	September 26, 2019
Need linq query for multiple filter Activities excel , question	30	2985	April 23, 2023
Filter data table with regex for value Studio activities , fitler-data-table	3	2728	December 13, 2022
Filtering Multiple Column using LinQ where one of the columns must have a null value Activities excel , activities , question	4	133	June 25, 2024

Filter Data Table using multiple variables in LINQ

Related topics