1PSC(1)                      General Commands Manual                     PSC(1)
2
3
4

NAME

6       psc - prepare sc files
7

SYNOPSIS

9       psc [-fLkrSPv] [-s cell] [-R n] [-C n] [-n n] [-d c]
10

DESCRIPTION

12       Psc  is  used  to  prepare data for input to the spreadsheet calculator
13       sc(1).  It accepts normal ascii data on standard input.  Standard  out‐
14       put  is a sc file.  With no options, psc starts the spreadsheet in cell
15       A0.  Strings are right justified.  All data on a line is entered on the
16       same  row;  new input lines cause the output row number to increment by
17       one.  The default delimiters are tab and space.  The column formats are
18       set  to  one  larger  than  the  number of columns required to hold the
19       largest value in the column.
20

OPTIONS

22       -f     Omit column width calculations.  This option  is  for  preparing
23              data  to  be merged with an existing spreadsheet.  If the option
24              is not specified, the column widths calculated for the data read
25              by  psc  will override those already set in the existing spread‐
26              sheet.
27
28       -L     Left justify strings.
29
30       -k     Keep all delimiters.  This option  causes  the  output  cell  to
31              change  on  each  new delimiter encountered in the input stream.
32              The default action is to condense multiple delimiters to one, so
33              that the cell only changes once per input data item.
34
35       -r     Output  the data by row first then column.  For input consisting
36              of a single column, this option will result in output of one row
37              with multiple columns instead of a single column spreadsheet.
38
39       -s cell
40              Start the top left corner of the spreadsheet in cell.  For exam‐
41              ple, -s B33 will arrange the output data so that the spreadsheet
42              starts in column B, row 33.
43
44       -R n   Increment by n on each new output row.
45
46       -C n   Increment by n on each new output column.
47
48       -n n   Output  n rows before advancing to the next column.  This option
49              is used when the input is arranged in a single  column  and  the
50              spreadsheet  is to have multiple columns, each of which is to be
51              length n.
52
53       -d c   Use the single  character  c  as  the  delimiter  between  input
54              fields.
55
56       -P     Plain  numbers  only.  A field is a number only when there is no
57              imbedded [-+eE].
58
59       -S     All numbers are strings.
60
61       -v     Print the version of psc
62

SEE ALSO

64       sc(1)
65
66

AUTHOR

68       Robert Bond
69
70
71
72PSC 7.16                       19 September 2002                        PSC(1)