Split datatable variable by Nth occurance of character

A LINQ Approach could look like this:

Assign Activity:
dtSplit =dtOrigVar.Clone

Assign Activity:
dtSplit =

(From d in dtOrigVar.AsEnumerable()
From sp in d(0).toString.Trim.Split(","c).Chunk(2).Select(Function (x) String.Join(",",x))
Let ra = new Object(){sp, d(1), d(2)}
Select r = dtSplit.Rows.Add(ra)).CopyToDataTable
2 Likes