README
1Here are some applications for handling and manipulating CSV files in
2various ways. Provided are:
3=======================================================================
4
5csv2html ?-sep sepchar? ?-title string? file...
6
7 Reads CSV data from the files and returns it as a HTML table
8 on stdout.
9
10=======================================================================
11
12csvsort ?-sep sepchar? ?-f? ?-n? ?-r? ?-skip cnt? column file.in|- file.out|-
13
14 Like "sort", but for CSV files. Sorts after the specified
15 column. Input and output are from and to a file or stdin
16 and stdout (Any combination is possible).
17
18 Options:
19
20 -sep specifies the separator character used in the input file.
21 Default is comma.
22
23 -n If specified integer sorting is used.
24 -f If specified floating point sorting is used.
25 (-n and -f exclude each other. If both are used the
26 last option decides the mode).
27
28 -r If specified reverse sorting is used (largest first)
29
30 -skip If specified that number of rows is skipped at the beginning,
31 i.e. excluded from sorting. This is to allow sorting of
32 CSV files with header lines.
33
34=======================================================================
35
36csvcut ?-sep sepchar? LIST file...
37
38 Like "cut", but for CSV files. Print selected parts of CSV
39 records from each FILE to standard output.
40
41 LIST is a comma separated list of column specifications. The
42 allowed forms are:
43
44 N numeric specification of single column
45 N-M range specification, both parts numberic,
46 N < M required.
47 -M See N-M, N defaults to 0.
48 N- See N-M, M defaults to last column
49
50 If there are no files or file = "-" read from stdin.
51
52=======================================================================
53
54csvuniq ?-sep sepchar? column file.in|- file.out|-
55
56 Like "uniq", but for CSV files. Uniq's the specified column.
57 Writes the first record it encounters for a value. Input and
58 output are from and to a file or stdin and stdout (Any
59 combination is possible).
60
61 Options:
62
63 -sep specifies the separator character used in the input file.
64 Default is comma.
65
66=======================================================================
67
68csvjoin ?-sep sepchar? ?-outer? keycol1 file1.in keycol2 file2.in file.out|-
69
70 Joins the two CSV inputtables using the specified columns as
71 keys to compare and associate. The result will contain all
72 columns from both files with the exception of the second key
73 column (the result needs only one key column, the other is
74 identical by definition and therefore superfluous).
75
76 Options:
77
78 -sep specifies the separator character used in the input file.
79 Default is comma.
80
81 -outer Flag, perform outer join. Means that if the key is
82 missing in file2 a record is nevertheless written,
83 extended with empty values.
84
85=======================================================================
86