Filter Columns

Help Studio
1

Hi guys,

the web’s screen ( one page with scroll down button ) contains 1k row in one column

i need to filter the rows, that’s contains “HAH” word then “number” and ignore all other rows.
how can i do this filter with faster way? While i have more than one pages, so the data are very large

Regards,
Zainab

2

@AMEERA
lets assume you are talking about values like
HAH12, HAH3456

then give a try on:
grafik

(From d In dtData.AsEnumerable
Where System.Text.RegularExpressions.Regex.IsMatch(d(YourColNameOrIndex).toString, "HAH\d+")
Select d).CopyToDataTable

Recommendations:
grafik

and do shorten the statement to:

(From d In dtData.AsEnumerable
Where Regex.IsMatch(d(YourColNameOrIndex).toString, "HAH\d+")
Select d).CopyToDataTable

handling possible empty filter result:

grafik
grafik707×346 46.6 KB