Select certain data from datatable. Filter alternative

Help Studio
,
1

I have a huge data table which I want to filter. However the filter activity is too slow. Do you know any other way I can filter based on a column? For example I want to filter for anything that has 23 at the end or before a “?” In column 2. Example below.

Ex.
Input data:
Abc___0023?01___xyz
Ghy___1123_______fyu
Uyt___5644?89___tui
Yrg___7823?12____uop
Uiy___5654_______uui

Output desired:
Abc___0023?01___xyz
Ghy___1123_______fyu
Yrg___7823?12____uop

2

@Terry_Lars
give a try on a LINQ

assign activity
left side: Datatable | dtFiltered
right side:
(From d in yourDataTableVar.AsEnumerable
Where d(YourColNameOrIndex).tostring.trim().EndsWith(“23”) Or d(YourColNameOrIndex).tostring.trim().Contains(“?”)
Select d).CopytoDataTable

the check for ? can may be better expresed with a Regex
grafik

So an alternate could look like:

(From d in yourDataTableVar.AsEnumerable
Where Regex.IsMatch(d(YourColNameOrIndex).tostring.trim(),"\?\d{2}$|23$")
Select d).CopytoDataTable

Ensure following for this:
grafik