Fastest Way to Split Each Row in Column

[prasath17 (Guru)]

@AnnaDewitt - You can try invoke code method, please refer this below post where the column has been split similar to what you are trying above…

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…

Hope this helps…