Spool files on the AS/400 cannot be transferred directly because they have a special format. Normally people use the CPYSPLF command to copy the spool file to a physical file and then they transfer the physical file.

However there is sometimes the need to import a spool file into spreadsheet applications such as Excel and the simple operations described above are not sufficient because each line is considered as a single cell of the spreadsheet.

The utility UEXPSPLF allows to split lines into separate cells and create a physical file that can be imported into the spreadsheet.

The command prompt the data in the following mask:

The user is required to specify the separator that will be used to identify the end of each column , the spool file and physical file where it should be copied.

When the data are entered, the program copies automatically the spool file to a physical file and then diplays the first page as follows:

The user can then identify the different columns, by entering the separator character at the end of each column, and then press F6 to request the production of the separated output file. This can then be easily transferred to the target machine and used to import the data into a spreadsheet.

You can download the AS/400 Spool File Export Utility from:

==> Utilities Download Page

Be Sociable, Share!

Tagged with:

Filed under: AS400 Spool File Utilities

Like this post? Subscribe to my RSS feed and get loads more!