How to split the string
Folks,
I have a requirement where i want to split the string and place into the internal table which has the format (row,col,value).
example:
Table1
abc#def#ghi#
jkl#mno#pqr#
(In table1 )
I want above table to be splitted to below format
Table2
row col value
1 1 abc
1 2 def
1 3 ghi
2 1 jkl
2 2 mno
2 3 pqr
Please help me out in solving this.