Filter Columns

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


lets assume you are talking about values like
HAH12, HAH3456

then give a try on:

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


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: