Regex condition for if activity in datatable

studio
regex

#1

Dear reader,

I have a short question.

Does anyone know a regex condition which selects the rows with lastnames with no figures, so only text? With the next one I still can’t get the right records.

System.Text.RegularExpressions.Regex.Match(columnname, “^[A-Za-z]{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20}$”).Success

Who can maybe help me?

Best, Matt


#2

@mattsheep can i have some examples of lastnames. i didn’t get your question.


#3

Dear reader,

Maybe my question wasn’t specific enough, sorry for that. I want to check if in a variable no numbers exist. I have a list with surnames and I want to check if in these surnames no numbers popup.

The next regex condition doesn’t help me: System.Text.RegularExpressions.Regex.Match(columnname, “^[A-Za-z]{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20}$”).Success

Who has maybe an answer for me?

Best, Matt


#4

Hi @mattsheep,

Use Is Match activity get
Properties
input->Give your input string surname
Pattern
[0-9]
Result ->you will get the Boolean value.

If True-> the surname contain number
if false -> the surname doesn’t contain number.

Regards,
Arivu


#5

Hi @mattsheep,
I have attached the flow for your reference.
Main.xaml (12.1 KB)

Thanks and Regards
P.Ajithkumar


#6

Hello,

Thanks for your help. First I tried:

System.Text.RegularExpressions.Regex.Match(columnname, “^[a-zA-Z\s/-’]{1,50}$”).Success

For me this definitely helps. Now I only need to put two varuables in this regex condition, it contains words with an ï or an ä. Does anyone know which character I can use after the \ ?

I really appreciate your help.

Matt