So I can properly sort my on my column , I need to remove the "-" and sort on index 1 after the split.
Ideally, I'd like to do something like this.
Datatable dt; Dt.columns.add("ProductnumSplit", typeof(string), "ProductNum.Split('-')");
Builds of course, but doesn't work. Any Ideas on a work around?
Also, I apologize if there are any syntax issues, I'm not near a computer And am typing this from my iPad . (And it took 5 times longer too )