LeasePak Utilities

231 Transfer data from GL_HIST scratch files to ASCII files

 

With this utility, users can convert all gl_hist.scr in a specified directory into corresponding gl_hist.rpt ASCII files, either using a fixed-width format or delimited by the pipe (|) symbol. The utility overwrites existing gl_hist.rpt files. Each line of the file contains:

• Portfolio (2 characters)
• Company (2 characters)
• Region (2 characters)
• Office (2 characters)
• Lease (10 characters)
• G/L amounts--an array of 128 amounts, each formatted xxxxxxxxxxxx.xx (15 characters--for fixed-width or pipe-delimited, 0.00 becomes |0|)

The user can specify the location of the original gl_hist.scr files, as well as whether to convert them to fixed-width or delimited ASCII files. The resulting gl_hist.rpt files write to the user's home directory on the LeasePak server.