How to select spcial character in datatable in uipath

my datatable like


to filter datable special charactered and numbered column except alphabet

please help me find solution

You could loop through each row in the Datatable.
And then check if the column has special characters using Regex:

System.Text.RegularExpressions.Regex.IsMatch(row(“Data”).ToString, “^[a-zA-Z0-9\x20]+$”)

This is same as using the “Is match” activity,
Input: row(“Data”).ToString
pattern: “^[a-zA-Z0-9\x20]+$”

thank you so much , this is good but i dont want in boolean i want to select special character in column
could you please tell me using Select query

@brindhaS You could use “Matches” activity with the same input and pattern mentioned earlier. The result will be in a collection.

thank you ,i’ve tried i getting alpabet column ‘abc’ i want only special character column


use this in the pattern:


thanks its working,you said it is in collection

,In this collection it storing only one value at a timedt my datatable like this

thank you so much for quick reply