datatools/csvrows.1.html at main · caltechlibrary/datatools · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
<!DOCTYPE html>
<html lang="en-US">
<head>
    <title>datatools</title>
    <link rel="stylesheet" href="https://caltechlibrary.github.io/css/site.css">
    <link rel="stylesheet" href="https://media.library.caltech.edu/cl-webcomponents/css/code-blocks.css">
    <script type="module" src="https://media.library.caltech.edu/cl-webcomponents/copyToClipboard.js"></script>
    <script type="module" src="https://media.library.caltech.edu/cl-webcomponents/footer-global.js"></script>
</head>
<body>
<header>
<a href="https://library.caltech.edu"><img src="https://media.library.caltech.edu/assets/caltechlibrary-logo.png" alt="Caltech Library logo"></a>
</header>
<nav>
<ul>
    <li><a href="/">Home</a></li>
    <li><a href="index.html">README</a></li>
    <li><a href="LICENSE">LICENSE</a></li>
    <li><a href="INSTALL.html">INSTALL</a></li>
    <li><a href="user_manual.html">User Manual</a></li>
    <li><a href="about.html">About</a></li>
    <li><a href="search.html">Search</a></li>
    <li><a href="https://github.com/caltechlibrary/datatools">GitHub</a></li>
</ul>
</nav>
<section>
<h1 id="name">NAME</h1>
<p>csvrows</p>
<h1 id="synopsis">SYNOPSIS</h1>
<p>csvrows <a href="#options">OPTIONS</a> [ARGS_AS_ROW_VALUES]</p>
<h1 id="description">DESCRIPTION</h1>
<p>csvrows converts a set of command line args into rows of CSV formated
output. It can also be used to filter or list specific rows of CSV input
The first row is 1 not 0. Often row 1 is the header row and csvrows
makes it easy to output only the data rows.</p>
<h1 id="options">OPTIONS</h1>
<dl>
<dt>-help</dt>
<dd>
display help
</dd>
<dt>-license</dt>
<dd>
display license
</dd>
<dt>-version</dt>
<dd>
display version
</dd>
<dt>-d, -delimiter</dt>
<dd>
set delimiter character
</dd>
<dt>-header</dt>
<dd>
display the header row (alias for ‘-rows 1’)
</dd>
<dt>-i, -input</dt>
<dd>
input filename
</dd>
<dt>-o, -output</dt>
<dd>
output filename
</dd>
<dt>-quiet</dt>
<dd>
suppress error messages
</dd>
<dt>-random</dt>
<dd>
return N randomly selected rows
</dd>
<dt>-row, -rows</dt>
<dd>
output specified rows in order (e.g. -row 1,5,2-4))
</dd>
<dt>-skip-header-row</dt>
<dd>
skip the header row (alias for -row 2-
</dd>
<dt>-trim-leading-space</dt>
<dd>
trim leading space in field(s) for CSV input
</dd>
<dt>-use-lazy-quotes</dt>
<dd>
use lazy quotes for CSV input
</dd>
<dt>-crlf</dt>
<dd>
use a CRLF for end of line (EOL) on write, defaults to true on Windows
</dd>
</dl>
<h1 id="examples">EXAMPLES</h1>
<p>Simple usage of building a CSV file one rows at a time.</p>
<pre><code>    csvrows &quot;First,Second,Third&quot; &quot;one,two,three&quot; &gt; 4rows.csv
    csvrows &quot;ein,zwei,drei&quot; &quot;1,2,3&quot; &gt;&gt; 4rows.csv
    cat 4row.csv</code></pre>
<p>Example parsing a pipe delimited string into a CSV line</p>
<pre><code>    csvrows -d &quot;|&quot; &quot;First,Second,Third|one,two,three&quot; &gt; 4rows.csv
    csvrows -delimiter &quot;|&quot; &quot;ein,zwei,drei|1,2,3&quot; &gt;&gt; 4rows.csv
    cat 4rows.csv</code></pre>
<p>Filter a 10 row CSV file for rows 1,4,6 (top most row is one)</p>
<pre><code>    cat 10row.csv | csvrows -row 1,4,6 &gt; 3rows.csv</code></pre>
<p>Filter a 10 row CSV file for rows 1,4,6 from file named
“10row.csv”</p>
<pre><code>    csvrows -i 10row.csv -row 1,4,6 &gt; 3rows.csv</code></pre>
<p>Filter 3 randomly selected rows from 10row.csv rendering new CSV with
a header row from 10row.csv.</p>
<pre><code>    csvrows -i 10row.csv -header=true -random=3</code></pre>
<p>csvrows 1.3.5</p>
</section>
<footer-global></footer-global>
</body>
</html>