Friday, December 2, 2016

Sachin

I have a sting '101|1|1|2|3|4|5|6|7|8|9|10##102|1|1|2|3|4|5|6|7|8|9|10' want to split in row column values like split with '##' for rows and | for columns

Output
id val1 val2 val3 val4 val5 val6 val7 val8 val9 val10
101 1 2 3 4 5 6 7 8 9 10
102 1 2 3 4 5 6 7 8 9 10