How to check if a string is contains english word

Help Activities
, , , , , ,
5

Hi

Hope the below steps would help you resolve this

  1. Let’s take you have a Datatable read from excel and named as dt

  2. Now use a FOR EACH ROW ACTIVITY and pass dt as input

  3. Inside that activity use a Assign activity like this

str_matches = System.Text.RegularExpressions.Regex.Matches(yourRowValueString,“[a-zA-Z]+”)

This will give you a list of Match objects ( IEnumerable<Match> ), let’s call it matches , with one element. Let’s call this first match match , so match = matches.FirstAnd if you want to process them and write back to the same excel

Select the word means you can process them,I.e., you can do the string manipulation as you want

Cheers @Yazan_Alotaibi

1 Like