Formatting Excel Column

[prasath17 (Guru)]

Hi @…You can try as shown below…

Add Data Column

Invoke Code

dt.AsEnumerable().ToList().ForEach(Sub(row) row("Split")= system.text.RegularExpressions.Regex.match(row("Modified Yarn TC").ToString,"\d+(?=\/)"))

Edit Arguments

Output

Hope this helps…