Column Editing (Reformatting)

To edit (reformat) report columns, enter C (Columns) next to the line selected as the "model" line in the Edit Lines and Columns screen. The Column Editing screen is then displayed.

Figure 123 Control-D Column Editing Screen

-------------------  CONTROL-D - EDIT REPORT COLUMNS  ----------------(U.E.1.C)

COMMAND ===>                                                    LINES 001 - L01

USER PROD    JOB PREMPRS2 RULER EMPVAC    TYPE VIEW

REPPORT EMPLOYEES REPORT

THE ORIGINAL LINE

----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----

EMPLOYEE     EMPLOYEE     OFFICE  ANNUAL  SOCIAL        NO. OF      JOB CLASS

Use the following 5 lines to Cut & Paste, Color and Freeze columns

CUT   :

PASTE :

COLOR :

HILITE:

FREEZE:

THE RESULTING LINE

----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----

EMPLOYEE     EMPLOYEE     OFFICE  ANNUAL  SOCIAL        NO. OF      JOB CLASS

TO SHIFT, PLACE CRSR ON THE DESIRED LINE AND USE PF10-LEFT, PF11-RIGHT 12.38.12

The original line displays the selected model line.

The resulting line displays the model line as reformatted.

Both the original and resulting lines include a column number line for easy reference.

Line editing lines, summarized below, enable you to cut and paste the model line, define colors, and highlight and freeze particular columns:

• Cut columns – cut the report line into sections to be included in the reformatted report.
• Paste – reposition the "cut" sections.
• Color columns – define colors for columns included in the report.
• Hilite columns – define highlights for columns included in the report.
• Freeze columns – define columns to remain in their original positions if the display is shifted left or right.

When reformatting, you can use the LEFT/RIGHT commands to shift display lines.

Defining the Cut

You must mark every column range that you want to reposition in the resulting line. Each column range must start with a letter or a digit (except the letter E). The end of the range is marked by the letter E. Control-V fills each range with the character – to improve visibility.

Note: To move right, use the space bar and not the arrow key.

Defining the Paste

• Column Pasting – To reposition columns, place the letter or digit identifier in any column of the "paste" input line. This causes the columns range to be "moved" to the new position. You may define other characters in the new edited line. Any character in the paste line that is not a cut identifier is treated as a filler string.
• Color – To specify a color for a column, enter the color code in the column on the color line.

  Note: Available only on terminals with seven – color support.

  Table 109 Color Codes for Color Line

  Code	Definition
  R	Red
  G	Green
  B	Blue
  P	Pink
  Y	Yellow
  T	Turquoise
  W	White

• Highlighting – To highlight columns, specify the desired highlight code in the desired columns on the "Hilite" line.

  Note: Available only on terminals with seven – color support.

  Table 110 Highlight Codes for "Hilite" Line

  Code	Definition
  U	Underscore
  R	Reverse video
  B	Blink
  blank	Regular

• Column Freezing – Type the letter F in the Freeze line to freeze any column you would like retained in its original position (even when the display is shifted).
• Seeing the Result – After you have defined the cut, paste, freeze, color and highlight, press Enter and the modified line is displayed in the Resulting line.

Specifying a Line Range

The Line Range fields (on the right side of the COMMAND line) enable you specify a line range for the desired cut and paste. This is especially useful if you want to exclude headers and footers from the cut and paste operation.

Line Range works as follows:

• The defined range specifies line numbers within a report page, not line numbers relative to the whole report. For example, a value of 010 refers to the tenth line on each page, not the tenth line in the report.
• Line number values can be defined either in the format n or Ln. n may be any integer from 00 to 256. Line numbers are counted from the top of the page in format n and from the bottom of the page in format Ln.

  Example: If the top three and bottom two lines are header or footer lines which you do not want formatted, specify a line range of 004 – L03.

Modifying a Line Range

The column editing (formatting) for any line or line range can be modified or redefined. Later specifications for a line (range) supersede earlier ones. However, the original definition is retained for any part of a line range that is not explicitly redefined.

For example, if column editing is specified for the line range 001 – L01 and then respecified for the line range 003 – L02, the original specification is still in effect for lines 001, 002 and L01. To remove the ruler specification for lines 001, 002 and L01, the original specification must be cleared.

Checking the Ruler in the Report

You may check how the ruler works in the report by using the Quick Ruler Definition key (PF04/PF16) which switches between the current ruler definition screen (in this case the Column Editing screen) and the Report Viewing screen. When using this key, the ruler edits are applied to the report in the Report Viewing screen, enabling you to see if the ruler works as you want, or if further revision is necessary, before exiting the ruler.

When you are satisfied with the ruler edits, switch back to the ruler definition screen and exit. For more information see "Exiting the Ruler Definition Environment" later in this chapter.

Example

Perform the following edits in the Column Editing screen:

Figure 124 Column Editing (Reformatting) – Example

-------------------  CONTROL-D - EDIT REPORT COLUMNS  ----------------(U.E.1.C)

COMMAND ===>                                                    LINES 001 - L01

USER PROD    JOB PREMPRS2 RULER EMPVAC    TYPE VIEW

REPORT EMPLOYEES REPORT

THE ORIGINAL LINE

----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----

EMPLOYEE     EMPLOYEE     OFFICE  ANNUAL  SOCIAL        NO. OF      JOB CLASS

Use the following 5 lines to Cut & Paste, Color and Freeze columns

CUT   :

1-------E2---------------E3------E4------E5------------E6----------E7---------

PASTE :

2              | 3      | 4      | 6

COLOR :

HILITE:

FREEZE:

THE RESULTING LINE

----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----

     EMPLOYEE   | OFFICE | ANNUAL | NO. OF

TO SHIFT, PLACE CRSR ON THE DESIRED LINE AND USE PF10-LEFT, PF11-RIGHT 13.01.08

Press the Quick Ruler Definition key (PF04/PF16) to check the results. The Report Viewing screen appears as follows:

Figure 125 Column Editing (Reformatting) – Example Result

----------------- CONTROL-D REPORT VIEWING -------------- PAGE      1 OF      3

COMMAND ===>                                                   SCROLL ===> CRSR

USER PROD    JOB PREMPRS2 09812 DT 080800 RULER EMPVAC    TYPE VIEW

REPORT EMPLOYEES REPORT

---+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----

    EMPLOYEE   | OFFICE | SICK | VAC

      NAME     |   NO.  | DAYS | DAYS

=============== ======== ====== ======

C. POHLHAMMER |   23   |  01  |  07

G. MEREDITH   |   09   |  00  |  01

P. MILLER     |   12   |  00  |  02

K. BOYLE      |   22   |  01  |  07

R. BERLE      |   14   |  01  |  07

--------------------------------------

C. KING       |   12   |  00  |  00

G. BROWNE     |   02   |  00  |  07

R. SOLOMON    |   04   |  01  |  07

S. CUNNINGHAM |   21   |  01  |  07

M. TABER      |   22   |  04  |  07

--------------------------------------

A. WINGER     |   23   |  00  |  07

B. BOOKSPAN   |   05   |  03  |  08

R. MULU       |   29   |  01  |  07

E. SMART      |   02   |  09  |  07

CMDS: FIND str, FIND str PREV, EDIT, RULER on/off/name, N n P n       13.01.14

Press the Quick Ruler Definition key (PF04/PF16) again to return to the ruler.

Exiting the Column Editing Screen

Enter the END command (PF03/PF15). The column definition is kept in memory.

If you do not want to keep the last changes you made in the Column Editing screen, use the CANCEL or RESET command to exit the screen.