Excel activities extract a part of a value in a column

[BlueBird1 (BluebBird)]

Hey, I want to add a column to my excel, that contains only the first numbers before “_EP3…”, would you help me to choose the right activity for my problem.

[arjunshenoy]

Hi @BlueBird1, welcome to the Community.

→ Add a data table column using the activity Add Column. Let’s say you added a column with the name ‘numData’

→ Now use the following query in the Invoke Code activity to fill the column with the numeric data:

yourDt.AsEnumerable.ToList.ForEach(Sub(row)
row(“numData”) = System.Text.RegularExpressions.Regex.Match(row(“ID”).ToString,”\d+(?=_EP)”).Value
End Sub)

Edit: Output-

Hope this helps,
Best Regards.

[Anil_G (Anil Gorthi)]

@BlueBird1

You can use the following

1. Write cell with formula =LEFT(A2,FIND("_EP3",A2)-1)
2. Autofill range activity

Cheers

[BlueBird1 (BluebBird)]

Thank you all for helping me