How to select spcial character in datatable in uipath

Help
1

my datatable like

Data
$@123
india
kraft
£763
!900

to filter datable special charactered and numbered column except alphabet

please help me find solution

2

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, “[1]+$”)

EDIT:
This is same as using the “Is match” activity,
Input: row(“Data”).ToString
pattern: “[2]+$”

  1. a-zA-Z0-9\x20 ↩︎

  2. a-zA-Z0-9\x20 ↩︎

3

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

4

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

5

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

thanks

6

@brindhaS
use this in the pattern:

“[1].*$”

  1. ^a-zA-Z0-9/- ↩︎

7

thanks its working,you said it is in collection

Saved%20Picturess
Saved%20Picturess1309×208 15.1 KB
,In this collection it storing only one value at a timedt my datatable like this

8

thank you so much for quick reply