Download Packed data in display format

Prema Suresh · New User Joined: 12 Jun 2008 Posts: 8 Location: Bangalore

I have a huge file with say 280 columns defined in a copybook without any delimiters.

I wish to change this to a delimited file and also wish to convert the packed fields in it to display format.

UmeySan · Posted: Fri Jun 20, 2008 3:09 pm

Morning Sir !

Plse have a look at Sort-options INREC/OUTREC. Also look at the
Mask-Definitions to convert packed-decimal fields.

karthikr44 · Posted: Fri Jun 20, 2008 3:49 pm

UmeySan · Posted: Fri Jun 20, 2008 4:02 pm

@ karthikr44 !

He said packed to display, so packed to unpacked Chars, i think.
Easiest way is to use a Mask in Sort.

StartingPosition, Length, PD, M1

M1 = Name of one of the 27 pre-defined edit masks.
M1 = TTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTS
-00123 = 00123-

M4 = SII,III,III,III,III,III,III,III,III,IIT.TT
+0123456 = +1,234.56

dick scherrer · Posted: Fri Jun 20, 2008 8:20 pm

Hello,

For a record with many fields, you may be ahead to create a new copybook that has "displayable" fields rather than packed or binary fields. If you use the sort, it will probably become a pain to track all of the field displacements - even if you use symnames.

After moving (corresponding?) the fields from the input format to the displayable format, you could then string the displayable fields and whatever you want for the delimiter into an output and use that for the download and use in your spreadsheet.