Hi, I have this column “Column ID” where I need to take only the first 4 numbers and re-write in the same column. See below:
BEFORE:
AFTER:
Can you help please?
Thanks!
UIPath_Excel_Scratch (8).xlsx (98.1 KB)
Hi, I have this column “Column ID” where I need to take only the first 4 numbers and re-write in the same column. See below:
BEFORE:
AFTER:
Can you help please?
Thanks!
UIPath_Excel_Scratch (8).xlsx (98.1 KB)
I suggest you to use workbook read range activity and workbook write range activity.
Can you share the xaml file please?
@Yudhisteer_Chintaram1 - You can use the invoke as previously suggested in this post…
Change the code like this…
dt.AsEnumerable().ToList().ForEach(Sub(row) row("Containter ID")= system.text.RegularExpressions.Regex.match(row("Containter ID").ToString,"^\d{4}"))
Hope this helps…
You can reference this file, hope that help, and you can optimize it.
Read data from excel.xaml (6.5 KB)