|
EXPL Export a TAS List to a File
The EXPL command enables any list created by TAS (e.g. Task, Names or Load lists) to be exported to a SAM file. The file is ready to be printed, and can be done so with a /PR file,SPACE=E,STARTNO=8 command, or it can serve as the input for further processing.
To reset the EXPL mode, see the NEXPL command.
file Name of the output file. If no file name is specified, the file name of the last EXPL command will be extended, or the file assigned with LINK=TASEXP will be used.
O Overwrite. An existing file with this name will be overwritten.
Standard if a file name is specified in the EXPL command.
E Extend. An existinf file with this name, or the last file to have been used will be extended. Standard if no file name is specified in the EXPL command.
Notes:
The EXPL command will be executed immediately, in that the list currently displayed will be written to a file. The list can be any list created by a selection process, an Action Code, or a TAS command. This is in contrast to the DOC command or by specifying a file name in the "DOCUMENTATION" field of the Selection mask, where only the current Task list will be saved to the file.
The file created by the EXPL command is particularly appropriate for further processing by spreadsheets (e.g. EXCEL, Lotus) for statistical purposes. This is because there is a 6-byte identification field in each record following the print code, i.e. from Column 2, with the following format:
Byte 2 - 5 sequential list number. The first list written to an EXPL file from the current TAS session will be numbered 0000, the second 0001, and so on. If the ATL mode is active, the list number will be incremented by 1 for each new screen displayed.
Byte 6 Identifier for record type. TAS differentiates between the following record types:
1: Title lines.
2: Data lines.
3: Trailer lines.
Byte 7 Blank.
Byte 8 - 17 Date in the format yymmdd-jul
Byte 18 Blank.
Byte 19 - 24 Time in the format hhmmss
Byte 25 Blank.
Byte 26 - 94 Data content.
NEXPL The EXPL command writes the current list displayed on screen to a file. If ATL mode is activated at some point in time (see page ), every screen displayed will also be written to this file. To reset this mode, the NEXPL or EXPLOFF command can be used.