read data from a text file and extract the data into tabular format

hi, anyone can help me figure out how to read data from a text file like this:

10980012907200228082002

and extract the data according to this kind of format:

Record type 1
TY-RECORD PIC (1).
ID-PARTICIPANT PIC (6).
DT-START PIC (8).
DT-END PIC (8).


i would want the program to extract the data and display them like this:

TY-RECORD ID-PARTICIPANT DT-START DT-END
1 098001 29072002 28082002

and to save them in an excel format. I have plenty of record types (0 - 9) and need to display them in separate tables.

does anyone has a source code for this? or at least somebody pls guide me to figure out ways to create the program.

many thanks!