Hi @Yoichi
-
Use Read Range activity → Store it as DtRead
-
Use For each row in data table activity
Note : In the LINQ it will also loop through Line by Line there is no difference
Inside the Loop
- Use Assign activity
CurrentRow("Description") =
System.Text.RegularExpressions.Regex.Match(CurrentRow("Description").ToString,"\d*$").Tostring
Outside the Loop
- Use Write Range activity and Pass the DtRead as output
Regards
Gokul