Hi All,
I am looking for the recursive function in C# for spliting the single row data into multiple row,
I have a data table in C# and the table contents data like
column --> :| A | B |C |D
---------------------------------------------------
Row 1 :|5,8,10-20 | 15 |7,10 |20,30
Row 2 :|30 | 16,18,20-25 |11,13 |35
---------------------------------------------------
I want to spit above data in to multiple row for example
Row 1: of the above table needs to split in below multiple rows shown below,
5,15,7,20
5,15,7,30
5,15,10,20
5,15,10,30
8,15,7,20
8,15,7,30
8,15,10,20
8,15,10,30
10-20,15,7,20
10-20,15,7,30
10-20,15,10,20
10-20,15,10,30
Row 2: of the above table needs to split in below multiple rows shown below,
30,16,11,35
30,16,13,35
30,18,11,35
30,18,13,35
30,20-25,11,35
30,20-25,13,35
Please advice
Thanks in advance.