Preprocess Excel Column

[Yudhisteer_Chintaram1 (Yudhisteer Chintaram)]

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)

[Songoku_ichi_2907 (Sogoku Ichi)]

I suggest you to use workbook read range activity and workbook write range activity.

At read range’s properties panel, assign’s properties panel and write range’s properties panel you set as below.

[Yudhisteer_Chintaram1 (Yudhisteer Chintaram)]

Can you share the xaml file please?

[prasath17 (Guru)]

@Yudhisteer_Chintaram1 - You can use the invoke as previously suggested in this post…

Formatting Excel Column

Hi @…You can try as shown below… [image] Add Data Column [image] Invoke Code dt.AsEnumerable().ToList().ForEach(Sub(row) row("Split")= system.text.RegularExpressions.Regex.match(row("Modified Yarn TC").ToString,"\d+(?=\/)")) Edit Arguments [image] Output [image] Hope this helps…

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…

[Songoku_ichi_2907 (Sogoku Ichi)]

You can reference this file, hope that help, and you can optimize it.
Read data from excel.xaml (6.5 KB)