I need some advice on which way I must go to import an text file. The file is not in a fixed format I have included an sample of the file.
I require the output to be written to a file in the following format.
Heading1,Sub Heading 1,57,7257.00,73.44,7,183.5
Heading1,Sub Heading 2,889,1083.49,104740.44,10
Heading1,Sub Heading 3,1,8340.49,104825.88,96,4
Heading2,Sub Heading 1,0,80.71,1.50,79.21,CR
Heading2,Sub Heading 2,0,645.51,404.92,240.59,C
Heading2,Sub Heading 3,0,0,0,CR
the same with Heading 3...
I need to take each heading and then read the sub details and the sub details have the following columns.
Any sample would be appreciated.
Thank you very very much