\n\n\n./report_data_extract.pl --cobol_layout=layout.dat --excel=output.xls\n\nConvert STDIN to Excel spreadsheet\n\nThis program reads mainframe (MF) generated reports, associates each\nline with a specific layout, and converts the data to MS Excel format.\n\nIn order to determine the correct layout, each line of the report\nmust be tagged with a layout id which must also be in the supplied\nCOBOL layout.\n\nThis program does NOT handle REDEFINES or OCCURS in report layouts.\n\nCurrency and Decimal data is 'masked' accordingly.\n\nCell widths are adjusted up to the --max_cell_width.  This\nis for Excel visual only, the data is not truncated.\n\nFiller is used to calculate input field offsets but it is\nnot output by default. This means title fields MUST have a\nreal COBOL field name associated with them.\n\nHeader lines are only output once.  They are determined by the\nfact their tag starts with '!'.\n\nLine break lines (usually dashes or equal signs in the printed report)\nare not output at all. They are determined by the fact their tag\nstarts with a '#'.\n\n\nOptions:\n\n--freeze_head\n\nFreeze pane after the 1st non-repeating\ntransition to a repeating field, assumed\nto be the last header field.\n\n--force_decimal_size=n\n\nForce all decimals to be formatted to this number\nof decimal points.  Used to keep alignment when\ndifferent decimal sizes are used in the same column.\n\n--remove_leading_spaces_from_data\n\nSelf explanatory.\n\n--bypass_carraige_control=Y\n\nMF Report data typically has the 1st column dedicated to carraige\ncontrol information.  This column is not specified in the layout.\nIf you do NOT have this column, you must tell the program not to\nbypass it (the default).\n\n--id_field_name=REPORT-ROW-ID\n\nField in the COBOL layout the tags the layout identifier.\n\n--report_id_position=133\n\nOffset (based 1) in the report data that contains the value to\nmatch against the value in the --id_field_name.  Do not take\ncarraige control byte into account when specifying this offset.\n\n--report_id_len=4\n\nLength of match data.\n\n--max_cell_width=25\n\nMax size for Excel cell. This is for viewable only, data is\nnot truncated.\n\n--bypass_filler_output=Y\n\nSet to 'N' to output filler.  When a differing number of fields\nare used for title VS data lines, we typically bypass filler. This\nis because title lines do not have filler fields in between titles, while\ndata fields do have filler fields.\n\n--output_tag\n\nWill output tag field data.  Default is to bypass it.\nSince the tag field is typically the last field, but not all\nrecords are the same number of fields, the tag data will end\nof in the varying right column of the spreadsheet data.\nTypically used for debugging while adjusting layouts.\n\n--include_header_in_width_calc\n\nMax cell width calculations do not include header fields by\ndefault because non-column headers will skew the test.\n\n\nExample Usage:\ncat ccip.test1.cucpca.det |\\\n./report_data_extract.pl \\\n--cobol_layout=ccip.z6bar.hjhtest4.broom \\\n--excel=output3.xls \\\n--remove_leading_spaces_from_data \\\n--force_decimal_size=3 \\\n--freeze_head\n