How to apply regex in thi datatable


#1

doc%20EAN hhj].xlsx (12.2 KB)
Hey
How to apply regex in this datatable where EAN no which is of 13 digits is present in description. How to extract this highlighted portion and store in EAN column which is blank.?


#2

@mhk15 Read the excel and assign output to datatable variable. Convert datatable to string using output datatable activity. Then apply following regex for the string variable, u will get result with required output.

System.Text.RegularExpressions.Regex.Match(UrStringVariable,"[\d]{13})"

If u have more numbers which has 13 digits use matches instead of match