Mercurial > repos > deepakjadmin > mayatool3_test3

comparison mayachemtools/docs/scripts/html/code/ExtractFromTextFiles.html @ 0:73ae111cf86f draft

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Uploaded
author deepakjadmin
date Wed, 20 Jan 2016 11:55:01 -0500
parents
children
comparison
equal deleted inserted replaced
-1:000000000000 0:73ae111cf86f
1 <html>
2 <head>
3 <title>MayaChemTools:Code:ExtractFromTextFiles.pl</title>
4 <meta http-equiv="content-type" content="text/html;charset=utf-8">
5 <link rel="stylesheet" type="text/css" href="../../../css/MayaChemToolsCode.css">
6 </head>
7 <body leftmargin="20" rightmargin="20" topmargin="10" bottommargin="10">
8 <br/>
9 <center>
10 <a href="http://www.mayachemtools.org" title="MayaChemTools Home"><img src="../../../images/MayaChemToolsLogo.gif" border="0" alt="MayaChemTools"></a>
11 </center>
12 <br/>
13 <pre>
14 1 #!/usr/bin/perl -w
15 2 <span class="c">#</span>
16 3 <span class="c"># $RCSfile: ExtractFromTextFiles.pl,v $</span>
17 4 <span class="c"># $Date: 2015/02/28 20:46:19 $</span>
18 5 <span class="c"># $Revision: 1.42 $</span>
19 6 <span class="c">#</span>
20 7 <span class="c"># Author: Manish Sud &lt;msud@san.rr.com&gt;</span>
21 8 <span class="c">#</span>
22 9 <span class="c"># Copyright (C) 2015 Manish Sud. All rights reserved.</span>
23 10 <span class="c">#</span>
24 11 <span class="c"># This file is part of MayaChemTools.</span>
25 12 <span class="c">#</span>
26 13 <span class="c"># MayaChemTools is free software; you can redistribute it and/or modify it under</span>
27 14 <span class="c"># the terms of the GNU Lesser General Public License as published by the Free</span>
28 15 <span class="c"># Software Foundation; either version 3 of the License, or (at your option) any</span>
29 16 <span class="c"># later version.</span>
30 17 <span class="c">#</span>
31 18 <span class="c"># MayaChemTools is distributed in the hope that it will be useful, but without</span>
32 19 <span class="c"># any warranty; without even the implied warranty of merchantability of fitness</span>
33 20 <span class="c"># for a particular purpose. See the GNU Lesser General Public License for more</span>
34 21 <span class="c"># details.</span>
35 22 <span class="c">#</span>
36 23 <span class="c"># You should have received a copy of the GNU Lesser General Public License</span>
37 24 <span class="c"># along with MayaChemTools; if not, see &lt;http://www.gnu.org/licenses/&gt; or</span>
38 25 <span class="c"># write to the Free Software Foundation Inc., 59 Temple Place, Suite 330,</span>
39 26 <span class="c"># Boston, MA, 02111-1307, USA.</span>
40 27 <span class="c">#</span>
41 28
42 29 <span class="k">use</span> <span class="w">strict</span><span class="sc">;</span>
43 30 <span class="k">use</span> <span class="w">FindBin</span><span class="sc">;</span> <span class="k">use</span> <span class="w">lib</span> <span class="q">&quot;$FindBin::Bin/../lib&quot;</span><span class="sc">;</span>
44 31 <span class="k">use</span> <span class="w">Getopt::Long</span><span class="sc">;</span>
45 32 <span class="k">use</span> <span class="w">File::Basename</span><span class="sc">;</span>
46 33 <span class="k">use</span> <span class="w">Text::ParseWords</span><span class="sc">;</span>
47 34 <span class="k">use</span> <span class="w">FileHandle</span><span class="sc">;</span>
48 35 <span class="k">use</span> <span class="w">Benchmark</span><span class="sc">;</span>
49 36 <span class="k">use</span> <span class="w">FileUtil</span><span class="sc">;</span>
50 37 <span class="k">use</span> <span class="w">TextUtil</span><span class="sc">;</span>
51 38
52 39 <span class="k">my</span><span class="s">(</span><span class="i">$ScriptName</span><span class="cm">,</span> <span class="i">%Options</span><span class="cm">,</span> <span class="i">$StartTime</span><span class="cm">,</span> <span class="i">$EndTime</span><span class="cm">,</span> <span class="i">$TotalTime</span><span class="s">)</span><span class="sc">;</span>
53 40
54 41 <span class="c"># Autoflush STDOUT</span>
55 42 <span class="i">$|</span> = <span class="n">1</span><span class="sc">;</span>
56 43
57 44 <span class="i">$StartTime</span> = <span class="w">new</span> <span class="w">Benchmark</span><span class="sc">;</span>
58 45
59 46 <span class="c"># Starting message...</span>
60 47 <span class="i">$ScriptName</span> = <span class="w">basename</span> <span class="i">$0</span><span class="sc">;</span>
61 48 <span class="k">print</span> <span class="q">&quot;\n$ScriptName:Starting...\n\n&quot;</span><span class="sc">;</span>
62 49
63 50 <span class="c"># Get the options and setup script...</span>
64 51 <span class="i">SetupScriptUsage</span><span class="s">(</span><span class="s">)</span><span class="sc">;</span>
65 52 <span class="k">if</span> <span class="s">(</span><span class="i">$Options</span>{<span class="w">help</span>} || <span class="i">@ARGV</span> &lt; <span class="n">1</span><span class="s">)</span> <span class="s">{</span>
66 53 <span class="k">die</span> <span class="i">GetUsageFromPod</span><span class="s">(</span><span class="q">&quot;$FindBin::Bin/$ScriptName&quot;</span><span class="s">)</span><span class="sc">;</span>
67 54 <span class="s">}</span>
68 55
69 56 <span class="k">my</span><span class="s">(</span><span class="i">@TextFilesList</span><span class="s">)</span><span class="sc">;</span>
70 57 <span class="i">@TextFilesList</span> = <span class="i">ExpandFileNames</span><span class="s">(</span>\<span class="i">@ARGV</span><span class="cm">,</span> <span class="q">&quot;csv tsv&quot;</span><span class="s">)</span><span class="sc">;</span>
71 58
72 59 <span class="c"># Process options...</span>
73 60 <span class="k">print</span> <span class="q">&quot;Processing options...\n&quot;</span><span class="sc">;</span>
74 61 <span class="k">my</span><span class="s">(</span><span class="i">%OptionsInfo</span><span class="s">)</span><span class="sc">;</span>
75 62 <span class="i">ProcessOptions</span><span class="s">(</span><span class="s">)</span><span class="sc">;</span>
76 63
77 64 <span class="c"># Collect column information for all the text files...</span>
78 65 <span class="k">print</span> <span class="q">&quot;Checking input text file(s)...\n&quot;</span><span class="sc">;</span>
79 66 <span class="k">my</span><span class="s">(</span><span class="i">%TextFilesInfo</span><span class="s">)</span><span class="sc">;</span>
80 67 <span class="i">RetrieveTextFilesInfo</span><span class="s">(</span><span class="s">)</span><span class="sc">;</span>
81 68 <span class="i">RetrieveColumnsAndRowsInfo</span><span class="s">(</span><span class="s">)</span><span class="sc">;</span>
82 69
83 70 <span class="c"># Generate output files...</span>
84 71 <span class="k">my</span><span class="s">(</span><span class="i">$FileIndex</span><span class="s">)</span><span class="sc">;</span>
85 72 <span class="k">if</span> <span class="s">(</span><span class="i">@TextFilesList</span> &gt; <span class="n">1</span><span class="s">)</span> <span class="s">{</span>
86 73 <span class="k">print</span> <span class="q">&quot;\nProcessing text files...\n&quot;</span><span class="sc">;</span>
87 74 <span class="s">}</span>
88 75 <span class="k">for</span> <span class="i">$FileIndex</span> <span class="s">(</span><span class="n">0</span> .. <span class="i">$#TextFilesList</span><span class="s">)</span> <span class="s">{</span>
89 76 <span class="k">if</span> <span class="s">(</span><span class="i">$TextFilesInfo</span>{<span class="w">FileOkay</span>}[<span class="i">$FileIndex</span>]<span class="s">)</span> <span class="s">{</span>
90 77 <span class="k">print</span> <span class="q">&quot;\nProcessing file $TextFilesList[$FileIndex]...\n&quot;</span><span class="sc">;</span>
91 78 <span class="i">ExtractFromTextFile</span><span class="s">(</span><span class="i">$FileIndex</span><span class="s">)</span><span class="sc">;</span>
92 79 <span class="s">}</span>
93 80 <span class="s">}</span>
94 81 <span class="k">print</span> <span class="q">&quot;\n$ScriptName:Done...\n\n&quot;</span><span class="sc">;</span>
95 82
96 83 <span class="i">$EndTime</span> = <span class="w">new</span> <span class="w">Benchmark</span><span class="sc">;</span>
97 84 <span class="i">$TotalTime</span> = <span class="w">timediff</span> <span class="s">(</span><span class="i">$EndTime</span><span class="cm">,</span> <span class="i">$StartTime</span><span class="s">)</span><span class="sc">;</span>
98 85 <span class="k">print</span> <span class="q">&quot;Total time: &quot;</span><span class="cm">,</span> <span class="i">timestr</span><span class="s">(</span><span class="i">$TotalTime</span><span class="s">)</span><span class="cm">,</span> <span class="q">&quot;\n&quot;</span><span class="sc">;</span>
99 86
100 87 <span class="c">###############################################################################</span>
101 88
102 89 <span class="c"># Extract appropriate data from text file...</span>
103 <a name="ExtractFromTextFile-"></a> 90 <span class="k">sub </span><span class="m">ExtractFromTextFile</span> <span class="s">{</span>
104 91 <span class="k">my</span><span class="s">(</span><span class="i">$Index</span><span class="s">)</span> = <span class="i">@_</span><span class="sc">;</span>
105 92
106 93 <span class="k">if</span> <span class="s">(</span><span class="i">$OptionsInfo</span>{<span class="w">Mode</span>} =~ <span class="q">/^categories$/i</span><span class="s">)</span> <span class="s">{</span>
107 94 <span class="i">ExtractCategoryData</span><span class="s">(</span><span class="i">$Index</span><span class="s">)</span><span class="sc">;</span>
108 95 <span class="s">}</span>
109 96 <span class="k">elsif</span> <span class="s">(</span><span class="i">$OptionsInfo</span>{<span class="w">Mode</span>} =~ <span class="q">/^rows$/i</span><span class="s">)</span><span class="s">{</span>
110 97 <span class="i">ExtractRowsData</span><span class="s">(</span><span class="i">$Index</span><span class="s">)</span><span class="sc">;</span>
111 98 <span class="s">}</span>
112 99 <span class="k">else</span> <span class="s">{</span>
113 100 <span class="i">ExtractColumnData</span><span class="s">(</span><span class="i">$Index</span><span class="s">)</span><span class="sc">;</span>
114 101 <span class="s">}</span>
115 102 <span class="s">}</span>
116 103
117 104 <span class="c"># Geneate category files...</span>
118 <a name="ExtractCategoryData-"></a> 105 <span class="k">sub </span><span class="m">ExtractCategoryData</span> <span class="s">{</span>
119 106 <span class="k">my</span><span class="s">(</span><span class="i">$Index</span><span class="s">)</span> = <span class="i">@_</span><span class="sc">;</span>
120 107 <span class="k">my</span><span class="s">(</span><span class="i">$TextFile</span><span class="cm">,</span> <span class="i">$CategoryCol</span><span class="cm">,</span> <span class="i">$NewTextFile</span><span class="cm">,</span> <span class="i">$InDelim</span><span class="cm">,</span> <span class="i">@ColLabels</span><span class="s">)</span><span class="sc">;</span>
121 108
122 109 <span class="i">$TextFile</span> = <span class="i">$TextFilesList</span>[<span class="i">$Index</span>]<span class="sc">;</span>
123 110
124 111 <span class="i">$NewTextFile</span> = <span class="i">$TextFilesInfo</span>{<span class="w">OutFile</span>}[<span class="i">$Index</span>]<span class="sc">;</span>
125 112 <span class="i">$CategoryCol</span> = <span class="i">$TextFilesInfo</span>{<span class="w">CategoryColNum</span>}[<span class="i">$Index</span>]<span class="sc">;</span>
126 113 <span class="i">$InDelim</span> = <span class="i">$TextFilesInfo</span>{<span class="w">InDelim</span>}[<span class="i">$Index</span>]<span class="sc">;</span>
127 114 <span class="i">@ColLabels</span> = <span class="i">@</span>{<span class="i">$TextFilesInfo</span>{<span class="w">ColLabels</span>}[<span class="i">$Index</span>]}<span class="sc">;</span>
128 115
129 116 <span class="k">my</span><span class="s">(</span><span class="i">$Line</span><span class="cm">,</span> <span class="i">@LineWords</span><span class="cm">,</span> <span class="i">$CategoryName</span><span class="cm">,</span> <span class="i">$CategoryCount</span><span class="cm">,</span> <span class="i">%CategoriesNameToCountMap</span><span class="cm">,</span> <span class="i">%CategoriesNameToLinesMap</span><span class="s">)</span><span class="sc">;</span>
130 117 <span class="c"># Collect category data...</span>
131 118 <span class="k">open</span> <span class="w">TEXTFILE</span><span class="cm">,</span> <span class="q">&quot;$TextFile&quot;</span> <span class="k">or</span> <span class="k">die</span> <span class="q">&quot;Couldn&#39;t open $TextFile: $! \n&quot;</span><span class="sc">;</span>
132 119 <span class="c"># Skip label line...</span>
133 120 <span class="i">$_</span> = <span class="q">&lt;TEXTFILE&gt;</span><span class="sc">;</span>
134 121
135 122 <span class="i">%CategoriesNameToCountMap</span> = <span class="s">(</span><span class="s">)</span><span class="sc">;</span>
136 123 <span class="i">%CategoriesNameToLinesMap</span> = <span class="s">(</span><span class="s">)</span><span class="sc">;</span>
137 124
138 125 <span class="k">while</span> <span class="s">(</span><span class="i">$Line</span> = <span class="i">GetTextLine</span><span class="s">(</span>\<span class="i">*TEXTFILE</span><span class="s">)</span><span class="s">)</span> <span class="s">{</span>
139 126 <span class="i">@LineWords</span> = <span class="i">quotewords</span><span class="s">(</span><span class="i">$InDelim</span><span class="cm">,</span> <span class="n">0</span><span class="cm">,</span> <span class="i">$Line</span><span class="s">)</span><span class="sc">;</span>
140 127 <span class="i">$CategoryName</span> = <span class="s">(</span><span class="i">$CategoryCol</span> &lt;= <span class="i">@LineWords</span><span class="s">)</span> ? <span class="i">$LineWords</span>[<span class="i">$CategoryCol</span>] <span class="co">:</span> <span class="q">&quot;&quot;</span><span class="sc">;</span>
141 128 <span class="k">if</span> <span class="s">(</span><span class="k">exists</span><span class="s">(</span><span class="i">$CategoriesNameToCountMap</span>{<span class="i">$CategoryName</span>}<span class="s">)</span><span class="s">)</span> <span class="s">{</span>
142 129 <span class="i">$CategoriesNameToCountMap</span>{<span class="i">$CategoryName</span>} += <span class="n">1</span><span class="sc">;</span>
143 130 <span class="k">push</span> <span class="i">@</span>{<span class="i">$CategoriesNameToLinesMap</span>{<span class="i">$CategoryName</span>}}<span class="cm">,</span> <span class="i">$Line</span><span class="sc">;</span>
144 131 <span class="s">}</span>
145 132 <span class="k">else</span> <span class="s">{</span>
146 133 <span class="i">$CategoriesNameToCountMap</span>{<span class="i">$CategoryName</span>} = <span class="n">1</span><span class="sc">;</span>
147 134 <span class="i">@</span>{<span class="i">$CategoriesNameToLinesMap</span>{<span class="i">$CategoryName</span>}} = <span class="s">(</span><span class="s">)</span><span class="sc">;</span>
148 135 <span class="k">push</span> <span class="i">@</span>{<span class="i">$CategoriesNameToLinesMap</span>{<span class="i">$CategoryName</span>}}<span class="cm">,</span> <span class="i">$Line</span><span class="sc">;</span>
149 136 <span class="s">}</span>
150 137 <span class="s">}</span>
151 138 <span class="k">close</span> <span class="w">TEXTFILE</span><span class="sc">;</span>
152 139
153 140 <span class="c"># Setup file names for individual category files...</span>
154 141 <span class="k">my</span><span class="s">(</span><span class="i">%CategoriesNameToFileHandleMap</span><span class="cm">,</span> <span class="i">%CategoriesNameToFileNameMap</span><span class="cm">,</span> <span class="i">$CategoryFile</span><span class="cm">,</span> <span class="i">$CategoryFileHandle</span><span class="s">)</span><span class="sc">;</span>
155 142
156 143 <span class="i">%CategoriesNameToFileHandleMap</span> = <span class="s">(</span><span class="s">)</span><span class="sc">;</span>
157 144 <span class="i">%CategoriesNameToFileNameMap</span> = <span class="s">(</span><span class="s">)</span><span class="sc">;</span>
158 145
159 146 <span class="k">for</span> <span class="i">$CategoryName</span> <span class="s">(</span><span class="k">keys</span> <span class="i">%CategoriesNameToCountMap</span><span class="s">)</span> <span class="s">{</span>
160 147 <span class="i">$CategoryFile</span> = <span class="i">$TextFilesInfo</span>{<span class="w">CategoryOutFileRoot</span>}[<span class="i">$Index</span>] . <span class="q">&quot;$CategoryName&quot;</span> . <span class="q">&quot;.$TextFilesInfo{OutFileExt}[$Index]&quot;</span><span class="sc">;</span><span class="sc">;</span>
161 148 <span class="i">$CategoryFile</span> =~ <span class="q">s/ //g</span><span class="sc">;</span>
162 149 <span class="i">$CategoryFileHandle</span> = <span class="w">new</span> <span class="w">FileHandle</span><span class="sc">;</span>
163 150 <span class="k">open</span> <span class="i">$CategoryFileHandle</span><span class="cm">,</span> <span class="q">&quot;&gt;$CategoryFile&quot;</span> <span class="k">or</span> <span class="k">die</span> <span class="q">&quot;Couldn&#39;t open $CategoryFile: $! \n&quot;</span><span class="sc">;</span>
164 151 <span class="i">$CategoriesNameToFileNameMap</span>{<span class="i">$CategoryName</span>} = <span class="i">$CategoryFile</span><span class="sc">;</span>
165 152 <span class="i">$CategoriesNameToFileHandleMap</span>{<span class="i">$CategoryName</span>} = <span class="i">$CategoryFileHandle</span><span class="sc">;</span>
166 153 <span class="s">}</span>
167 154
168 155 <span class="c"># Write out summary file...</span>
169 156 <span class="k">print</span> <span class="q">&quot;Generating file $NewTextFile...\n&quot;</span><span class="sc">;</span>
170 157 <span class="k">open</span> <span class="w">NEWTEXTFILE</span><span class="cm">,</span> <span class="q">&quot;&gt;$NewTextFile&quot;</span> <span class="k">or</span> <span class="k">die</span> <span class="q">&quot;Couldn&#39;t open $NewTextFile: $! \n&quot;</span><span class="sc">;</span>
171 158
172 159 <span class="c"># Write out column labels...</span>
173 160 <span class="i">@LineWords</span> = <span class="s">(</span><span class="q">&quot;Category&quot;</span><span class="cm">,</span><span class="q">&quot;Count&quot;</span><span class="s">)</span><span class="sc">;</span>
174 161 <span class="i">$Line</span> = <span class="i">JoinWords</span><span class="s">(</span>\<span class="i">@LineWords</span><span class="cm">,</span> <span class="i">$OptionsInfo</span>{<span class="w">OutDelim</span>}<span class="cm">,</span> <span class="i">$OptionsInfo</span>{<span class="w">OutQuote</span>}<span class="s">)</span><span class="sc">;</span>
175 162 <span class="k">print</span> <span class="i">NEWTEXTFILE</span> <span class="q">&quot;$Line\n&quot;</span><span class="sc">;</span>
176 163
177 164 <span class="c"># Write out the category names and count...</span>
178 165 <span class="k">for</span> <span class="i">$CategoryName</span> <span class="s">(</span><span class="k">sort</span> <span class="s">{</span> <span class="k">lc</span><span class="s">(</span><span class="i">$a</span><span class="s">)</span> <span class="k">cmp</span> <span class="k">lc</span><span class="s">(</span><span class="i">$b</span><span class="s">)</span> <span class="s">}</span> <span class="k">keys</span> <span class="i">%CategoriesNameToCountMap</span><span class="s">)</span> <span class="s">{</span>
179 166 <span class="i">$CategoryCount</span> = <span class="i">$CategoriesNameToCountMap</span>{<span class="i">$CategoryName</span>}<span class="sc">;</span>
180 167 <span class="i">@LineWords</span> = <span class="s">(</span><span class="q">&quot;$CategoryName&quot;</span><span class="cm">,</span><span class="q">&quot;$CategoryCount&quot;</span><span class="s">)</span><span class="sc">;</span>
181 168 <span class="i">$Line</span> = <span class="i">JoinWords</span><span class="s">(</span>\<span class="i">@LineWords</span><span class="cm">,</span> <span class="i">$OptionsInfo</span>{<span class="w">OutDelim</span>}<span class="cm">,</span> <span class="i">$OptionsInfo</span>{<span class="w">OutQuote</span>}<span class="s">)</span><span class="sc">;</span>
182 169 <span class="k">print</span> <span class="i">NEWTEXTFILE</span> <span class="q">&quot;$Line\n&quot;</span><span class="sc">;</span>
183 170 <span class="s">}</span>
184 171 <span class="k">close</span> <span class="w">NEWTEXTFILE</span><span class="sc">;</span>
185 172
186 173 <span class="c"># Write out a file for each category...</span>
187 174 <span class="k">my</span><span class="s">(</span><span class="i">$ColLabelLine</span><span class="cm">,</span> <span class="i">$LineIndex</span><span class="s">)</span><span class="sc">;</span>
188 175
189 176 <span class="i">$ColLabelLine</span> = <span class="i">JoinWords</span><span class="s">(</span>\<span class="i">@ColLabels</span><span class="cm">,</span> <span class="i">$OptionsInfo</span>{<span class="w">OutDelim</span>}<span class="cm">,</span> <span class="i">$OptionsInfo</span>{<span class="w">OutQuote</span>}<span class="s">)</span><span class="sc">;</span>
190 177 <span class="k">print</span> <span class="q">&quot;\nGenerating text files for each category...\n&quot;</span><span class="sc">;</span>
191 178
192 179 <span class="k">for</span> <span class="i">$CategoryName</span> <span class="s">(</span><span class="k">sort</span> <span class="s">{</span> <span class="k">lc</span><span class="s">(</span><span class="i">$a</span><span class="s">)</span> <span class="k">cmp</span> <span class="k">lc</span><span class="s">(</span><span class="i">$b</span><span class="s">)</span> <span class="s">}</span> <span class="k">keys</span> <span class="i">%CategoriesNameToCountMap</span><span class="s">)</span> <span class="s">{</span>
193 180 <span class="k">print</span> <span class="q">&quot;Generating file $CategoriesNameToFileNameMap{$CategoryName}...\n&quot;</span><span class="sc">;</span>
194 181 <span class="i">$CategoryFileHandle</span> = <span class="i">$CategoriesNameToFileHandleMap</span>{<span class="i">$CategoryName</span>}<span class="sc">;</span>
195 182 <span class="k">print</span> <span class="i">$CategoryFileHandle</span> <span class="q">&quot;$ColLabelLine\n&quot;</span><span class="sc">;</span>
196 183 <span class="k">for</span> <span class="i">$LineIndex</span> <span class="s">(</span><span class="n">0</span> .. <span class="i">$#</span>{<span class="i">$CategoriesNameToLinesMap</span>{<span class="i">$CategoryName</span>}}<span class="s">)</span> <span class="s">{</span>
197 184 <span class="i">$Line</span> = <span class="i">$</span>{<span class="i">$CategoriesNameToLinesMap</span>{<span class="i">$CategoryName</span>}}[<span class="i">$LineIndex</span>]<span class="sc">;</span>
198 185 <span class="i">@LineWords</span> = <span class="i">quotewords</span><span class="s">(</span><span class="i">$InDelim</span><span class="cm">,</span> <span class="n">0</span><span class="cm">,</span> <span class="i">$Line</span><span class="s">)</span><span class="sc">;</span>
199 186 <span class="i">$Line</span> = <span class="i">JoinWords</span><span class="s">(</span>\<span class="i">@LineWords</span><span class="cm">,</span> <span class="i">$OptionsInfo</span>{<span class="w">OutDelim</span>}<span class="cm">,</span> <span class="i">$OptionsInfo</span>{<span class="w">OutQuote</span>}<span class="s">)</span><span class="sc">;</span>
200 187 <span class="k">print</span> <span class="i">$CategoryFileHandle</span> <span class="q">&quot;$Line\n&quot;</span><span class="sc">;</span>
201 188 <span class="s">}</span>
202 189 <span class="k">close</span> <span class="i">$CategoryFileHandle</span><span class="sc">;</span>
203 190 <span class="s">}</span>
204 191 <span class="s">}</span>
205 192
206 193 <span class="c"># Extract data for specific columns...</span>
207 <a name="ExtractColumnData-"></a> 194 <span class="k">sub </span><span class="m">ExtractColumnData</span> <span class="s">{</span>
208 195 <span class="k">my</span><span class="s">(</span><span class="i">$Index</span><span class="s">)</span> = <span class="i">@_</span><span class="sc">;</span>
209 196 <span class="k">my</span><span class="s">(</span><span class="i">$TextFile</span><span class="cm">,</span> <span class="i">@ColNumsToExtract</span><span class="cm">,</span> <span class="i">$NewTextFile</span><span class="cm">,</span> <span class="i">$InDelim</span><span class="s">)</span><span class="sc">;</span>
210 197
211 198 <span class="i">$TextFile</span> = <span class="i">$TextFilesList</span>[<span class="i">$Index</span>]<span class="sc">;</span>
212 199 <span class="i">$NewTextFile</span> =<span class="i">$TextFilesInfo</span>{<span class="w">OutFile</span>}[<span class="i">$Index</span>]<span class="sc">;</span>
213 200 <span class="i">$InDelim</span> = <span class="i">$TextFilesInfo</span>{<span class="w">InDelim</span>}[<span class="i">$Index</span>]<span class="sc">;</span>
214 201 <span class="i">@ColNumsToExtract</span> = <span class="i">@</span>{<span class="i">$TextFilesInfo</span>{<span class="w">ColNumsToExtract</span>}[<span class="i">$Index</span>]}<span class="sc">;</span>
215 202
216 203 <span class="k">print</span> <span class="q">&quot;Generating file $NewTextFile...\n&quot;</span><span class="sc">;</span>
217 204 <span class="k">open</span> <span class="w">TEXTFILE</span><span class="cm">,</span> <span class="q">&quot;$TextFile&quot;</span> <span class="k">or</span> <span class="k">die</span> <span class="q">&quot;Couldn&#39;t open $TextFile: $! \n&quot;</span><span class="sc">;</span>
218 205 <span class="k">open</span> <span class="w">NEWTEXTFILE</span><span class="cm">,</span> <span class="q">&quot;&gt;$NewTextFile&quot;</span> <span class="k">or</span> <span class="k">die</span> <span class="q">&quot;Couldn&#39;t open $NewTextFile: $! \n&quot;</span><span class="sc">;</span>
219 206
220 207 <span class="i">$_</span> = <span class="q">&lt;TEXTFILE&gt;</span><span class="sc">;</span>
221 208 <span class="c"># Write out column labels...</span>
222 209 <span class="k">my</span><span class="s">(</span><span class="i">$Line</span><span class="cm">,</span> <span class="i">@LineWords</span><span class="cm">,</span> <span class="i">@ColLabels</span><span class="cm">,</span> <span class="i">$ColLabelLine</span><span class="cm">,</span> <span class="i">@ColValues</span><span class="cm">,</span> <span class="i">$ColValuesLine</span><span class="cm">,</span> <span class="i">$ColNum</span><span class="cm">,</span> <span class="i">$ColValue</span><span class="s">)</span><span class="sc">;</span>
223 210 <span class="i">@ColLabels</span> = <span class="s">(</span><span class="s">)</span><span class="sc">;</span> <span class="i">$ColLabelLine</span> = <span class="q">&quot;&quot;</span><span class="sc">;</span>
224 211 <span class="k">for</span> <span class="i">$ColNum</span> <span class="s">(</span><span class="i">@ColNumsToExtract</span><span class="s">)</span> <span class="s">{</span>
225 212 <span class="k">push</span> <span class="i">@ColLabels</span><span class="cm">,</span> <span class="i">$TextFilesInfo</span>{<span class="w">ColLabels</span>}[<span class="i">$Index</span>][<span class="i">$ColNum</span>]<span class="sc">;</span>
226 213 <span class="s">}</span>
227 214 <span class="i">$ColLabelLine</span> = <span class="i">JoinWords</span><span class="s">(</span>\<span class="i">@ColLabels</span><span class="cm">,</span> <span class="i">$OptionsInfo</span>{<span class="w">OutDelim</span>}<span class="cm">,</span> <span class="i">$OptionsInfo</span>{<span class="w">OutQuote</span>}<span class="s">)</span><span class="sc">;</span>
228 215 <span class="k">print</span> <span class="i">NEWTEXTFILE</span> <span class="q">&quot;$ColLabelLine\n&quot;</span><span class="sc">;</span>
229 216
230 217 <span class="k">while</span> <span class="s">(</span><span class="i">$Line</span> = <span class="i">GetTextLine</span><span class="s">(</span>\<span class="i">*TEXTFILE</span><span class="s">)</span><span class="s">)</span> <span class="s">{</span>
231 218 <span class="i">@LineWords</span> = <span class="i">quotewords</span><span class="s">(</span><span class="i">$InDelim</span><span class="cm">,</span> <span class="n">0</span><span class="cm">,</span> <span class="i">$Line</span><span class="s">)</span><span class="sc">;</span>
232 219 <span class="i">@ColValues</span> = <span class="s">(</span><span class="s">)</span><span class="sc">;</span> <span class="i">$ColValuesLine</span> = <span class="q">&quot;&quot;</span><span class="sc">;</span>
233 220 <span class="k">for</span> <span class="i">$ColNum</span> <span class="s">(</span><span class="i">@ColNumsToExtract</span><span class="s">)</span> <span class="s">{</span>
234 221 <span class="i">$ColValue</span> = <span class="q">&quot;&quot;</span><span class="sc">;</span>
235 222 <span class="k">if</span> <span class="s">(</span><span class="i">$ColNum</span> &lt; <span class="i">@LineWords</span><span class="s">)</span> <span class="s">{</span>
236 223 <span class="i">$ColValue</span> = <span class="s">(</span><span class="k">defined</span> <span class="i">$LineWords</span>[<span class="i">$ColNum</span>]<span class="s">)</span> ? <span class="i">$LineWords</span>[<span class="i">$ColNum</span>] <span class="co">:</span> <span class="q">&quot;&quot;</span><span class="sc">;</span>
237 224 <span class="s">}</span>
238 225 <span class="k">push</span> <span class="i">@ColValues</span><span class="cm">,</span> <span class="i">$ColValue</span><span class="sc">;</span>
239 226 <span class="s">}</span>
240 227 <span class="i">$ColValuesLine</span> = <span class="i">JoinWords</span><span class="s">(</span>\<span class="i">@ColValues</span><span class="cm">,</span> <span class="i">$OptionsInfo</span>{<span class="w">OutDelim</span>}<span class="cm">,</span> <span class="i">$OptionsInfo</span>{<span class="w">OutQuote</span>}<span class="s">)</span><span class="sc">;</span>
241 228 <span class="k">print</span> <span class="i">NEWTEXTFILE</span> <span class="q">&quot;$ColValuesLine\n&quot;</span><span class="sc">;</span>
242 229 <span class="s">}</span>
243 230 <span class="k">close</span> <span class="w">NEWTEXTFILE</span><span class="sc">;</span>
244 231 <span class="k">close</span> <span class="w">TEXTFILE</span><span class="sc">;</span>
245 232 <span class="s">}</span>
246 233
247 234 <span class="c"># Extract data for specific rows...</span>
248 <a name="ExtractRowsData-"></a> 235 <span class="k">sub </span><span class="m">ExtractRowsData</span> <span class="s">{</span>
249 236 <span class="k">my</span><span class="s">(</span><span class="i">$Index</span><span class="s">)</span> = <span class="i">@_</span><span class="sc">;</span>
250 237 <span class="k">my</span><span class="s">(</span><span class="i">$TextFile</span><span class="cm">,</span> <span class="i">$NewTextFile</span><span class="cm">,</span> <span class="i">$InDelim</span><span class="cm">,</span> <span class="i">$SpecifiedRowsMode</span><span class="s">)</span><span class="sc">;</span>
251 238
252 239 <span class="i">$TextFile</span> = <span class="i">$TextFilesList</span>[<span class="i">$Index</span>]<span class="sc">;</span>
253 240 <span class="i">$NewTextFile</span> =<span class="i">$TextFilesInfo</span>{<span class="w">OutFile</span>}[<span class="i">$Index</span>]<span class="sc">;</span>
254 241 <span class="i">$InDelim</span> = <span class="i">$TextFilesInfo</span>{<span class="w">InDelim</span>}[<span class="i">$Index</span>]<span class="sc">;</span>
255 242
256 243 <span class="i">$SpecifiedRowsMode</span> = <span class="i">$OptionsInfo</span>{<span class="w">SpecifiedRowsMode</span>}<span class="sc">;</span>
257 244
258 245 <span class="k">print</span> <span class="q">&quot;Generating file $NewTextFile...\n&quot;</span><span class="sc">;</span>
259 246 <span class="k">open</span> <span class="w">TEXTFILE</span><span class="cm">,</span> <span class="q">&quot;$TextFile&quot;</span> <span class="k">or</span> <span class="k">die</span> <span class="q">&quot;Couldn&#39;t open $TextFile: $! \n&quot;</span><span class="sc">;</span>
260 247 <span class="k">open</span> <span class="w">NEWTEXTFILE</span><span class="cm">,</span> <span class="q">&quot;&gt;$NewTextFile&quot;</span> <span class="k">or</span> <span class="k">die</span> <span class="q">&quot;Couldn&#39;t open $NewTextFile: $! \n&quot;</span><span class="sc">;</span>
261 248
262 249 <span class="k">my</span><span class="s">(</span><span class="i">$Line</span><span class="cm">,</span> <span class="i">$RowCount</span><span class="cm">,</span> <span class="i">@LineWords</span><span class="cm">,</span> <span class="i">@ColLabels</span><span class="s">)</span><span class="sc">;</span>
263 250
264 251 <span class="c"># Write out column labels...</span>
265 252 <span class="i">$Line</span> = <span class="q">&lt;TEXTFILE&gt;</span><span class="sc">;</span>
266 253 <span class="k">push</span> <span class="i">@ColLabels</span><span class="cm">,</span> <span class="i">@</span>{<span class="i">$TextFilesInfo</span>{<span class="w">ColLabels</span>}[<span class="i">$Index</span>]}<span class="sc">;</span>
267 254 <span class="i">$Line</span> = <span class="i">JoinWords</span><span class="s">(</span>\<span class="i">@ColLabels</span><span class="cm">,</span> <span class="i">$OptionsInfo</span>{<span class="w">OutDelim</span>}<span class="cm">,</span> <span class="i">$OptionsInfo</span>{<span class="w">OutQuote</span>}<span class="s">)</span><span class="sc">;</span>
268 255 <span class="k">print</span> <span class="i">NEWTEXTFILE</span> <span class="q">&quot;$Line\n&quot;</span><span class="sc">;</span>
269 256
270 257 <span class="k">if</span> <span class="s">(</span><span class="i">$SpecifiedRowsMode</span> =~ <span class="q">/^rowsbycolvalue$/i</span><span class="s">)</span> <span class="s">{</span>
271 258 <span class="i">ExtractRowsByColValue</span><span class="s">(</span><span class="i">$Index</span><span class="cm">,</span> \<span class="i">*TEXTFILE</span><span class="cm">,</span> \<span class="i">*NEWTEXTFILE</span><span class="s">)</span><span class="sc">;</span>
272 259 <span class="s">}</span>
273 260 <span class="k">elsif</span> <span class="s">(</span><span class="i">$SpecifiedRowsMode</span> =~ <span class="q">/^rowsbycolvaluelist$/i</span><span class="s">)</span> <span class="s">{</span>
274 261 <span class="i">ExtractRowsByColValueList</span><span class="s">(</span><span class="i">$Index</span><span class="cm">,</span> \<span class="i">*TEXTFILE</span><span class="cm">,</span> \<span class="i">*NEWTEXTFILE</span><span class="s">)</span><span class="sc">;</span>
275 262 <span class="s">}</span>
276 263 <span class="k">elsif</span> <span class="s">(</span><span class="i">$SpecifiedRowsMode</span> =~ <span class="q">/^rowsbycolvaluerange$/i</span><span class="s">)</span> <span class="s">{</span>
277 264 <span class="i">ExtractRowsByColValueRange</span><span class="s">(</span><span class="i">$Index</span><span class="cm">,</span> \<span class="i">*TEXTFILE</span><span class="cm">,</span> \<span class="i">*NEWTEXTFILE</span><span class="s">)</span><span class="sc">;</span>
278 265 <span class="s">}</span>
279 266 <span class="k">elsif</span> <span class="s">(</span><span class="i">$SpecifiedRowsMode</span> =~ <span class="q">/^(rowbymincolvalue|rowbymaxcolvalue)$/i</span><span class="s">)</span> <span class="s">{</span>
280 267 <span class="i">ExtractRowByMinOrMaxColValue</span><span class="s">(</span><span class="i">$Index</span><span class="cm">,</span> \<span class="i">*TEXTFILE</span><span class="cm">,</span> \<span class="i">*NEWTEXTFILE</span><span class="s">)</span><span class="sc">;</span>
281 268 <span class="s">}</span>
282 269 <span class="k">elsif</span> <span class="s">(</span><span class="i">$SpecifiedRowsMode</span> =~ <span class="q">/^rownums$/i</span><span class="s">)</span> <span class="s">{</span>
283 270 <span class="i">ExtractRowsByRowNums</span><span class="s">(</span><span class="i">$Index</span><span class="cm">,</span> \<span class="i">*TEXTFILE</span><span class="cm">,</span> \<span class="i">*NEWTEXTFILE</span><span class="s">)</span><span class="sc">;</span>
284 271 <span class="s">}</span>
285 272 <span class="k">elsif</span> <span class="s">(</span><span class="i">$SpecifiedRowsMode</span> =~ <span class="q">/^rownumrange$/i</span><span class="s">)</span> <span class="s">{</span>
286 273 <span class="i">ExtractRowsByRowNumRange</span><span class="s">(</span><span class="i">$Index</span><span class="cm">,</span> \<span class="i">*TEXTFILE</span><span class="cm">,</span> \<span class="i">*NEWTEXTFILE</span><span class="s">)</span><span class="sc">;</span>
287 274 <span class="s">}</span>
288 275
289 276 <span class="k">close</span> <span class="w">NEWTEXTFILE</span><span class="sc">;</span>
290 277 <span class="k">close</span> <span class="w">TEXTFILE</span><span class="sc">;</span>
291 278 <span class="s">}</span>
292 279
293 280 <span class="c"># Extract rows by column value...</span>
294 <a name="ExtractRowsByColValue-"></a> 281 <span class="k">sub </span><span class="m">ExtractRowsByColValue</span> <span class="s">{</span>
295 282 <span class="k">my</span><span class="s">(</span><span class="i">$Index</span><span class="cm">,</span> <span class="i">$TextFileRef</span><span class="cm">,</span> <span class="i">$NewTextFileRef</span><span class="s">)</span> = <span class="i">@_</span><span class="sc">;</span>
296 283 <span class="k">my</span><span class="s">(</span><span class="i">$Line</span><span class="cm">,</span> <span class="i">$ColNum</span><span class="cm">,</span> <span class="i">$ColValue</span><span class="cm">,</span> <span class="i">$Criterion</span><span class="cm">,</span> <span class="i">$Value</span><span class="cm">,</span> <span class="i">$ValueIndex</span><span class="cm">,</span> <span class="i">$InDelim</span><span class="cm">,</span> <span class="i">@LineWords</span><span class="s">)</span><span class="sc">;</span>
297 284
298 285 <span class="i">$InDelim</span> = <span class="i">$TextFilesInfo</span>{<span class="w">InDelim</span>}[<span class="i">$Index</span>]<span class="sc">;</span>
299 286
300 287 <span class="j">LINE:</span> <span class="k">while</span> <span class="s">(</span><span class="i">$Line</span> = <span class="i">GetTextLine</span><span class="s">(</span><span class="i">$TextFileRef</span><span class="s">)</span><span class="s">)</span> <span class="s">{</span>
301 288 <span class="i">@LineWords</span> = <span class="i">quotewords</span><span class="s">(</span><span class="i">$InDelim</span><span class="cm">,</span> <span class="n">0</span><span class="cm">,</span> <span class="i">$Line</span><span class="s">)</span><span class="sc">;</span>
302 289 <span class="k">for</span> <span class="s">(</span><span class="i">$ValueIndex</span> = <span class="n">0</span><span class="sc">;</span> <span class="i">$ValueIndex</span> &lt; <span class="i">@</span>{<span class="i">$TextFilesInfo</span>{<span class="w">RowValues</span>}[<span class="i">$Index</span>]}<span class="sc">;</span> <span class="i">$ValueIndex</span> = <span class="i">$ValueIndex</span> + <span class="n">3</span><span class="s">)</span> <span class="s">{</span>
303 290 <span class="i">$ColNum</span> = <span class="i">$TextFilesInfo</span>{<span class="w">RowValues</span>}[<span class="i">$Index</span>][<span class="i">$ValueIndex</span>]<span class="sc">;</span>
304 291 <span class="i">$ColValue</span> = <span class="i">$TextFilesInfo</span>{<span class="w">RowValues</span>}[<span class="i">$Index</span>][<span class="i">$ValueIndex</span> + <span class="n">1</span>]<span class="sc">;</span>
305 292 <span class="i">$Criterion</span> = <span class="i">$TextFilesInfo</span>{<span class="w">RowValues</span>}[<span class="i">$Index</span>][<span class="i">$ValueIndex</span> + <span class="n">2</span>]<span class="sc">;</span>
306 293 <span class="k">if</span> <span class="s">(</span><span class="i">$ColNum</span> &gt; <span class="i">$#LineWords</span><span class="s">)</span> <span class="s">{</span>
307 294 <span class="k">next</span> <span class="j">LINE</span><span class="sc">;</span>
308 295 <span class="s">}</span>
309 296 <span class="i">$Value</span> = <span class="i">$LineWords</span>[<span class="i">$ColNum</span>]<span class="sc">;</span>
310 297 <span class="k">if</span> <span class="s">(</span><span class="i">$Criterion</span> =~ <span class="q">/^le$/i</span><span class="s">)</span> <span class="s">{</span>
311 298 <span class="k">if</span> <span class="s">(</span><span class="i">$Value</span> &gt; <span class="i">$ColValue</span><span class="s">)</span> <span class="s">{</span>
312 299 <span class="k">next</span> <span class="j">LINE</span><span class="sc">;</span>
313 300 <span class="s">}</span>
314 301 <span class="s">}</span>
315 302 <span class="k">elsif</span> <span class="s">(</span><span class="i">$Criterion</span> =~ <span class="q">/^ge$/i</span><span class="s">)</span> <span class="s">{</span>
316 303 <span class="k">if</span> <span class="s">(</span><span class="i">$Value</span> &lt; <span class="i">$ColValue</span><span class="s">)</span> <span class="s">{</span>
317 304 <span class="k">next</span> <span class="j">LINE</span><span class="sc">;</span>
318 305 <span class="s">}</span>
319 306 <span class="s">}</span>
320 307 <span class="k">elsif</span> <span class="s">(</span><span class="i">$Criterion</span> =~ <span class="q">/^eq$/i</span><span class="s">)</span> <span class="s">{</span>
321 308 <span class="k">if</span> <span class="s">(</span><span class="i">$Value</span> <span class="k">ne</span> <span class="i">$ColValue</span><span class="s">)</span> <span class="s">{</span>
322 309 <span class="k">next</span> <span class="j">LINE</span><span class="sc">;</span>
323 310 <span class="s">}</span>
324 311 <span class="s">}</span>
325 312 <span class="s">}</span>
326 313 <span class="c"># Write it out...</span>
327 314 <span class="i">$Line</span> = <span class="i">JoinWords</span><span class="s">(</span>\<span class="i">@LineWords</span><span class="cm">,</span> <span class="i">$OptionsInfo</span>{<span class="w">OutDelim</span>}<span class="cm">,</span> <span class="i">$OptionsInfo</span>{<span class="w">OutQuote</span>}<span class="s">)</span><span class="sc">;</span>
328 315 <span class="k">print</span> <span class="i">$NewTextFileRef</span> <span class="q">&quot;$Line\n&quot;</span><span class="sc">;</span>
329 316 <span class="s">}</span>
330 317 <span class="s">}</span>
331 318 <span class="c"># Extract rows by column value list...</span>
332 <a name="ExtractRowsByColValueList-"></a> 319 <span class="k">sub </span><span class="m">ExtractRowsByColValueList</span> <span class="s">{</span>
333 320 <span class="k">my</span><span class="s">(</span><span class="i">$Index</span><span class="cm">,</span> <span class="i">$TextFileRef</span><span class="cm">,</span> <span class="i">$NewTextFileRef</span><span class="s">)</span> = <span class="i">@_</span><span class="sc">;</span>
334 321 <span class="k">my</span><span class="s">(</span><span class="i">$Line</span><span class="cm">,</span> <span class="i">$ColNum</span><span class="cm">,</span> <span class="i">$ColValue</span><span class="cm">,</span> <span class="i">$ValueIndex</span><span class="cm">,</span> <span class="i">$Value</span><span class="cm">,</span> <span class="i">$InDelim</span><span class="cm">,</span> <span class="i">%ColValueMap</span><span class="cm">,</span> <span class="i">@LineWords</span><span class="s">)</span><span class="sc">;</span>
335 322
336 323 <span class="i">$InDelim</span> = <span class="i">$TextFilesInfo</span>{<span class="w">InDelim</span>}[<span class="i">$Index</span>]<span class="sc">;</span>
337 324 <span class="i">$ColNum</span> = <span class="i">$TextFilesInfo</span>{<span class="w">RowValues</span>}[<span class="i">$Index</span>][<span class="n">0</span>]<span class="sc">;</span>
338 325
339 326 <span class="c"># Setup a col value map...</span>
340 327 <span class="i">%ColValueMap</span> = <span class="s">(</span><span class="s">)</span><span class="sc">;</span>
341 328 <span class="k">for</span> <span class="i">$ValueIndex</span> <span class="s">(</span><span class="n">1</span> .. <span class="i">$#</span>{<span class="i">$TextFilesInfo</span>{<span class="w">RowValues</span>}[<span class="i">$Index</span>]}<span class="s">)</span> <span class="s">{</span>
342 329 <span class="i">$Value</span> = <span class="i">$TextFilesInfo</span>{<span class="w">RowValues</span>}[<span class="i">$Index</span>][<span class="i">$ValueIndex</span>]<span class="sc">;</span>
343 330 <span class="i">$ColValueMap</span>{<span class="i">$Value</span>} = <span class="i">$Value</span><span class="sc">;</span>
344 331 <span class="s">}</span>
345 332
346 333 <span class="j">LINE:</span> <span class="k">while</span> <span class="s">(</span><span class="i">$Line</span> = <span class="i">GetTextLine</span><span class="s">(</span><span class="i">$TextFileRef</span><span class="s">)</span><span class="s">)</span> <span class="s">{</span>
347 334 <span class="i">@LineWords</span> = <span class="i">quotewords</span><span class="s">(</span><span class="i">$InDelim</span><span class="cm">,</span> <span class="n">0</span><span class="cm">,</span> <span class="i">$Line</span><span class="s">)</span><span class="sc">;</span>
348 335 <span class="k">if</span> <span class="s">(</span><span class="i">$ColNum</span> &gt; <span class="i">$#LineWords</span><span class="s">)</span> <span class="s">{</span>
349 336 <span class="k">next</span> <span class="j">LINE</span><span class="sc">;</span>
350 337 <span class="s">}</span>
351 338 <span class="i">$ColValue</span> = <span class="i">$LineWords</span>[<span class="i">$ColNum</span>]<span class="sc">;</span>
352 339 <span class="k">if</span> <span class="s">(</span><span class="k">exists</span> <span class="i">$ColValueMap</span>{<span class="i">$ColValue</span>}<span class="s">)</span> <span class="s">{</span>
353 340 <span class="i">$Line</span> = <span class="i">JoinWords</span><span class="s">(</span>\<span class="i">@LineWords</span><span class="cm">,</span> <span class="i">$OptionsInfo</span>{<span class="w">OutDelim</span>}<span class="cm">,</span> <span class="i">$OptionsInfo</span>{<span class="w">OutQuote</span>}<span class="s">)</span><span class="sc">;</span>
354 341 <span class="k">print</span> <span class="i">$NewTextFileRef</span> <span class="q">&quot;$Line\n&quot;</span><span class="sc">;</span>
355 342 <span class="s">}</span>
356 343 <span class="s">}</span>
357 344 <span class="s">}</span>
358 345
359 346 <span class="c"># Extract row by minimum column value...</span>
360 <a name="ExtractRowByMinOrMaxColValue-"></a> 347 <span class="k">sub </span><span class="m">ExtractRowByMinOrMaxColValue</span> <span class="s">{</span>
361 348 <span class="k">my</span><span class="s">(</span><span class="i">$Index</span><span class="cm">,</span> <span class="i">$TextFileRef</span><span class="cm">,</span> <span class="i">$NewTextFileRef</span><span class="s">)</span> = <span class="i">@_</span><span class="sc">;</span>
362 349 <span class="k">my</span><span class="s">(</span><span class="i">$Line</span><span class="cm">,</span> <span class="i">$ColNum</span><span class="cm">,</span> <span class="i">$ColValue</span><span class="cm">,</span> <span class="i">$FirstValue</span><span class="cm">,</span> <span class="i">$ValueLine</span><span class="cm">,</span> <span class="i">$InDelim</span><span class="cm">,</span> <span class="i">@LineWords</span><span class="s">)</span><span class="sc">;</span>
363 350
364 351 <span class="i">$InDelim</span> = <span class="i">$TextFilesInfo</span>{<span class="w">InDelim</span>}[<span class="i">$Index</span>]<span class="sc">;</span>
365 352 <span class="i">$ColNum</span> = <span class="i">$TextFilesInfo</span>{<span class="w">RowValues</span>}[<span class="i">$Index</span>][<span class="n">0</span>]<span class="sc">;</span>
366 353
367 354 <span class="i">$ValueLine</span> = <span class="q">&#39;&#39;</span><span class="sc">;</span> <span class="i">$ColValue</span> = <span class="q">&#39;&#39;</span><span class="sc">;</span> <span class="i">$FirstValue</span> = <span class="n">1</span><span class="sc">;</span>
368 355 <span class="j">LINE:</span> <span class="k">while</span> <span class="s">(</span><span class="i">$Line</span> = <span class="i">GetTextLine</span><span class="s">(</span><span class="i">$TextFileRef</span><span class="s">)</span><span class="s">)</span> <span class="s">{</span>
369 356 <span class="i">@LineWords</span> = <span class="i">quotewords</span><span class="s">(</span><span class="i">$InDelim</span><span class="cm">,</span> <span class="n">0</span><span class="cm">,</span> <span class="i">$Line</span><span class="s">)</span><span class="sc">;</span>
370 357 <span class="k">if</span> <span class="s">(</span><span class="i">$ColNum</span> &gt; <span class="i">$#LineWords</span><span class="s">)</span> <span class="s">{</span>
371 358 <span class="k">next</span> <span class="j">LINE</span><span class="sc">;</span>
372 359 <span class="s">}</span>
373 360 <span class="k">if</span> <span class="s">(</span><span class="i">$FirstValue</span><span class="s">)</span> <span class="s">{</span>
374 361 <span class="i">$FirstValue</span> = <span class="n">0</span><span class="sc">;</span>
375 362 <span class="i">$ColValue</span> = <span class="i">$LineWords</span>[<span class="i">$ColNum</span>]<span class="sc">;</span>
376 363 <span class="i">$ValueLine</span> = <span class="i">$Line</span><span class="sc">;</span>
377 364 <span class="k">next</span> <span class="j">LINE</span><span class="sc">;</span>
378 365 <span class="s">}</span>
379 366 <span class="k">if</span> <span class="s">(</span><span class="i">$OptionsInfo</span>{<span class="w">SpecifiedRowsMode</span>} =~ <span class="q">/^rowbymaxcolvalue$/i</span><span class="s">)</span> <span class="s">{</span>
380 367 <span class="k">if</span> <span class="s">(</span><span class="i">$LineWords</span>[<span class="i">$ColNum</span>] &gt; <span class="i">$ColValue</span><span class="s">)</span> <span class="s">{</span>
381 368 <span class="i">$ColValue</span> = <span class="i">$LineWords</span>[<span class="i">$ColNum</span>]<span class="sc">;</span>
382 369 <span class="i">$ValueLine</span> = <span class="i">$Line</span><span class="sc">;</span>
383 370 <span class="s">}</span>
384 371 <span class="s">}</span>
385 372 <span class="k">else</span> <span class="s">{</span>
386 373 <span class="k">if</span> <span class="s">(</span><span class="i">$LineWords</span>[<span class="i">$ColNum</span>] &lt; <span class="i">$ColValue</span><span class="s">)</span> <span class="s">{</span>
387 374 <span class="i">$ColValue</span> = <span class="i">$LineWords</span>[<span class="i">$ColNum</span>]<span class="sc">;</span>
388 375 <span class="i">$ValueLine</span> = <span class="i">$Line</span><span class="sc">;</span>
389 376 <span class="s">}</span>
390 377 <span class="s">}</span>
391 378 <span class="s">}</span>
392 379 <span class="k">if</span> <span class="s">(</span><span class="i">$ValueLine</span><span class="s">)</span> <span class="s">{</span>
393 380 <span class="i">@LineWords</span> = <span class="i">quotewords</span><span class="s">(</span><span class="i">$InDelim</span><span class="cm">,</span> <span class="n">0</span><span class="cm">,</span> <span class="i">$ValueLine</span><span class="s">)</span><span class="sc">;</span>
394 381 <span class="i">$Line</span> = <span class="i">JoinWords</span><span class="s">(</span>\<span class="i">@LineWords</span><span class="cm">,</span> <span class="i">$OptionsInfo</span>{<span class="w">OutDelim</span>}<span class="cm">,</span> <span class="i">$OptionsInfo</span>{<span class="w">OutQuote</span>}<span class="s">)</span><span class="sc">;</span>
395 382 <span class="k">print</span> <span class="i">$NewTextFileRef</span> <span class="q">&quot;$Line\n&quot;</span><span class="sc">;</span>
396 383 <span class="s">}</span>
397 384 <span class="s">}</span>
398 385
399 386 <span class="c"># Extract rows by column value range...</span>
400 <a name="ExtractRowsByColValueRange-"></a> 387 <span class="k">sub </span><span class="m">ExtractRowsByColValueRange</span> <span class="s">{</span>
401 388 <span class="k">my</span><span class="s">(</span><span class="i">$Index</span><span class="cm">,</span> <span class="i">$TextFileRef</span><span class="cm">,</span> <span class="i">$NewTextFileRef</span><span class="s">)</span> = <span class="i">@_</span><span class="sc">;</span>
402 389 <span class="k">my</span><span class="s">(</span><span class="i">$Line</span><span class="cm">,</span> <span class="i">$ColNum</span><span class="cm">,</span> <span class="i">$ColValue</span><span class="cm">,</span> <span class="i">$MinValue</span><span class="cm">,</span> <span class="i">$MaxValue</span><span class="cm">,</span> <span class="i">$InDelim</span><span class="cm">,</span> <span class="i">@LineWords</span><span class="s">)</span><span class="sc">;</span>
403 390
404 391 <span class="i">$InDelim</span> = <span class="i">$TextFilesInfo</span>{<span class="w">InDelim</span>}[<span class="i">$Index</span>]<span class="sc">;</span>
405 392 <span class="i">$ColNum</span> = <span class="i">$TextFilesInfo</span>{<span class="w">RowValues</span>}[<span class="i">$Index</span>][<span class="n">0</span>]<span class="sc">;</span>
406 393 <span class="i">$MinValue</span> = <span class="i">$TextFilesInfo</span>{<span class="w">RowValues</span>}[<span class="i">$Index</span>][<span class="n">1</span>]<span class="sc">;</span>
407 394 <span class="i">$MaxValue</span> = <span class="i">$TextFilesInfo</span>{<span class="w">RowValues</span>}[<span class="i">$Index</span>][<span class="n">2</span>]<span class="sc">;</span>
408 395
409 396 <span class="j">LINE:</span> <span class="k">while</span> <span class="s">(</span><span class="i">$Line</span> = <span class="i">GetTextLine</span><span class="s">(</span><span class="i">$TextFileRef</span><span class="s">)</span><span class="s">)</span> <span class="s">{</span>
410 397 <span class="i">@LineWords</span> = <span class="i">quotewords</span><span class="s">(</span><span class="i">$InDelim</span><span class="cm">,</span> <span class="n">0</span><span class="cm">,</span> <span class="i">$Line</span><span class="s">)</span><span class="sc">;</span>
411 398 <span class="k">if</span> <span class="s">(</span><span class="i">$ColNum</span> &gt; <span class="i">$#LineWords</span><span class="s">)</span> <span class="s">{</span>
412 399 <span class="k">next</span> <span class="j">LINE</span><span class="sc">;</span>
413 400 <span class="s">}</span>
414 401 <span class="i">$ColValue</span> = <span class="i">$LineWords</span>[<span class="i">$ColNum</span>]<span class="sc">;</span>
415 402 <span class="k">if</span> <span class="s">(</span><span class="i">$ColValue</span> &gt;= <span class="i">$MinValue</span> &amp;&amp; <span class="i">$ColValue</span> &lt;= <span class="i">$MaxValue</span><span class="s">)</span> <span class="s">{</span>
416 403 <span class="i">$Line</span> = <span class="i">JoinWords</span><span class="s">(</span>\<span class="i">@LineWords</span><span class="cm">,</span> <span class="i">$OptionsInfo</span>{<span class="w">OutDelim</span>}<span class="cm">,</span> <span class="i">$OptionsInfo</span>{<span class="w">OutQuote</span>}<span class="s">)</span><span class="sc">;</span>
417 404 <span class="k">print</span> <span class="i">$NewTextFileRef</span> <span class="q">&quot;$Line\n&quot;</span><span class="sc">;</span>
418 405 <span class="s">}</span>
419 406 <span class="s">}</span>
420 407 <span class="s">}</span>
421 408
422 409 <span class="c"># Extract rows by row number range...</span>
423 <a name="ExtractRowsByRowNumRange-"></a> 410 <span class="k">sub </span><span class="m">ExtractRowsByRowNumRange</span> <span class="s">{</span>
424 411 <span class="k">my</span><span class="s">(</span><span class="i">$Index</span><span class="cm">,</span> <span class="i">$TextFileRef</span><span class="cm">,</span> <span class="i">$NewTextFileRef</span><span class="s">)</span> = <span class="i">@_</span><span class="sc">;</span>
425 412
426 413 <span class="k">my</span><span class="s">(</span><span class="i">$Line</span><span class="cm">,</span> <span class="i">$MinRowNum</span><span class="cm">,</span> <span class="i">$MaxRowNum</span><span class="cm">,</span> <span class="i">$RowCount</span><span class="cm">,</span> <span class="i">$InDelim</span><span class="cm">,</span> <span class="i">@LineWords</span><span class="s">)</span><span class="sc">;</span>
427 414 <span class="i">$InDelim</span> = <span class="i">$TextFilesInfo</span>{<span class="w">InDelim</span>}[<span class="i">$Index</span>]<span class="sc">;</span>
428 415 <span class="i">$MinRowNum</span> = <span class="i">$TextFilesInfo</span>{<span class="w">RowValues</span>}[<span class="i">$Index</span>][<span class="n">0</span>]<span class="sc">;</span>
429 416 <span class="i">$MaxRowNum</span> = <span class="i">$TextFilesInfo</span>{<span class="w">RowValues</span>}[<span class="i">$Index</span>][<span class="n">1</span>]<span class="sc">;</span>
430 417
431 418 <span class="i">$RowCount</span> = <span class="n">1</span><span class="sc">;</span>
432 419 <span class="j">LINE:</span> <span class="k">while</span> <span class="s">(</span><span class="i">$Line</span> = <span class="i">GetTextLine</span><span class="s">(</span><span class="i">$TextFileRef</span><span class="s">)</span><span class="s">)</span> <span class="s">{</span>
433 420 <span class="i">$RowCount</span>++<span class="sc">;</span>
434 421 <span class="k">if</span> <span class="s">(</span><span class="i">$RowCount</span> &gt;= <span class="i">$MinRowNum</span> &amp;&amp; <span class="i">$RowCount</span> &lt;= <span class="i">$MaxRowNum</span><span class="s">)</span> <span class="s">{</span>
435 422 <span class="i">@LineWords</span> = <span class="i">quotewords</span><span class="s">(</span><span class="i">$InDelim</span><span class="cm">,</span> <span class="n">0</span><span class="cm">,</span> <span class="i">$Line</span><span class="s">)</span><span class="sc">;</span>
436 423 <span class="i">$Line</span> = <span class="i">JoinWords</span><span class="s">(</span>\<span class="i">@LineWords</span><span class="cm">,</span> <span class="i">$OptionsInfo</span>{<span class="w">OutDelim</span>}<span class="cm">,</span> <span class="i">$OptionsInfo</span>{<span class="w">OutQuote</span>}<span class="s">)</span><span class="sc">;</span>
437 424 <span class="k">print</span> <span class="i">$NewTextFileRef</span> <span class="q">&quot;$Line\n&quot;</span><span class="sc">;</span>
438 425 <span class="s">}</span>
439 426 <span class="k">elsif</span> <span class="s">(</span><span class="i">$RowCount</span> &gt; <span class="i">$MaxRowNum</span><span class="s">)</span> <span class="s">{</span>
440 427 <span class="k">last</span> <span class="j">LINE</span><span class="sc">;</span>
441 428 <span class="s">}</span>
442 429 <span class="s">}</span>
443 430 <span class="s">}</span>
444 431
445 432 <span class="c"># Extract rows by row numbers...</span>
446 <a name="ExtractRowsByRowNums-"></a> 433 <span class="k">sub </span><span class="m">ExtractRowsByRowNums</span> <span class="s">{</span>
447 434 <span class="k">my</span><span class="s">(</span><span class="i">$Index</span><span class="cm">,</span> <span class="i">$TextFileRef</span><span class="cm">,</span> <span class="i">$NewTextFileRef</span><span class="s">)</span> = <span class="i">@_</span><span class="sc">;</span>
448 435 <span class="k">my</span><span class="s">(</span><span class="i">$Line</span><span class="cm">,</span> <span class="i">$RowNum</span><span class="cm">,</span> <span class="i">$MaxRowNum</span><span class="cm">,</span> <span class="i">$RowCount</span><span class="cm">,</span> <span class="i">$InDelim</span><span class="cm">,</span> <span class="i">%RowNumMap</span><span class="cm">,</span> <span class="i">@LineWords</span><span class="s">)</span><span class="sc">;</span>
449 436
450 437 <span class="i">$InDelim</span> = <span class="i">$TextFilesInfo</span>{<span class="w">InDelim</span>}[<span class="i">$Index</span>]<span class="sc">;</span>
451 438
452 439 <span class="c"># Setup a row nums map...</span>
453 440 <span class="i">%RowNumMap</span> = <span class="s">(</span><span class="s">)</span><span class="sc">;</span>
454 441 <span class="i">$MaxRowNum</span> = <span class="i">$TextFilesInfo</span>{<span class="w">RowValues</span>}[<span class="i">$Index</span>][<span class="n">0</span>]<span class="sc">;</span>
455 442 <span class="k">for</span> <span class="i">$RowNum</span> <span class="s">(</span><span class="i">@</span>{<span class="i">$TextFilesInfo</span>{<span class="w">RowValues</span>}[<span class="i">$Index</span>]}<span class="s">)</span> <span class="s">{</span>
456 443 <span class="k">if</span> <span class="s">(</span><span class="i">$RowNum</span> &gt; <span class="i">$MaxRowNum</span><span class="s">)</span> <span class="s">{</span>
457 444 <span class="i">$MaxRowNum</span> = <span class="i">$RowNum</span><span class="sc">;</span>
458 445 <span class="s">}</span>
459 446 <span class="i">$RowNumMap</span>{<span class="i">$RowNum</span>} = <span class="i">$RowNum</span><span class="sc">;</span>
460 447 <span class="s">}</span>
461 448
462 449 <span class="i">$RowCount</span> = <span class="n">1</span><span class="sc">;</span>
463 450 <span class="j">LINE:</span> <span class="k">while</span> <span class="s">(</span><span class="i">$Line</span> = <span class="i">GetTextLine</span><span class="s">(</span><span class="i">$TextFileRef</span><span class="s">)</span><span class="s">)</span> <span class="s">{</span>
464 451 <span class="i">$RowCount</span>++<span class="sc">;</span>
465 452 <span class="k">if</span> <span class="s">(</span><span class="k">exists</span> <span class="i">$RowNumMap</span>{<span class="i">$RowCount</span>}<span class="s">)</span> <span class="s">{</span>
466 453 <span class="i">@LineWords</span> = <span class="i">quotewords</span><span class="s">(</span><span class="i">$InDelim</span><span class="cm">,</span> <span class="n">0</span><span class="cm">,</span> <span class="i">$Line</span><span class="s">)</span><span class="sc">;</span>
467 454 <span class="i">$Line</span> = <span class="i">JoinWords</span><span class="s">(</span>\<span class="i">@LineWords</span><span class="cm">,</span> <span class="i">$OptionsInfo</span>{<span class="w">OutDelim</span>}<span class="cm">,</span> <span class="i">$OptionsInfo</span>{<span class="w">OutQuote</span>}<span class="s">)</span><span class="sc">;</span>
468 455 <span class="k">print</span> <span class="i">$NewTextFileRef</span> <span class="q">&quot;$Line\n&quot;</span><span class="sc">;</span>
469 456 <span class="s">}</span>
470 457 <span class="k">elsif</span> <span class="s">(</span><span class="i">$RowCount</span> &gt; <span class="i">$MaxRowNum</span><span class="s">)</span> <span class="s">{</span>
471 458 <span class="k">last</span> <span class="j">LINE</span><span class="sc">;</span>
472 459 <span class="s">}</span>
473 460 <span class="s">}</span>
474 461 <span class="s">}</span>
475 462
476 463 <span class="c"># Retrieve text file columns and rows information for specified options...</span>
477 <a name="RetrieveColumnsAndRowsInfo-"></a> 464 <span class="k">sub </span><span class="m">RetrieveColumnsAndRowsInfo</span> <span class="s">{</span>
478 465 <span class="i">ProcessColumnsInfo</span><span class="s">(</span><span class="s">)</span><span class="sc">;</span>
479 466 <span class="i">ProcessRowsInfo</span><span class="s">(</span><span class="s">)</span><span class="sc">;</span>
480 467 <span class="s">}</span>
481 468
482 469 <span class="c"># Make sure the specified columns exists in text files...</span>
483 <a name="ProcessColumnsInfo-"></a> 470 <span class="k">sub </span><span class="m">ProcessColumnsInfo</span> <span class="s">{</span>
484 471 <span class="k">my</span><span class="s">(</span><span class="i">$Index</span><span class="cm">,</span> <span class="i">$SpecifiedCategoryCol</span><span class="cm">,</span> <span class="i">$TextFile</span><span class="cm">,</span> <span class="i">@ColNumsToExtract</span><span class="s">)</span><span class="sc">;</span>
485 472
486 473 <span class="i">@</span>{<span class="i">$TextFilesInfo</span>{<span class="w">CategoryColNum</span>}} = <span class="s">(</span><span class="s">)</span><span class="sc">;</span>
487 474 <span class="i">@</span>{<span class="i">$TextFilesInfo</span>{<span class="w">ColNumsToExtract</span>}} = <span class="s">(</span><span class="s">)</span><span class="sc">;</span>
488 475
489 476 <span class="i">$SpecifiedCategoryCol</span> = <span class="i">$OptionsInfo</span>{<span class="w">SpecifiedCategoryCol</span>}<span class="sc">;</span>
490 477
491 478 <span class="j">FILELIST:</span> <span class="k">for</span> <span class="i">$Index</span> <span class="s">(</span><span class="n">0</span> .. <span class="i">$#TextFilesList</span><span class="s">)</span> <span class="s">{</span>
492 479 <span class="i">$TextFile</span> = <span class="i">$TextFilesList</span>[<span class="i">$Index</span>]<span class="sc">;</span>
493 480
494 481 <span class="i">$TextFilesInfo</span>{<span class="w">CategoryColNum</span>}[<span class="i">$Index</span>] = <span class="n">0</span><span class="sc">;</span>
495 482 <span class="i">@</span>{<span class="i">$TextFilesInfo</span>{<span class="w">ColNumsToExtract</span>}[<span class="i">$Index</span>]} = <span class="s">(</span><span class="s">)</span><span class="sc">;</span>
496 483
497 484 <span class="k">if</span> <span class="s">(</span><span class="i">$TextFilesInfo</span>{<span class="w">FileOkay</span>}[<span class="i">$Index</span>]<span class="s">)</span> <span class="s">{</span>
498 485 <span class="k">if</span> <span class="s">(</span><span class="i">$OptionsInfo</span>{<span class="w">Mode</span>} =~ <span class="q">/^categories$/i</span><span class="s">)</span> <span class="s">{</span>
499 486 <span class="k">my</span><span class="s">(</span><span class="i">$CategoryColNum</span><span class="cm">,</span> <span class="i">$CategoryColValid</span><span class="s">)</span><span class="sc">;</span>
500 487
501 488 <span class="i">$CategoryColNum</span> = <span class="n">0</span><span class="sc">;</span>
502 489 <span class="i">$CategoryColValid</span> = <span class="n">1</span><span class="sc">;</span>
503 490 <span class="k">if</span> <span class="s">(</span><span class="i">$SpecifiedCategoryCol</span><span class="s">)</span> <span class="s">{</span>
504 491 <span class="k">if</span> <span class="s">(</span><span class="i">$OptionsInfo</span>{<span class="w">ColMode</span>} =~ <span class="q">/^colnum$/i</span><span class="s">)</span> <span class="s">{</span>
505 492 <span class="k">if</span> <span class="s">(</span><span class="i">$SpecifiedCategoryCol</span> &lt;= <span class="i">$TextFilesInfo</span>{<span class="w">ColCount</span>}[<span class="i">$Index</span>]<span class="s">)</span> <span class="s">{</span>
506 493 <span class="i">$CategoryColNum</span> = <span class="i">$SpecifiedCategoryCol</span> - <span class="n">1</span><span class="sc">;</span>
507 494 <span class="s">}</span>
508 495 <span class="k">else</span> <span class="s">{</span>
509 496 <span class="i">$CategoryColValid</span> = <span class="n">0</span><span class="sc">;</span>
510 497 <span class="s">}</span>
511 498 <span class="s">}</span>
512 499 <span class="k">else</span> <span class="s">{</span>
513 500 <span class="k">if</span> <span class="s">(</span><span class="k">exists</span><span class="s">(</span><span class="i">$TextFilesInfo</span>{<span class="w">ColLabelToNumMap</span>}[<span class="i">$Index</span>]{<span class="i">$SpecifiedCategoryCol</span>}<span class="s">)</span><span class="s">)</span> <span class="s">{</span>
514 501 <span class="i">$CategoryColNum</span> = <span class="i">$TextFilesInfo</span>{<span class="w">ColLabelToNumMap</span>}[<span class="i">$Index</span>]{<span class="i">$SpecifiedCategoryCol</span>}<span class="sc">;</span>
515 502 <span class="s">}</span>
516 503 <span class="k">else</span> <span class="s">{</span>
517 504 <span class="i">$CategoryColValid</span> = <span class="n">0</span><span class="sc">;</span>
518 505 <span class="s">}</span>
519 506 <span class="s">}</span>
520 507 <span class="s">}</span>
521 508 <span class="k">if</span> <span class="s">(</span><span class="i">$CategoryColValid</span><span class="s">)</span> <span class="s">{</span>
522 509 <span class="i">$TextFilesInfo</span>{<span class="w">CategoryColNum</span>}[<span class="i">$Index</span>] = <span class="i">$CategoryColNum</span><span class="sc">;</span>
523 510 <span class="s">}</span>
524 511 <span class="k">else</span> <span class="s">{</span>
525 512 <span class="k">warn</span> <span class="q">&quot;Warning: Ignoring file $TextFile: Category column specified, $SpecifiedCategoryCol, using \&quot;--categorycol\&quot; option doesn&#39;t exist\n&quot;</span><span class="sc">;</span>
526 513 <span class="i">$TextFilesInfo</span>{<span class="w">FileOkay</span>}[<span class="i">$Index</span>] = <span class="n">0</span><span class="sc">;</span>
527 514 <span class="s">}</span>
528 515 <span class="s">}</span>
529 516 <span class="k">elsif</span> <span class="s">(</span><span class="i">$OptionsInfo</span>{<span class="w">Mode</span>} =~ <span class="q">/^columns$/i</span><span class="s">)</span> <span class="s">{</span>
530 517 <span class="k">my</span><span class="s">(</span><span class="i">$SpecifiedColNum</span><span class="cm">,</span> <span class="i">$ColNum</span><span class="s">)</span><span class="sc">;</span>
531 518
532 519 <span class="i">$ColNum</span> = <span class="n">0</span><span class="sc">;</span>
533 520 <span class="i">@ColNumsToExtract</span> = <span class="s">(</span><span class="s">)</span><span class="sc">;</span>
534 521
535 522 <span class="k">if</span> <span class="s">(</span><span class="i">@</span>{<span class="i">$OptionsInfo</span>{<span class="w">SpecifiedColumns</span>}}<span class="s">)</span> <span class="s">{</span>
536 523 <span class="k">if</span> <span class="s">(</span><span class="i">$OptionsInfo</span>{<span class="w">ColMode</span>} =~ <span class="q">/^colnum$/i</span><span class="s">)</span> <span class="s">{</span>
537 524 <span class="k">for</span> <span class="i">$SpecifiedColNum</span> <span class="s">(</span><span class="i">@</span>{<span class="i">$OptionsInfo</span>{<span class="w">SpecifiedColumns</span>}}<span class="s">)</span> <span class="s">{</span>
538 525 <span class="k">if</span> <span class="s">(</span><span class="i">$SpecifiedColNum</span> &gt;=<span class="n">1</span> &amp;&amp; <span class="i">$SpecifiedColNum</span> &lt;= <span class="i">$TextFilesInfo</span>{<span class="w">ColCount</span>}[<span class="i">$Index</span>]<span class="s">)</span> <span class="s">{</span>
539 526 <span class="i">$ColNum</span> = <span class="i">$SpecifiedColNum</span> - <span class="n">1</span><span class="sc">;</span>
540 527 <span class="k">push</span> <span class="i">@ColNumsToExtract</span><span class="cm">,</span> <span class="i">$ColNum</span><span class="sc">;</span>
541 528 <span class="s">}</span>
542 529 <span class="s">}</span>
543 530 <span class="s">}</span>
544 531 <span class="k">else</span> <span class="s">{</span>
545 532 <span class="k">my</span><span class="s">(</span><span class="i">$ColLabel</span><span class="s">)</span><span class="sc">;</span>
546 533 <span class="k">for</span> <span class="i">$ColLabel</span> <span class="s">(</span><span class="i">@</span>{<span class="i">$OptionsInfo</span>{<span class="w">SpecifiedColumns</span>}}<span class="s">)</span> <span class="s">{</span>
547 534 <span class="k">if</span> <span class="s">(</span><span class="k">exists</span><span class="s">(</span><span class="i">$TextFilesInfo</span>{<span class="w">ColLabelToNumMap</span>}[<span class="i">$Index</span>]{<span class="i">$ColLabel</span>}<span class="s">)</span><span class="s">)</span> <span class="s">{</span>
548 535 <span class="k">push</span> <span class="i">@ColNumsToExtract</span><span class="cm">,</span> <span class="i">$TextFilesInfo</span>{<span class="w">ColLabelToNumMap</span>}[<span class="i">$Index</span>]{<span class="i">$ColLabel</span>}<span class="sc">;</span>
549 536 <span class="s">}</span>
550 537 <span class="s">}</span>
551 538 <span class="s">}</span>
552 539 <span class="s">}</span>
553 540 <span class="k">else</span> <span class="s">{</span>
554 541 <span class="k">push</span> <span class="i">@ColNumsToExtract</span><span class="cm">,</span> <span class="i">$ColNum</span><span class="sc">;</span>
555 542 <span class="s">}</span>
556 543 <span class="k">if</span> <span class="s">(</span><span class="i">@ColNumsToExtract</span><span class="s">)</span> <span class="s">{</span>
557 544 <span class="k">push</span> <span class="i">@</span>{<span class="i">$TextFilesInfo</span>{<span class="w">ColNumsToExtract</span>}[<span class="i">$Index</span>]}<span class="cm">,</span> <span class="i">@ColNumsToExtract</span><span class="sc">;</span>
558 545 <span class="s">}</span>
559 546 <span class="k">else</span> <span class="s">{</span>
560 547 <span class="k">warn</span> <span class="q">&quot;Warning: Ignoring file $TextFile: None of the columns specified, @{$OptionsInfo{SpecifiedColumns}}, using \&quot;--columns\&quot; option exist\n&quot;</span><span class="sc">;</span>
561 548 <span class="i">$TextFilesInfo</span>{<span class="w">FileOkay</span>}[<span class="i">$Index</span>] = <span class="n">0</span><span class="sc">;</span>
562 549 <span class="s">}</span>
563 550 <span class="s">}</span>
564 551 <span class="s">}</span>
565 552 <span class="s">}</span>
566 553 <span class="s">}</span>
567 554
568 555 <span class="c"># Process specified rows info...</span>
569 <a name="ProcessRowsInfo-"></a> 556 <span class="k">sub </span><span class="m">ProcessRowsInfo</span> <span class="s">{</span>
570 557 <span class="k">my</span><span class="s">(</span><span class="i">$Index</span><span class="cm">,</span> <span class="i">$TextFile</span><span class="cm">,</span> <span class="i">$ColID</span><span class="cm">,</span> <span class="i">$ColIDOkay</span><span class="cm">,</span> <span class="i">$Value</span><span class="cm">,</span> <span class="i">$Criterion</span><span class="cm">,</span> <span class="i">$ColNum</span><span class="cm">,</span> <span class="i">@RowValues</span><span class="s">)</span><span class="sc">;</span>
571 558
572 559 <span class="i">@</span>{<span class="i">$TextFilesInfo</span>{<span class="w">RowValues</span>}} = <span class="s">(</span><span class="s">)</span><span class="sc">;</span>
573 560
574 561 <span class="j">FILELIST:</span> <span class="k">for</span> <span class="i">$Index</span> <span class="s">(</span><span class="n">0</span> .. <span class="i">$#TextFilesList</span><span class="s">)</span> <span class="s">{</span>
575 562 <span class="i">$TextFile</span> = <span class="i">$TextFilesList</span>[<span class="i">$Index</span>]<span class="sc">;</span>
576 563 <span class="i">@</span>{<span class="i">$TextFilesInfo</span>{<span class="w">RowValues</span>}[<span class="i">$Index</span>]} = <span class="s">(</span><span class="s">)</span><span class="sc">;</span>
577 564
578 565 <span class="k">if</span> <span class="s">(</span><span class="i">$OptionsInfo</span>{<span class="w">Mode</span>} !~ <span class="q">/^rows$/i</span><span class="s">)</span> <span class="s">{</span>
579 566 <span class="k">next</span> <span class="j">FILELIST</span><span class="sc">;</span>
580 567 <span class="s">}</span>
581 568 <span class="k">if</span> <span class="s">(</span>!<span class="i">$TextFilesInfo</span>{<span class="w">FileOkay</span>}[<span class="i">$Index</span>]<span class="s">)</span> <span class="s">{</span>
582 569 <span class="k">next</span> <span class="j">FILELIST</span><span class="sc">;</span>
583 570 <span class="s">}</span>
584 571
585 572 <span class="i">@RowValues</span> = <span class="s">(</span><span class="s">)</span><span class="sc">;</span>
586 573
587 574 <span class="k">if</span> <span class="s">(</span><span class="i">$OptionsInfo</span>{<span class="w">RowsMode</span>} =~ <span class="q">/^rowsbycolvalue$/i</span><span class="s">)</span> <span class="s">{</span>
588 575 <span class="k">my</span><span class="s">(</span><span class="i">$ValueIndex</span><span class="s">)</span><span class="sc">;</span>
589 576 <span class="k">for</span> <span class="s">(</span><span class="i">$ValueIndex</span> = <span class="n">0</span><span class="sc">;</span> <span class="i">$ValueIndex</span> &lt; <span class="i">@</span>{<span class="i">$OptionsInfo</span>{<span class="w">SpecifiedRowValues</span>}}<span class="sc">;</span> <span class="i">$ValueIndex</span> = <span class="i">$ValueIndex</span> + <span class="n">3</span><span class="s">)</span> <span class="s">{</span>
590 577 <span class="i">$ColID</span> = <span class="i">$OptionsInfo</span>{<span class="w">SpecifiedRowValues</span>}[<span class="i">$ValueIndex</span>]<span class="sc">;</span>
591 578 <span class="i">$Value</span> = <span class="i">$OptionsInfo</span>{<span class="w">SpecifiedRowValues</span>}[<span class="i">$ValueIndex</span> + <span class="n">1</span>]<span class="sc">;</span>
592 579 <span class="i">$Criterion</span> = <span class="i">$OptionsInfo</span>{<span class="w">SpecifiedRowValues</span>}[<span class="i">$ValueIndex</span> + <span class="n">2</span>]<span class="sc">;</span>
593 580
594 581 <span class="i">$ColIDOkay</span> = <span class="n">0</span><span class="sc">;</span>
595 582 <span class="k">if</span> <span class="s">(</span><span class="i">$OptionsInfo</span>{<span class="w">ColMode</span>} =~ <span class="q">/^collabel$/i</span><span class="s">)</span> <span class="s">{</span>
596 583 <span class="k">if</span> <span class="s">(</span><span class="k">exists</span> <span class="i">$TextFilesInfo</span>{<span class="w">ColLabelToNumMap</span>}[<span class="i">$Index</span>]{<span class="i">$ColID</span>}<span class="s">)</span> <span class="s">{</span>
597 584 <span class="i">$ColIDOkay</span> = <span class="n">1</span><span class="sc">;</span>
598 585 <span class="i">$ColNum</span> = <span class="i">$TextFilesInfo</span>{<span class="w">ColLabelToNumMap</span>}[<span class="i">$Index</span>]{<span class="i">$ColID</span>}<span class="sc">;</span>
599 586 <span class="s">}</span>
600 587 <span class="s">}</span>
601 588 <span class="k">else</span> <span class="s">{</span>
602 589 <span class="k">if</span> <span class="s">(</span><span class="i">$ColID</span> &gt;=<span class="n">1</span> &amp;&amp; <span class="i">$ColID</span> &lt;= <span class="i">$TextFilesInfo</span>{<span class="w">ColCount</span>}[<span class="i">$Index</span>]<span class="s">)</span> <span class="s">{</span>
603 590 <span class="i">$ColNum</span> = <span class="i">$ColID</span> - <span class="n">1</span><span class="sc">;</span>
604 591 <span class="i">$ColIDOkay</span> = <span class="n">1</span><span class="sc">;</span>
605 592 <span class="s">}</span>
606 593 <span class="s">}</span>
607 594 <span class="k">if</span> <span class="s">(</span><span class="i">$ColIDOkay</span><span class="s">)</span> <span class="s">{</span>
608 595 <span class="k">push</span> <span class="i">@RowValues</span><span class="cm">,</span> <span class="s">(</span><span class="i">$ColNum</span><span class="cm">,</span> <span class="i">$Value</span><span class="cm">,</span> <span class="i">$Criterion</span><span class="s">)</span><span class="sc">;</span>
609 596 <span class="s">}</span>
610 597 <span class="s">}</span>
611 598 <span class="s">}</span>
612 599 <span class="k">elsif</span> <span class="s">(</span><span class="i">$OptionsInfo</span>{<span class="w">RowsMode</span>} =~ <span class="q">/^(rowsbycolvaluelist|rowsbycolvaluerange|rowbymincolvalue|rowbymaxcolvalue)$/i</span><span class="s">)</span> <span class="s">{</span>
613 600 <span class="c"># Process coulumn id...</span>
614 601 <span class="i">$ColID</span> = <span class="i">$OptionsInfo</span>{<span class="w">SpecifiedRowValues</span>}[<span class="n">0</span>]<span class="sc">;</span>
615 602 <span class="i">$ColIDOkay</span> = <span class="n">0</span><span class="sc">;</span>
616 603
617 604 <span class="k">if</span> <span class="s">(</span><span class="i">$OptionsInfo</span>{<span class="w">ColMode</span>} =~ <span class="q">/^collabel$/i</span><span class="s">)</span> <span class="s">{</span>
618 605 <span class="k">if</span> <span class="s">(</span><span class="k">exists</span> <span class="i">$TextFilesInfo</span>{<span class="w">ColLabelToNumMap</span>}[<span class="i">$Index</span>]{<span class="i">$ColID</span>}<span class="s">)</span> <span class="s">{</span>
619 606 <span class="i">$ColIDOkay</span> = <span class="n">1</span><span class="sc">;</span>
620 607 <span class="i">$ColNum</span> = <span class="i">$TextFilesInfo</span>{<span class="w">ColLabelToNumMap</span>}[<span class="i">$Index</span>]{<span class="i">$ColID</span>}<span class="sc">;</span>
621 608 <span class="s">}</span>
622 609 <span class="s">}</span>
623 610 <span class="k">else</span> <span class="s">{</span>
624 611 <span class="k">if</span> <span class="s">(</span><span class="i">$ColID</span> &gt;=<span class="n">1</span> &amp;&amp; <span class="i">$ColID</span> &lt;= <span class="i">$TextFilesInfo</span>{<span class="w">ColCount</span>}[<span class="i">$Index</span>]<span class="s">)</span> <span class="s">{</span>
625 612 <span class="i">$ColIDOkay</span> = <span class="n">1</span><span class="sc">;</span>
626 613 <span class="i">$ColNum</span> = <span class="i">$ColID</span> - <span class="n">1</span><span class="sc">;</span>
627 614 <span class="s">}</span>
628 615 <span class="s">}</span>
629 616 <span class="k">if</span> <span class="s">(</span><span class="i">$ColIDOkay</span><span class="s">)</span> <span class="s">{</span>
630 617 <span class="k">push</span> <span class="i">@RowValues</span><span class="cm">,</span> <span class="i">$ColNum</span><span class="sc">;</span>
631 618 <span class="c"># Get rest of the specified values...</span>
632 619 <span class="k">if</span> <span class="s">(</span><span class="i">@</span>{<span class="i">$OptionsInfo</span>{<span class="w">SpecifiedRowValues</span>}} &gt; <span class="n">1</span><span class="s">)</span> <span class="s">{</span>
633 620 <span class="k">for</span> <span class="i">$Index</span> <span class="s">(</span><span class="n">1</span> .. <span class="i">$#</span>{<span class="i">$OptionsInfo</span>{<span class="w">SpecifiedRowValues</span>}}<span class="s">)</span> <span class="s">{</span>
634 621 <span class="k">push</span> <span class="i">@RowValues</span><span class="cm">,</span> <span class="i">$OptionsInfo</span>{<span class="w">SpecifiedRowValues</span>}[<span class="i">$Index</span>]<span class="sc">;</span>
635 622 <span class="s">}</span>
636 623 <span class="s">}</span>
637 624 <span class="s">}</span>
638 625 <span class="s">}</span>
639 626 <span class="k">elsif</span> <span class="s">(</span><span class="i">$OptionsInfo</span>{<span class="w">RowsMode</span>} =~ <span class="q">/^(rownums|rownumrange)$/i</span><span class="s">)</span> <span class="s">{</span>
640 627 <span class="k">push</span> <span class="i">@RowValues</span><span class="cm">,</span> <span class="i">@</span>{<span class="i">$OptionsInfo</span>{<span class="w">SpecifiedRowValues</span>}}<span class="sc">;</span>
641 628 <span class="s">}</span>
642 629
643 630 <span class="k">if</span> <span class="s">(</span><span class="i">@RowValues</span><span class="s">)</span> <span class="s">{</span>
644 631 <span class="k">push</span> <span class="i">@</span>{<span class="i">$TextFilesInfo</span>{<span class="w">RowValues</span>}[<span class="i">$Index</span>]}<span class="cm">,</span> <span class="i">@RowValues</span><span class="sc">;</span>
645 632 <span class="s">}</span>
646 633 <span class="k">else</span> <span class="s">{</span>
647 634 <span class="k">warn</span> <span class="q">&quot;Warning: Ignoring file $TextFile: Column specified, $ColID, using \&quot;--rows\&quot; option doesn&#39;t exist\n&quot;</span><span class="sc">;</span>
648 635 <span class="i">$TextFilesInfo</span>{<span class="w">FileOkay</span>}[<span class="i">$Index</span>] = <span class="n">0</span><span class="sc">;</span>
649 636 <span class="s">}</span>
650 637 <span class="s">}</span>
651 638 <span class="s">}</span>
652 639
653 640 <span class="c"># Retrieve information about input text files...</span>
654 <a name="RetrieveTextFilesInfo-"></a> 641 <span class="k">sub </span><span class="m">RetrieveTextFilesInfo</span> <span class="s">{</span>
655 642 <span class="k">my</span><span class="s">(</span><span class="i">$Index</span><span class="cm">,</span> <span class="i">$TextFile</span><span class="cm">,</span> <span class="i">$FileDir</span><span class="cm">,</span> <span class="i">$FileName</span><span class="cm">,</span> <span class="i">$FileExt</span><span class="cm">,</span> <span class="i">$InDelim</span><span class="cm">,</span> <span class="i">$Line</span><span class="cm">,</span> <span class="i">@ColLabels</span><span class="cm">,</span> <span class="i">$OutFileRoot</span><span class="cm">,</span> <span class="i">$CategoryOutFileRoot</span><span class="cm">,</span> <span class="i">$OutFile</span><span class="cm">,</span> <span class="i">$ColNum</span><span class="cm">,</span> <span class="i">$ColLabel</span><span class="s">)</span><span class="sc">;</span>
656 643
657 644 <span class="i">%TextFilesInfo</span> = <span class="s">(</span><span class="s">)</span><span class="sc">;</span>
658 645
659 646 <span class="i">@</span>{<span class="i">$TextFilesInfo</span>{<span class="w">FileOkay</span>}} = <span class="s">(</span><span class="s">)</span><span class="sc">;</span>
660 647 <span class="i">@</span>{<span class="i">$TextFilesInfo</span>{<span class="w">ColCount</span>}} = <span class="s">(</span><span class="s">)</span><span class="sc">;</span>
661 648 <span class="i">@</span>{<span class="i">$TextFilesInfo</span>{<span class="w">ColLabels</span>}} = <span class="s">(</span><span class="s">)</span><span class="sc">;</span>
662 649 <span class="i">@</span>{<span class="i">$TextFilesInfo</span>{<span class="w">ColLabelToNumMap</span>}} = <span class="s">(</span><span class="s">)</span><span class="sc">;</span>
663 650 <span class="i">@</span>{<span class="i">$TextFilesInfo</span>{<span class="w">InDelim</span>}} = <span class="s">(</span><span class="s">)</span><span class="sc">;</span>
664 651 <span class="i">@</span>{<span class="i">$TextFilesInfo</span>{<span class="w">OutFile</span>}} = <span class="s">(</span><span class="s">)</span><span class="sc">;</span>
665 652 <span class="i">@</span>{<span class="i">$TextFilesInfo</span>{<span class="w">OutFileExt</span>}} = <span class="s">(</span><span class="s">)</span><span class="sc">;</span>
666 653 <span class="i">@</span>{<span class="i">$TextFilesInfo</span>{<span class="w">CategoryOutFileRoot</span>}} = <span class="s">(</span><span class="s">)</span><span class="sc">;</span>
667 654
668 655 <span class="j">FILELIST:</span> <span class="k">for</span> <span class="i">$Index</span> <span class="s">(</span><span class="n">0</span> .. <span class="i">$#TextFilesList</span><span class="s">)</span> <span class="s">{</span>
669 656 <span class="i">$TextFile</span> = <span class="i">$TextFilesList</span>[<span class="i">$Index</span>]<span class="sc">;</span>
670 657
671 658 <span class="i">$TextFilesInfo</span>{<span class="w">FileOkay</span>}[<span class="i">$Index</span>] = <span class="n">0</span><span class="sc">;</span>
672 659 <span class="i">$TextFilesInfo</span>{<span class="w">ColCount</span>}[<span class="i">$Index</span>] = <span class="n">0</span><span class="sc">;</span>
673 660 <span class="i">$TextFilesInfo</span>{<span class="w">InDelim</span>}[<span class="i">$Index</span>] = <span class="q">&quot;&quot;</span><span class="sc">;</span>
674 661 <span class="i">$TextFilesInfo</span>{<span class="w">OutFile</span>}[<span class="i">$Index</span>] = <span class="q">&quot;&quot;</span><span class="sc">;</span>
675 662 <span class="i">$TextFilesInfo</span>{<span class="w">OutFileExt</span>}[<span class="i">$Index</span>] = <span class="q">&quot;&quot;</span><span class="sc">;</span>
676 663 <span class="i">$TextFilesInfo</span>{<span class="w">CategoryOutFileRoot</span>}[<span class="i">$Index</span>] = <span class="q">&quot;&quot;</span><span class="sc">;</span>
677 664
678 665 <span class="i">@</span>{<span class="i">$TextFilesInfo</span>{<span class="w">ColLabels</span>}[<span class="i">$Index</span>]} = <span class="s">(</span><span class="s">)</span><span class="sc">;</span>
679 666 <span class="i">%</span>{<span class="i">$TextFilesInfo</span>{<span class="w">ColLabelToNumMap</span>}[<span class="i">$Index</span>]} = <span class="s">(</span><span class="s">)</span><span class="sc">;</span>
680 667
681 668 <span class="k">if</span> <span class="s">(</span>!<span class="s">(</span><span class="k">-e</span> <span class="i">$TextFile</span><span class="s">)</span><span class="s">)</span> <span class="s">{</span>
682 669 <span class="k">warn</span> <span class="q">&quot;Warning: Ignoring file $TextFile: It doesn&#39;t exist\n&quot;</span><span class="sc">;</span>
683 670 <span class="k">next</span> <span class="j">FILELIST</span><span class="sc">;</span>
684 671 <span class="s">}</span>
685 672 <span class="k">if</span> <span class="s">(</span>!<span class="i">CheckFileType</span><span class="s">(</span><span class="i">$TextFile</span><span class="cm">,</span> <span class="q">&quot;csv tsv&quot;</span><span class="s">)</span><span class="s">)</span> <span class="s">{</span>
686 673 <span class="k">warn</span> <span class="q">&quot;Warning: Ignoring file $TextFile: It&#39;s not a csv or tsv file\n&quot;</span><span class="sc">;</span>
687 674 <span class="k">next</span> <span class="j">FILELIST</span><span class="sc">;</span>
688 675 <span class="s">}</span>
689 676
690 677 <span class="s">(</span><span class="i">$FileDir</span><span class="cm">,</span> <span class="i">$FileName</span><span class="cm">,</span> <span class="i">$FileExt</span><span class="s">)</span> = <span class="i">ParseFileName</span><span class="s">(</span><span class="i">$TextFile</span><span class="s">)</span><span class="sc">;</span>
691 678 <span class="k">if</span> <span class="s">(</span><span class="i">$FileExt</span> =~ <span class="q">/^tsv$/i</span><span class="s">)</span> <span class="s">{</span>
692 679 <span class="i">$InDelim</span> = <span class="q">&quot;\t&quot;</span><span class="sc">;</span>
693 680 <span class="s">}</span>
694 681 <span class="k">else</span> <span class="s">{</span>
695 682 <span class="i">$InDelim</span> = <span class="q">&quot;\,&quot;</span><span class="sc">;</span>
696 683 <span class="k">if</span> <span class="s">(</span>!<span class="s">(</span><span class="i">$OptionsInfo</span>{<span class="w">InDelim</span>} =~ <span class="q">/^(comma|semicolon)$/i</span><span class="s">)</span><span class="s">)</span> <span class="s">{</span>
697 684 <span class="k">warn</span> <span class="q">&quot;Warning: Ignoring file $TextFile: The value specified, $OptionsInfo{InDelim}, for option \&quot;--indelim\&quot; is not valid for csv files\n&quot;</span><span class="sc">;</span>
698 685 <span class="k">next</span> <span class="j">FILELIST</span><span class="sc">;</span>
699 686 <span class="s">}</span>
700 687 <span class="k">if</span> <span class="s">(</span><span class="i">$OptionsInfo</span>{<span class="w">InDelim</span>} =~ <span class="q">/^semicolon$/i</span><span class="s">)</span> <span class="s">{</span>
701 688 <span class="i">$InDelim</span> = <span class="q">&quot;\;&quot;</span><span class="sc">;</span>
702 689 <span class="s">}</span>
703 690 <span class="s">}</span>
704 691
705 692 <span class="k">if</span> <span class="s">(</span>!<span class="k">open</span> <span class="w">TEXTFILE</span><span class="cm">,</span> <span class="q">&quot;$TextFile&quot;</span><span class="s">)</span> <span class="s">{</span>
706 693 <span class="k">warn</span> <span class="q">&quot;Warning: Ignoring file $TextFile: Couldn&#39;t open it: $! \n&quot;</span><span class="sc">;</span>
707 694 <span class="k">next</span> <span class="j">FILELIST</span><span class="sc">;</span>
708 695 <span class="s">}</span>
709 696
710 697 <span class="i">$Line</span> = <span class="i">GetTextLine</span><span class="s">(</span>\<span class="i">*TEXTFILE</span><span class="s">)</span><span class="sc">;</span>
711 698 <span class="i">@ColLabels</span> = <span class="i">quotewords</span><span class="s">(</span><span class="i">$InDelim</span><span class="cm">,</span> <span class="n">0</span><span class="cm">,</span> <span class="i">$Line</span><span class="s">)</span><span class="sc">;</span>
712 699 <span class="k">close</span> <span class="w">TEXTFILE</span><span class="sc">;</span>
713 700
714 701 <span class="i">$FileDir</span> = <span class="q">&quot;&quot;</span><span class="sc">;</span> <span class="i">$FileName</span> = <span class="q">&quot;&quot;</span><span class="sc">;</span> <span class="i">$FileExt</span> = <span class="q">&quot;&quot;</span><span class="sc">;</span>
715 702 <span class="s">(</span><span class="i">$FileDir</span><span class="cm">,</span> <span class="i">$FileName</span><span class="cm">,</span> <span class="i">$FileExt</span><span class="s">)</span> = <span class="i">ParseFileName</span><span class="s">(</span><span class="i">$TextFile</span><span class="s">)</span><span class="sc">;</span>
716 703 <span class="i">$FileExt</span> = <span class="q">&quot;csv&quot;</span><span class="sc">;</span>
717 704 <span class="k">if</span> <span class="s">(</span><span class="i">$OptionsInfo</span>{<span class="w">OutDelim</span>} =~ <span class="q">/^tab$/i</span><span class="s">)</span> <span class="s">{</span>
718 705 <span class="i">$FileExt</span> = <span class="q">&quot;tsv&quot;</span><span class="sc">;</span>
719 706 <span class="s">}</span>
720 707
721 708 <span class="k">if</span> <span class="s">(</span><span class="i">$OptionsInfo</span>{<span class="w">OutFileRoot</span>} &amp;&amp; <span class="s">(</span><span class="i">@TextFilesList</span> == <span class="n">1</span><span class="s">)</span><span class="s">)</span> <span class="s">{</span>
722 709 <span class="k">my</span> <span class="s">(</span><span class="i">$RootFileDir</span><span class="cm">,</span> <span class="i">$RootFileName</span><span class="cm">,</span> <span class="i">$RootFileExt</span><span class="s">)</span> = <span class="i">ParseFileName</span><span class="s">(</span><span class="i">$OptionsInfo</span>{<span class="w">OutFileRoot</span>}<span class="s">)</span><span class="sc">;</span>
723 710 <span class="k">if</span> <span class="s">(</span><span class="i">$RootFileName</span> &amp;&amp; <span class="i">$RootFileExt</span><span class="s">)</span> <span class="s">{</span>
724 711 <span class="i">$FileName</span> = <span class="i">$RootFileName</span><span class="sc">;</span>
725 712 <span class="s">}</span>
726 713 <span class="k">else</span> <span class="s">{</span>
727 714 <span class="i">$FileName</span> = <span class="i">$OptionsInfo</span>{<span class="w">OutFileRoot</span>}<span class="sc">;</span>
728 715 <span class="s">}</span>
729 716 <span class="i">$OutFileRoot</span> .= <span class="i">$FileName</span><span class="sc">;</span>
730 717 <span class="s">}</span>
731 718 <span class="k">else</span> <span class="s">{</span>
732 719 <span class="i">$OutFileRoot</span> = <span class="i">$FileName</span><span class="sc">;</span>
733 720 <span class="i">$OutFileRoot</span> .= <span class="s">(</span><span class="i">$OptionsInfo</span>{<span class="w">Mode</span>} =~ <span class="q">/^categories$/i</span><span class="s">)</span> ? <span class="q">&quot;CategoriesSummary&quot;</span> <span class="co">:</span> <span class="s">(</span><span class="s">(</span><span class="i">$OptionsInfo</span>{<span class="w">Mode</span>} =~ <span class="q">/^rows$/i</span><span class="s">)</span> ? <span class="q">&quot;ExtractedRows&quot;</span> <span class="co">:</span> <span class="q">&quot;ExtractedColumns&quot;</span><span class="s">)</span><span class="sc">;</span>
734 721 <span class="s">}</span>
735 722 <span class="i">$CategoryOutFileRoot</span> = <span class="q">&quot;$FileName&quot;</span> . <span class="q">&quot;Category&quot;</span><span class="sc">;</span>
736 723
737 724 <span class="i">$OutFile</span> = <span class="i">$OutFileRoot</span> . <span class="q">&quot;.$FileExt&quot;</span><span class="sc">;</span>
738 725 <span class="k">if</span> <span class="s">(</span><span class="k">lc</span><span class="s">(</span><span class="i">$OutFile</span><span class="s">)</span> <span class="k">eq</span> <span class="k">lc</span><span class="s">(</span><span class="i">$TextFile</span><span class="s">)</span><span class="s">)</span> <span class="s">{</span>
739 726 <span class="k">warn</span> <span class="q">&quot;Warning: Ignoring file $TextFile:Output file name, $OutFile, is same as input text file name, $TextFile\n&quot;</span><span class="sc">;</span>
740 727 <span class="k">next</span> <span class="j">FILELIST</span><span class="sc">;</span>
741 728 <span class="s">}</span>
742 729
743 730 <span class="k">if</span> <span class="s">(</span>!<span class="i">$OptionsInfo</span>{<span class="w">Overwrite</span>}<span class="s">)</span> <span class="s">{</span>
744 731 <span class="k">if</span> <span class="s">(</span><span class="k">-e</span> <span class="i">$OutFile</span><span class="s">)</span> <span class="s">{</span>
745 732 <span class="k">warn</span> <span class="q">&quot;Warning: Ignoring file $TextFile: The file $OutFile already exists\n&quot;</span><span class="sc">;</span>
746 733 <span class="k">next</span> <span class="j">FILELIST</span><span class="sc">;</span>
747 734 <span class="s">}</span>
748 735 <span class="s">}</span>
749 736
750 737 <span class="i">$TextFilesInfo</span>{<span class="w">FileOkay</span>}[<span class="i">$Index</span>] = <span class="n">1</span><span class="sc">;</span>
751 738 <span class="i">$TextFilesInfo</span>{<span class="w">InDelim</span>}[<span class="i">$Index</span>] = <span class="i">$InDelim</span><span class="sc">;</span>
752 739 <span class="i">$TextFilesInfo</span>{<span class="w">CategoryOutFileRoot</span>}[<span class="i">$Index</span>] = <span class="i">$CategoryOutFileRoot</span><span class="sc">;</span>
753 740 <span class="i">$TextFilesInfo</span>{<span class="w">OutFile</span>}[<span class="i">$Index</span>] = <span class="q">&quot;$OutFile&quot;</span><span class="sc">;</span>
754 741 <span class="i">$TextFilesInfo</span>{<span class="w">OutFileExt</span>}[<span class="i">$Index</span>] = <span class="q">&quot;$FileExt&quot;</span><span class="sc">;</span>
755 742
756 743 <span class="i">$TextFilesInfo</span>{<span class="w">ColCount</span>}[<span class="i">$Index</span>] = <span class="i">@ColLabels</span><span class="sc">;</span>
757 744 <span class="k">push</span> <span class="i">@</span>{<span class="i">$TextFilesInfo</span>{<span class="w">ColLabels</span>}[<span class="i">$Index</span>]}<span class="cm">,</span> <span class="i">@ColLabels</span><span class="sc">;</span>
758 745
759 746 <span class="k">for</span> <span class="i">$ColNum</span> <span class="s">(</span><span class="n">0</span> .. <span class="i">$#ColLabels</span><span class="s">)</span> <span class="s">{</span>
760 747 <span class="i">$ColLabel</span> = <span class="i">$ColLabels</span>[<span class="i">$ColNum</span>]<span class="sc">;</span>
761 748 <span class="i">$TextFilesInfo</span>{<span class="w">ColLabelToNumMap</span>}[<span class="i">$Index</span>]{<span class="i">$ColLabel</span>} = <span class="i">$ColNum</span><span class="sc">;</span>
762 749 <span class="s">}</span>
763 750 <span class="s">}</span>
764 751 <span class="s">}</span>
765 752
766 753 <span class="c"># Process option values...</span>
767 <a name="ProcessOptions-"></a> 754 <span class="k">sub </span><span class="m">ProcessOptions</span> <span class="s">{</span>
768 755 <span class="k">my</span><span class="s">(</span><span class="i">@SpecifiedColumns</span><span class="cm">,</span> <span class="i">@SpecifiedRowValues</span><span class="s">)</span><span class="sc">;</span>
769 756
770 757 <span class="i">%OptionsInfo</span> = <span class="s">(</span><span class="s">)</span><span class="sc">;</span>
771 758
772 759 <span class="i">$OptionsInfo</span>{<span class="w">Mode</span>} = <span class="i">$Options</span>{<span class="w">mode</span>}<span class="sc">;</span>
773 760
774 761 <span class="i">$OptionsInfo</span>{<span class="w">ColMode</span>} = <span class="i">$Options</span>{<span class="w">colmode</span>}<span class="sc">;</span>
775 762
776 763 <span class="i">$OptionsInfo</span>{<span class="w">CategoryCol</span>} = <span class="k">defined</span> <span class="i">$Options</span>{<span class="w">categorycol</span>} ? <span class="i">$Options</span>{<span class="w">categorycol</span>} <span class="co">:</span> <span class="k">undef</span><span class="sc">;</span>
777 764 <span class="i">$OptionsInfo</span>{<span class="w">SpecifiedCategoryCol</span>} = <span class="q">&quot;&quot;</span><span class="sc">;</span>
778 765
779 766 <span class="k">if</span> <span class="s">(</span><span class="k">defined</span> <span class="i">$Options</span>{<span class="w">categorycol</span>}<span class="s">)</span> <span class="s">{</span>
780 767 <span class="k">my</span><span class="s">(</span><span class="i">@SpecifiedValues</span><span class="s">)</span> = <span class="k">split</span> <span class="q">&quot;,&quot;</span><span class="cm">,</span> <span class="i">$Options</span>{<span class="w">categorycol</span>}<span class="sc">;</span>
781 768 <span class="k">if</span> <span class="s">(</span><span class="i">@SpecifiedValues</span> != <span class="n">1</span><span class="s">)</span> <span class="s">{</span>
782 769 <span class="k">die</span> <span class="q">&quot;Error: Invalid number of values, &quot;</span><span class="cm">,</span><span class="k">scalar</span><span class="s">(</span><span class="i">@SpecifiedValues</span><span class="s">)</span><span class="cm">,</span> <span class="q">&quot; using \&quot;--categorycol\&quot; option: Only one value is allowed.\n&quot;</span><span class="sc">;</span>
783 770 <span class="s">}</span>
784 771 <span class="i">$OptionsInfo</span>{<span class="w">SpecifiedCategoryCol</span>} = <span class="i">$SpecifiedValues</span>[<span class="n">0</span>]<span class="sc">;</span>
785 772 <span class="k">if</span> <span class="s">(</span><span class="i">$Options</span>{<span class="w">colmode</span>} =~ <span class="q">/^colnum$/i</span><span class="s">)</span> <span class="s">{</span>
786 773 <span class="k">if</span> <span class="s">(</span>!<span class="i">IsPositiveInteger</span><span class="s">(</span><span class="i">$OptionsInfo</span>{<span class="w">SpecifiedCategoryCol</span>}<span class="s">)</span><span class="s">)</span> <span class="s">{</span>
787 774 <span class="k">die</span> <span class="q">&quot;Error: Category column value, $OptionsInfo{SpecifiedCategoryCol}, specified using \&quot;--categorycol\&quot; is not valid. Allowed integer values: &gt; 0.\n&quot;</span><span class="sc">;</span>
788 775 <span class="s">}</span>
789 776 <span class="s">}</span>
790 777 <span class="s">}</span>
791 778
792 779 <span class="i">$OptionsInfo</span>{<span class="w">Columns</span>} = <span class="k">defined</span> <span class="i">$Options</span>{<span class="w">columns</span>} ? <span class="i">$Options</span>{<span class="w">columns</span>} <span class="co">:</span> <span class="k">undef</span><span class="sc">;</span>
793 780 <span class="i">@</span>{<span class="i">$OptionsInfo</span>{<span class="w">SpecifiedColumns</span>}} = <span class="s">(</span><span class="s">)</span><span class="sc">;</span>
794 781 <span class="i">@SpecifiedColumns</span> = <span class="s">(</span><span class="s">)</span><span class="sc">;</span>
795 782
796 783 <span class="k">if</span> <span class="s">(</span><span class="k">defined</span> <span class="i">$Options</span>{<span class="w">columns</span>}<span class="s">)</span> <span class="s">{</span>
797 784 <span class="k">my</span><span class="s">(</span><span class="i">@SpecifiedValues</span><span class="s">)</span> = <span class="k">split</span> <span class="q">&quot;,&quot;</span><span class="cm">,</span> <span class="i">$Options</span>{<span class="w">columns</span>}<span class="sc">;</span>
798 785 <span class="k">if</span> <span class="s">(</span><span class="i">$Options</span>{<span class="w">colmode</span>} =~ <span class="q">/^colnum$/i</span><span class="s">)</span> <span class="s">{</span>
799 786 <span class="k">my</span><span class="s">(</span><span class="i">$ColValue</span><span class="s">)</span><span class="sc">;</span>
800 787 <span class="k">for</span> <span class="i">$ColValue</span> <span class="s">(</span><span class="i">@SpecifiedValues</span><span class="s">)</span> <span class="s">{</span>
801 788 <span class="k">if</span> <span class="s">(</span>!<span class="i">IsPositiveInteger</span><span class="s">(</span><span class="i">$ColValue</span><span class="s">)</span><span class="s">)</span> <span class="s">{</span>
802 789 <span class="k">die</span> <span class="q">&quot;Error: Column value, $ColValue, specified using \&quot;--columns\&quot; is not valid: Allowed integer values: &gt; 0.\n&quot;</span><span class="sc">;</span>
803 790 <span class="s">}</span>
804 791 <span class="s">}</span>
805 792 <span class="s">}</span>
806 793 <span class="k">push</span> <span class="i">@SpecifiedColumns</span><span class="cm">,</span> <span class="i">@SpecifiedValues</span><span class="sc">;</span>
807 794 <span class="s">}</span>
808 795 <span class="i">@</span>{<span class="i">$OptionsInfo</span>{<span class="w">SpecifiedColumns</span>}} = <span class="i">@SpecifiedColumns</span><span class="sc">;</span>
809 796
810 797 <span class="i">$OptionsInfo</span>{<span class="w">InDelim</span>} = <span class="i">$Options</span>{<span class="w">indelim</span>}<span class="sc">;</span>
811 798
812 799 <span class="i">$OptionsInfo</span>{<span class="w">OutDelim</span>} = <span class="s">(</span><span class="i">$Options</span>{<span class="w">outdelim</span>} =~ <span class="q">/^tab$/i</span> <span class="s">)</span> ? <span class="q">&quot;\t&quot;</span> <span class="co">:</span> <span class="s">(</span><span class="s">(</span><span class="i">$Options</span>{<span class="w">outdelim</span>} =~ <span class="q">/^semicolon$/i</span><span class="s">)</span> ? <span class="q">&quot;\;&quot;</span> <span class="co">:</span> <span class="q">&quot;\,&quot;</span><span class="s">)</span><span class="sc">;</span>
813 800 <span class="i">$OptionsInfo</span>{<span class="w">OutQuote</span>} = <span class="s">(</span><span class="i">$Options</span>{<span class="w">quote</span>} =~ <span class="q">/^yes$/i</span><span class="s">)</span> ? <span class="n">1</span> <span class="co">:</span> <span class="n">0</span><span class="sc">;</span>
814 801 <span class="i">$OptionsInfo</span>{<span class="w">Overwrite</span>} = <span class="k">defined</span> <span class="i">$Options</span>{<span class="w">overwrite</span>} ? <span class="i">$Options</span>{<span class="w">overwrite</span>} <span class="co">:</span> <span class="k">undef</span><span class="sc">;</span>
815 802
816 803 <span class="i">$OptionsInfo</span>{<span class="w">OutFileRoot</span>} = <span class="k">defined</span> <span class="i">$Options</span>{<span class="w">root</span>} ? <span class="i">$Options</span>{<span class="w">root</span>} <span class="co">:</span> <span class="k">undef</span><span class="sc">;</span>
817 804
818 805 <span class="c"># Process any specified rows values...</span>
819 806 <span class="i">@SpecifiedRowValues</span> = <span class="s">(</span><span class="s">)</span><span class="sc">;</span>
820 807 <span class="i">@</span>{<span class="i">$OptionsInfo</span>{<span class="w">SpecifiedRowValues</span>}} = <span class="s">(</span><span class="s">)</span><span class="sc">;</span>
821 808
822 809 <span class="i">$OptionsInfo</span>{<span class="w">RowsMode</span>} = <span class="i">$Options</span>{<span class="w">rowsmode</span>}<span class="sc">;</span>
823 810 <span class="i">$OptionsInfo</span>{<span class="w">Rows</span>} = <span class="k">defined</span> <span class="i">$Options</span>{<span class="w">rows</span>} ? <span class="i">$Options</span>{<span class="w">rows</span>} <span class="co">:</span> <span class="k">undef</span><span class="sc">;</span>
824 811
825 812 <span class="i">$OptionsInfo</span>{<span class="w">SpecifiedRowsMode</span>} = <span class="i">$Options</span>{<span class="w">rowsmode</span>}<span class="sc">;</span>
826 813
827 814 <span class="k">if</span> <span class="s">(</span><span class="k">defined</span> <span class="i">$Options</span>{<span class="w">rows</span>}<span class="s">)</span> <span class="s">{</span>
828 815 <span class="s">(</span><span class="i">@SpecifiedRowValues</span><span class="s">)</span> = <span class="k">split</span> <span class="q">&quot;,&quot;</span><span class="cm">,</span> <span class="i">$Options</span>{<span class="w">rows</span>}<span class="sc">;</span>
829 816 <span class="s">}</span>
830 817 <span class="k">else</span> <span class="s">{</span>
831 818 <span class="k">if</span> <span class="s">(</span><span class="i">$Options</span>{<span class="w">rowsmode</span>} !~ <span class="q">/^rownums$/i</span><span class="s">)</span> <span class="s">{</span>
832 819 <span class="k">die</span> <span class="q">&quot;Error: Specify value for \&quot;--rows\&quot; option with \&quot;--rowsmode\&quot; value of $Options{rowsmode}.\n&quot;</span><span class="sc">;</span>
833 820 <span class="s">}</span>
834 821 <span class="k">push</span> <span class="i">@SpecifiedRowValues</span><span class="cm">,</span> <span class="q">&quot;1&quot;</span><span class="sc">;</span>
835 822 <span class="s">}</span>
836 823 <span class="i">@</span>{<span class="i">$OptionsInfo</span>{<span class="w">SpecifiedRowValues</span>}} = <span class="i">@SpecifiedRowValues</span><span class="sc">;</span>
837 824
838 825 <span class="k">my</span><span class="s">(</span><span class="i">$SpecifiedColID</span><span class="cm">,</span> <span class="i">$SpecifiedRowID</span><span class="s">)</span><span class="sc">;</span>
839 826 <span class="c"># Make sure specified values are okay...</span>
840 827 <span class="k">if</span> <span class="s">(</span><span class="i">$Options</span>{<span class="w">rowsmode</span>} =~ <span class="q">/^rowsbycolvalue$/i</span><span class="s">)</span> <span class="s">{</span>
841 828 <span class="k">if</span> <span class="s">(</span><span class="i">@SpecifiedRowValues</span> % <span class="n">3</span><span class="s">)</span> <span class="s">{</span>
842 829 <span class="k">die</span> <span class="q">&quot;Error: Invalid number of values, &quot;</span><span class="cm">,</span> <span class="k">scalar</span><span class="s">(</span><span class="i">@SpecifiedRowValues</span><span class="s">)</span> <span class="cm">,</span> <span class="q">&quot;, specified by \&quot;--rows\&quot; option with \&quot;--rowsmode\&quot; value of $Options{rowsmode}.\nIt must contain triplets.\n&quot;</span><span class="sc">;</span>
843 830 <span class="s">}</span>
844 831 <span class="c"># Triplet format: colid,value,criteria. Criterion: le,ge,eq</span>
845 832 <span class="k">my</span><span class="s">(</span><span class="i">$Index</span><span class="cm">,</span> <span class="i">$ColID</span><span class="cm">,</span> <span class="i">$Criterion</span><span class="cm">,</span> <span class="i">$Value</span><span class="s">)</span><span class="sc">;</span>
846 833 <span class="k">for</span> <span class="s">(</span><span class="i">$Index</span> = <span class="n">0</span><span class="sc">;</span> <span class="i">$Index</span> &lt; <span class="i">@SpecifiedRowValues</span><span class="sc">;</span> <span class="i">$Index</span> = <span class="i">$Index</span> + <span class="n">3</span><span class="s">)</span> <span class="s">{</span>
847 834 <span class="i">$ColID</span> = <span class="i">$SpecifiedRowValues</span>[<span class="i">$Index</span>]<span class="sc">;</span>
848 835 <span class="i">$Value</span> = <span class="i">$SpecifiedRowValues</span>[<span class="i">$Index</span> + <span class="n">1</span>]<span class="sc">;</span>
849 836 <span class="i">$Criterion</span> = <span class="i">$SpecifiedRowValues</span>[<span class="i">$Index</span> + <span class="n">2</span>]<span class="sc">;</span>
850 837 <span class="k">if</span> <span class="s">(</span><span class="i">$Options</span>{<span class="w">colmode</span>} =~ <span class="q">/^colnum$/i</span><span class="s">)</span> <span class="s">{</span>
851 838 <span class="k">if</span> <span class="s">(</span>!<span class="i">IsPositiveInteger</span><span class="s">(</span><span class="i">$ColID</span><span class="s">)</span><span class="s">)</span> <span class="s">{</span>
852 839 <span class="k">die</span> <span class="q">&quot;Error: Invalid column id, $ColID, specified in triplet, \&quot;$ColID,$Criterion,$Value\&quot;, using \&quot;--rows\&quot; option with \&quot;--rowsmode\&quot; value of $Options{rowsmode} is not valid. Allowed integer values: &gt; 0.\n&quot;</span><span class="sc">;</span>
853 840 <span class="s">}</span>
854 841 <span class="s">}</span>
855 842 <span class="k">if</span> <span class="s">(</span><span class="i">$Criterion</span> !~ <span class="q">/^(eq|le|ge)$/i</span><span class="s">)</span> <span class="s">{</span>
856 843 <span class="k">die</span> <span class="q">&quot;Error: Invalid criterion value, $Criterion, specified in triplet, \&quot;$ColID,$Criterion,$Value\&quot;, using \&quot;--rows\&quot; option with \&quot;--rowsmode\&quot; value of $Options{rowsmode} is not valid. Allowed values: le, ge, or eq.\n&quot;</span><span class="sc">;</span>
857 844 <span class="s">}</span>
858 845 <span class="s">}</span>
859 846 <span class="s">}</span>
860 847 <span class="k">elsif</span> <span class="s">(</span><span class="i">$Options</span>{<span class="w">rowsmode</span>} =~ <span class="q">/^rowsbycolvaluelist$/i</span><span class="s">)</span> <span class="s">{</span>
861 848 <span class="s">(</span><span class="i">$SpecifiedColID</span><span class="s">)</span> = <span class="i">$SpecifiedRowValues</span>[<span class="n">0</span>]<span class="sc">;</span>
862 849 <span class="k">if</span> <span class="s">(</span><span class="i">$Options</span>{<span class="w">colmode</span>} =~ <span class="q">/^colnum$/i</span><span class="s">)</span> <span class="s">{</span>
863 850 <span class="k">if</span> <span class="s">(</span>!<span class="i">IsPositiveInteger</span><span class="s">(</span><span class="i">$SpecifiedColID</span><span class="s">)</span><span class="s">)</span> <span class="s">{</span>
864 851 <span class="k">die</span> <span class="q">&quot;Error: Rows value, $SpecifiedColID, specified using \&quot;--rows\&quot; option with \&quot;--rowsmode\&quot; value of $Options{rowsmode} is not valid. Allowed integer values: &gt; 0.\n&quot;</span><span class="sc">;</span>
865 852 <span class="s">}</span>
866 853 <span class="s">}</span>
867 854 <span class="k">if</span> <span class="s">(</span><span class="i">@SpecifiedRowValues</span> == <span class="n">1</span><span class="s">)</span> <span class="s">{</span>
868 855 <span class="k">die</span> <span class="q">&quot;Error: Invalid number of values, &quot;</span><span class="cm">,</span> <span class="k">scalar</span><span class="s">(</span><span class="i">@SpecifiedRowValues</span><span class="s">)</span> <span class="cm">,</span> <span class="q">&quot;, specified by \&quot;--rows\&quot; option with \&quot;--rowsmode\&quot; value of $Options{rowsmode}.\nIt must contain more than one value\n&quot;</span><span class="sc">;</span>
869 856 <span class="s">}</span>
870 857 <span class="s">}</span>
871 858 <span class="k">elsif</span> <span class="s">(</span><span class="i">$Options</span>{<span class="w">rowsmode</span>} =~ <span class="q">/^rowsbycolvaluerange$/i</span><span class="s">)</span> <span class="s">{</span>
872 859 <span class="k">if</span> <span class="s">(</span><span class="i">@SpecifiedRowValues</span> != <span class="n">3</span><span class="s">)</span> <span class="s">{</span>
873 860 <span class="k">die</span> <span class="q">&quot;Error: Invalid number of values, &quot;</span><span class="cm">,</span> <span class="k">scalar</span><span class="s">(</span><span class="i">@SpecifiedRowValues</span><span class="s">)</span> <span class="cm">,</span> <span class="q">&quot;, specified by \&quot;--rows\&quot; option with \&quot;--rowsmode\&quot; value of $Options{rowsmode}.\nIt must contain three values\n&quot;</span><span class="sc">;</span>
874 861 <span class="s">}</span>
875 862 <span class="s">(</span><span class="i">$SpecifiedColID</span><span class="s">)</span> = <span class="i">$SpecifiedRowValues</span>[<span class="n">0</span>]<span class="sc">;</span>
876 863 <span class="k">if</span> <span class="s">(</span><span class="i">$Options</span>{<span class="w">colmode</span>} =~ <span class="q">/^colnum$/i</span><span class="s">)</span> <span class="s">{</span>
877 864 <span class="k">if</span> <span class="s">(</span>!<span class="i">IsPositiveInteger</span><span class="s">(</span><span class="i">$SpecifiedColID</span><span class="s">)</span><span class="s">)</span> <span class="s">{</span>
878 865 <span class="k">die</span> <span class="q">&quot;Error: Rows value, $SpecifiedColID, specified using \&quot;--rows\&quot; option with \&quot;--rowsmode\&quot; value of $Options{rowsmode} is not valid. Allowed integer values: &gt; 0.\n&quot;</span><span class="sc">;</span>
879 866 <span class="s">}</span>
880 867 <span class="s">}</span>
881 868 <span class="k">if</span> <span class="s">(</span><span class="i">$SpecifiedRowValues</span>[<span class="n">1</span>] &gt;= <span class="i">$SpecifiedRowValues</span>[<span class="n">2</span>]<span class="s">)</span> <span class="s">{</span>
882 869 <span class="k">die</span> <span class="q">&quot;Error: Invalid value triplet - &quot;</span><span class="cm">,</span> <span class="i">JoinWords</span><span class="s">(</span>\<span class="i">@SpecifiedRowValues</span><span class="cm">,</span> <span class="q">&#39;,&#39;</span><span class="cm">,</span> <span class="n">0</span><span class="s">)</span> <span class="cm">,</span> <span class="q">&quot; - specified by \&quot;--rows\&quot; option with \&quot;--rowsmode\&quot; value of $Options{rowsmode}.\nAllowed values: second value &lt; third value\n&quot;</span><span class="sc">;</span>
883 870 <span class="s">}</span>
884 871 <span class="s">}</span>
885 872 <span class="k">elsif</span> <span class="s">(</span><span class="i">$Options</span>{<span class="w">rowsmode</span>} =~ <span class="q">/^(rowbymincolvalue|rowbymaxcolvalue)$/i</span><span class="s">)</span> <span class="s">{</span>
886 873 <span class="k">if</span> <span class="s">(</span><span class="i">@SpecifiedRowValues</span> != <span class="n">1</span><span class="s">)</span> <span class="s">{</span>
887 874 <span class="k">die</span> <span class="q">&quot;Error: Invalid number of values, &quot;</span><span class="cm">,</span> <span class="k">scalar</span><span class="s">(</span><span class="i">@SpecifiedRowValues</span><span class="s">)</span> <span class="cm">,</span> <span class="q">&quot;, specified by \&quot;--rows\&quot; option with \&quot;--rowsmode\&quot; value of $Options{rowsmode}.\nOnly one value is allowed.\n&quot;</span><span class="sc">;</span>
888 875 <span class="s">}</span>
889 876 <span class="s">(</span><span class="i">$SpecifiedColID</span><span class="s">)</span> = <span class="i">$SpecifiedRowValues</span>[<span class="n">0</span>]<span class="sc">;</span>
890 877 <span class="k">if</span> <span class="s">(</span><span class="i">$Options</span>{<span class="w">colmode</span>} =~ <span class="q">/^colnum$/i</span><span class="s">)</span> <span class="s">{</span>
891 878 <span class="k">if</span> <span class="s">(</span>!<span class="i">IsPositiveInteger</span><span class="s">(</span><span class="i">$SpecifiedColID</span><span class="s">)</span><span class="s">)</span> <span class="s">{</span>
892 879 <span class="k">die</span> <span class="q">&quot;Error: Rows value, $SpecifiedColID, specified using \&quot;--rows\&quot; option with \&quot;--rowsmode\&quot; value of $Options{rowsmode} is not valid. Allowed integer values: &gt; 0.\n&quot;</span><span class="sc">;</span>
893 880 <span class="s">}</span>
894 881 <span class="s">}</span>
895 882 <span class="s">}</span>
896 883 <span class="k">elsif</span> <span class="s">(</span><span class="i">$Options</span>{<span class="w">rowsmode</span>} =~ <span class="q">/^rownums$/i</span><span class="s">)</span> <span class="s">{</span>
897 884 <span class="k">for</span> <span class="i">$SpecifiedRowID</span> <span class="s">(</span><span class="i">@SpecifiedRowValues</span><span class="s">)</span> <span class="s">{</span>
898 885 <span class="k">if</span> <span class="s">(</span>!<span class="i">IsPositiveInteger</span><span class="s">(</span><span class="i">$SpecifiedRowID</span><span class="s">)</span><span class="s">)</span> <span class="s">{</span>
899 886 <span class="k">die</span> <span class="q">&quot;Error: Rows value, $SpecifiedRowID, specified using \&quot;--rows\&quot; option with \&quot;--rowsmode\&quot; value of $Options{rowsmode} is not valid. Allowed integer values: &gt; 0.\n&quot;</span><span class="sc">;</span>
900 887 <span class="s">}</span>
901 888 <span class="s">}</span>
902 889 <span class="s">}</span>
903 890 <span class="k">elsif</span> <span class="s">(</span><span class="i">$Options</span>{<span class="w">rowsmode</span>} =~ <span class="q">/^rownumrange$/i</span><span class="s">)</span> <span class="s">{</span>
904 891 <span class="k">if</span> <span class="s">(</span><span class="i">@SpecifiedRowValues</span> != <span class="n">2</span><span class="s">)</span> <span class="s">{</span>
905 892 <span class="k">die</span> <span class="q">&quot;Error: Invalid number of values, &quot;</span><span class="cm">,</span> <span class="k">scalar</span><span class="s">(</span><span class="i">@SpecifiedRowValues</span><span class="s">)</span> <span class="cm">,</span> <span class="q">&quot;, specified by \&quot;--rows\&quot; option with \&quot;--rowsmode\&quot; value of $Options{rowsmode}.\nIt must contain only two values.\n&quot;</span><span class="sc">;</span>
906 893 <span class="s">}</span>
907 894 <span class="k">for</span> <span class="i">$SpecifiedRowID</span> <span class="s">(</span><span class="i">@SpecifiedRowValues</span><span class="s">)</span> <span class="s">{</span>
908 895 <span class="k">if</span> <span class="s">(</span>!<span class="i">IsPositiveInteger</span><span class="s">(</span><span class="i">$SpecifiedRowID</span><span class="s">)</span><span class="s">)</span> <span class="s">{</span>
909 896 <span class="k">die</span> <span class="q">&quot;Error: Rows value, $SpecifiedRowID, specified using \&quot;--rows\&quot; option with \&quot;--rowsmode\&quot; value of $Options{rowsmode} is not valid. Allowed integer values: &gt; 0.\n&quot;</span><span class="sc">;</span>
910 897 <span class="s">}</span>
911 898 <span class="s">}</span>
912 899 <span class="k">if</span> <span class="s">(</span><span class="i">$SpecifiedRowValues</span>[<span class="n">0</span>] &gt;= <span class="i">$SpecifiedRowValues</span>[<span class="n">1</span>]<span class="s">)</span> <span class="s">{</span>
913 900 <span class="k">die</span> <span class="q">&quot;Error: Invalid value pair - &quot;</span><span class="cm">,</span> <span class="i">JoinWords</span><span class="s">(</span>\<span class="i">@SpecifiedRowValues</span><span class="cm">,</span> <span class="q">&#39;,&#39;</span><span class="cm">,</span> <span class="n">0</span><span class="s">)</span> <span class="cm">,</span> <span class="q">&quot; - specified by \&quot;--rows\&quot; option with \&quot;--rowsmode\&quot; value of $Options{rowsmode}.\nAllowed values: First value &lt; second value\n&quot;</span><span class="sc">;</span>
914 901 <span class="s">}</span>
915 902 <span class="s">}</span>
916 903 <span class="s">}</span>
917 904
918 905 <span class="c"># Setup script usage and retrieve command line arguments specified using various options...</span>
919 <a name="SetupScriptUsage-"></a> 906 <span class="k">sub </span><span class="m">SetupScriptUsage</span> <span class="s">{</span>
920 907
921 908 <span class="c"># Setup default and retrieve all the options...</span>
922 909 <span class="i">%Options</span> = <span class="s">(</span><span class="s">)</span><span class="sc">;</span>
923 910 <span class="i">$Options</span>{<span class="w">colmode</span>} = <span class="q">&quot;colnum&quot;</span><span class="sc">;</span>
924 911 <span class="i">$Options</span>{<span class="w">indelim</span>} = <span class="q">&quot;comma&quot;</span><span class="sc">;</span>
925 912 <span class="i">$Options</span>{<span class="w">mode</span>} = <span class="q">&quot;columns&quot;</span><span class="sc">;</span>
926 913 <span class="i">$Options</span>{<span class="w">outdelim</span>} = <span class="q">&quot;comma&quot;</span><span class="sc">;</span>
927 914 <span class="i">$Options</span>{<span class="w">quote</span>} = <span class="q">&quot;yes&quot;</span><span class="sc">;</span>
928 915 <span class="i">$Options</span>{<span class="w">rowsmode</span>} = <span class="q">&quot;rownums&quot;</span><span class="sc">;</span>
929 916
930 917 <span class="k">if</span> <span class="s">(</span>!<span class="i">GetOptions</span><span class="s">(</span>\<span class="i">%Options</span><span class="cm">,</span> <span class="q">&quot;categorycol=s&quot;</span><span class="cm">,</span> <span class="q">&quot;columns=s&quot;</span><span class="cm">,</span> <span class="q">&quot;colmode|c=s&quot;</span><span class="cm">,</span> <span class="q">&quot;help|h&quot;</span><span class="cm">,</span> <span class="q">&quot;indelim=s&quot;</span><span class="cm">,</span> <span class="q">&quot;mode|m=s&quot;</span><span class="cm">,</span> <span class="q">&quot;outdelim=s&quot;</span><span class="cm">,</span> <span class="q">&quot;overwrite|o&quot;</span><span class="cm">,</span> <span class="q">&quot;quote|q=s&quot;</span><span class="cm">,</span> <span class="q">&quot;root|r=s&quot;</span><span class="cm">,</span> <span class="q">&quot;rows=s&quot;</span><span class="cm">,</span> <span class="q">&quot;rowsmode=s&quot;</span><span class="cm">,</span> <span class="q">&quot;workingdir|w=s&quot;</span><span class="s">)</span><span class="s">)</span> <span class="s">{</span>
931 918 <span class="k">die</span> <span class="q">&quot;\nTo get a list of valid options and their values, use \&quot;$ScriptName -h\&quot; or\n\&quot;perl -S $ScriptName -h\&quot; command and try again...\n&quot;</span><span class="sc">;</span>
932 919 <span class="s">}</span>
933 920 <span class="k">if</span> <span class="s">(</span><span class="i">$Options</span>{<span class="w">workingdir</span>}<span class="s">)</span> <span class="s">{</span>
934 921 <span class="k">if</span> <span class="s">(</span>! <span class="k">-d</span> <span class="i">$Options</span>{<span class="w">workingdir</span>}<span class="s">)</span> <span class="s">{</span>
935 922 <span class="k">die</span> <span class="q">&quot;Error: The value specified, $Options{workingdir}, for option \&quot;-w --workingdir\&quot; is not a directory name.\n&quot;</span><span class="sc">;</span>
936 923 <span class="s">}</span>
937 924 <span class="k">chdir</span> <span class="i">$Options</span>{<span class="w">workingdir</span>} || <span class="k">die</span> <span class="q">&quot;Error: Couldn&#39;t chdir $Options{workingdir}: $! \n&quot;</span><span class="sc">;</span>
938 925 <span class="s">}</span>
939 926 <span class="k">if</span> <span class="s">(</span><span class="i">$Options</span>{<span class="w">mode</span>} !~ <span class="q">/^(columns|rows|categories)$/i</span><span class="s">)</span> <span class="s">{</span>
940 927 <span class="k">die</span> <span class="q">&quot;Error: The value specified, $Options{mode}, for option \&quot;-m --mode\&quot; is not valid. Allowed values: columns, rows or categories \n&quot;</span><span class="sc">;</span>
941 928 <span class="s">}</span>
942 929 <span class="k">if</span> <span class="s">(</span><span class="i">$Options</span>{<span class="w">colmode</span>} !~ <span class="q">/^(colnum|collabel)$/i</span><span class="s">)</span> <span class="s">{</span>
943 930 <span class="k">die</span> <span class="q">&quot;Error: The value specified, $Options{colmode}, for option \&quot;--colmode\&quot; is not valid. Allowed values: colnum or collabel \n&quot;</span><span class="sc">;</span>
944 931 <span class="s">}</span>
945 932 <span class="k">if</span> <span class="s">(</span><span class="i">$Options</span>{<span class="w">indelim</span>} !~ <span class="q">/^(comma|semicolon)$/i</span><span class="s">)</span> <span class="s">{</span>
946 933 <span class="k">die</span> <span class="q">&quot;Error: The value specified, $Options{indelim}, for option \&quot;--indelim\&quot; is not valid. Allowed values: comma or semicolon\n&quot;</span><span class="sc">;</span>
947 934 <span class="s">}</span>
948 935 <span class="k">if</span> <span class="s">(</span><span class="i">$Options</span>{<span class="w">outdelim</span>} !~ <span class="q">/^(comma|semicolon|tab)$/i</span><span class="s">)</span> <span class="s">{</span>
949 936 <span class="k">die</span> <span class="q">&quot;Error: The value specified, $Options{outdelim}, for option \&quot;--outdelim\&quot; is not valid. Allowed values: comma, tab, or semicolon\n&quot;</span><span class="sc">;</span>
950 937 <span class="s">}</span>
951 938 <span class="k">if</span> <span class="s">(</span><span class="i">$Options</span>{<span class="w">quote</span>} !~ <span class="q">/^(yes|no)$/i</span><span class="s">)</span> <span class="s">{</span>
952 939 <span class="k">die</span> <span class="q">&quot;Error: The value specified, $Options{quote}, for option \&quot;-q --quote\&quot; is not valid. Allowed values: yes or no\n&quot;</span><span class="sc">;</span>
953 940 <span class="s">}</span>
954 941 <span class="k">if</span> <span class="s">(</span><span class="i">$Options</span>{<span class="w">rowsmode</span>} !~ <span class="q">/^(rowsbycolvalue|rowsbycolvaluelist|rowsbycolvaluerange|rowbymincolvalue|rowbymaxcolvalue|rownums|rownumrange)$/i</span><span class="s">)</span> <span class="s">{</span>
955 942 <span class="k">die</span> <span class="q">&quot;Error: The value specified, $Options{rowsmode}, for option \&quot;--rowsmode\&quot; is not valid. Allowed values: rowsbycolvalue, rowsbycolvaluelist, rowsbycolvaluerange, rowbymincolvalue, rowbymaxcolvalue, rownum, rownumrange\n&quot;</span><span class="sc">;</span>
956 943 <span class="s">}</span>
957 944 <span class="s">}</span>
958 <a name="EOF-"></a></pre>
959 <p>&nbsp;</p>
960 <br />
961 <center>
962 <img src="../../../images/h2o2.png">
963 </center>
964 </body>
965 </html>