:: Forum >> Version 2 >>

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!
cheng
Tuesday, June 19, 2007



This topic is archived.

Back to support forum

Forum search