View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
JEB JEB is offline
external usenet poster
 
Posts: 40
Default Text Data Fields mixed with binary (Comp) and packed (Comp-3) data

I have a 2046 byte record that I download from the mainframe to a ".txt"
file. The low order 1500 bytes of this file is purely text data. The first
746 bytes, however, contain a mixture of text, binary and packed data files
(Comp and Comp-3) fields. It appears that irregardless of the contents of
these files, the record length is shortened by the compression of this data
in the download process. Is there any way that I can download this file,
compensating for the loss of the compressed fields (don't need them anyway),
so I can parse and load the true text fields into an Excel Spreadsheet?

Thanking you all in advance...
--
John