Debian Codegraph @

upstream/debian-unstable/man1/psc.1

raw
1 .\" $Revision: 7.16 $
2 .TH PSC 1 "19 September 2002" "PSC 7.16_1.1.3 241123 0424"
3 .SH NAME
4 psc \- prepare sc files
5 .SH SYNOPSIS
6 .B psc
7 .RB [ -fLkrSPv ]
8 .RB [ -s
9 .IB cell ]
10 .RB [ -R
11 .IB n ]
12 .RB [ -C
13 .IB n ]
14 .RB [ -n
15 .IB n ]
16 .RB [ -d
17 .IB c ]
18 .\" ==========
19 .SH DESCRIPTION
20 .I Psc
21 is used to prepare data for input to the spreadsheet calculator
22 .I sc(1).
23 It accepts normal ascii data on standard input. Standard output
24 is a
25 .I sc
26 file.
27 With no options,
28 .I psc
29 starts the spreadsheet in cell A0. Strings are right justified.
30 All data on a line is entered on the same row; new input lines
31 cause the output row number to increment by one. The default delimiters
32 are tab and space. The column formats are set to one larger
33 than the number of columns required to hold the largest value
34 in the column.
35 .\" ----------
36 .SH OPTIONS
37 .\" ----------
38 .TP
39 .B \-f
40 Omit column width calculations. This option is for preparing
41 data to be merged with an existing spreadsheet. If the option is not
42 specified, the column widths calculated for the data read by
43 .I psc
44 will override those already set in the existing spreadsheet.
45 .\" ----------
46 .TP
47 .B \-L
48 Left justify strings.
49 .\" ----------
50 .TP
51 .B \-k
52 Keep all delimiters. This option causes the output cell to change on
53 each new delimiter encountered in the input stream. The default
54 action is to condense multiple delimiters to one, so that the cell only
55 changes once per input data item.
56 .\" ----------
57 .TP
58 .B \-r
59 Output the data by row first then column. For input consisting of a single
60 column, this
61 option will result in output of one row with multiple columns
62 instead of a single
63 column spreadsheet.
64 .\" ----------
65 .TP
66 .BI \-s " cell"
67 Start the top left corner of the spreadsheet in
68 .I cell.
69 For example,
70 .I "-s B33"
71 will arrange the output data so that the
72 spreadsheet starts in column B, row 33.
73 .\" ----------
74 .TP
75 .BI \-R " n"
76 Increment by
77 .I n
78 on each new output row.
79 .\" ----------
80 .TP
81 .BI \-C " n"
82 Increment by
83 .I n
84 on each new output column.
85 .\" ----------
86 .TP
87 .BI \-n " n"
88 Output
89 .I n
90 rows before advancing to the next column. This option is used when
91 the input is arranged in a single column and the spreadsheet is to
92 have multiple columns, each of which is to be length
93 .I n.
94 .\" ----------
95 .TP
96 .BI \-d " c"
97 Use the single character
98 .I c
99 as the delimiter between input fields.
100 .\" ----------
101 .TP
102 .B \-P
103 Plain numbers only.
104 A field is a number only when there is no imbedded [-+eE].
105 .\" ----------
106 .TP
107 .B \-S
108 All numbers are strings.
109 .\" ----------
110 .TP
111 .B \-v
112 Print the version of
113 psc
114 .\" ----------
115 .SH SEE ALSO
116 sc(1)
117
118 .SH AUTHOR
119
120 Robert Bond