Filter data table with regex for value

[Yoichi]

Hi,

@Westfield

I have tried to do this with the filter data table activity by using a regex in the value field to get the ID and filter that to a new data table, but I just can’t get it to work.

Unfortunately, FilterDataTable activity doesn’t support regex.
In this case, we can use LINQ where method and regex as the following, for example.

dt = dt.AsEnumerable.Where(Function(r) System.Text.RegularExpressions.Regex.IsMatch(r("ColumnName").ToString(),"regex pattern")).CopyToDataTable

Hope this helps you.

Regards,