Mercurial > repos > deepakjadmin > mayatool3_test2
view docs/scripts/html/code/ExtractFromTextFiles.html @ 0:4816e4a8ae95 draft default tip
Uploaded
| author | deepakjadmin |
|---|---|
| date | Wed, 20 Jan 2016 09:23:18 -0500 |
| parents | |
| children |
line wrap: on
line source
<html> <head> <title>MayaChemTools:Code:ExtractFromTextFiles.pl</title> <meta http-equiv="content-type" content="text/html;charset=utf-8"> <link rel="stylesheet" type="text/css" href="../../../css/MayaChemToolsCode.css"> </head> <body leftmargin="20" rightmargin="20" topmargin="10" bottommargin="10"> <br/> <center> <a href="http://www.mayachemtools.org" title="MayaChemTools Home"><img src="../../../images/MayaChemToolsLogo.gif" border="0" alt="MayaChemTools"></a> </center> <br/> <pre> 1 #!/usr/bin/perl -w 2 <span class="c">#</span> 3 <span class="c"># $RCSfile: ExtractFromTextFiles.pl,v $</span> 4 <span class="c"># $Date: 2015/02/28 20:46:19 $</span> 5 <span class="c"># $Revision: 1.42 $</span> 6 <span class="c">#</span> 7 <span class="c"># Author: Manish Sud <msud@san.rr.com></span> 8 <span class="c">#</span> 9 <span class="c"># Copyright (C) 2015 Manish Sud. All rights reserved.</span> 10 <span class="c">#</span> 11 <span class="c"># This file is part of MayaChemTools.</span> 12 <span class="c">#</span> 13 <span class="c"># MayaChemTools is free software; you can redistribute it and/or modify it under</span> 14 <span class="c"># the terms of the GNU Lesser General Public License as published by the Free</span> 15 <span class="c"># Software Foundation; either version 3 of the License, or (at your option) any</span> 16 <span class="c"># later version.</span> 17 <span class="c">#</span> 18 <span class="c"># MayaChemTools is distributed in the hope that it will be useful, but without</span> 19 <span class="c"># any warranty; without even the implied warranty of merchantability of fitness</span> 20 <span class="c"># for a particular purpose. See the GNU Lesser General Public License for more</span> 21 <span class="c"># details.</span> 22 <span class="c">#</span> 23 <span class="c"># You should have received a copy of the GNU Lesser General Public License</span> 24 <span class="c"># along with MayaChemTools; if not, see <http://www.gnu.org/licenses/> or</span> 25 <span class="c"># write to the Free Software Foundation Inc., 59 Temple Place, Suite 330,</span> 26 <span class="c"># Boston, MA, 02111-1307, USA.</span> 27 <span class="c">#</span> 28 29 <span class="k">use</span> <span class="w">strict</span><span class="sc">;</span> 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">"$FindBin::Bin/../lib"</span><span class="sc">;</span> 31 <span class="k">use</span> <span class="w">Getopt::Long</span><span class="sc">;</span> 32 <span class="k">use</span> <span class="w">File::Basename</span><span class="sc">;</span> 33 <span class="k">use</span> <span class="w">Text::ParseWords</span><span class="sc">;</span> 34 <span class="k">use</span> <span class="w">FileHandle</span><span class="sc">;</span> 35 <span class="k">use</span> <span class="w">Benchmark</span><span class="sc">;</span> 36 <span class="k">use</span> <span class="w">FileUtil</span><span class="sc">;</span> 37 <span class="k">use</span> <span class="w">TextUtil</span><span class="sc">;</span> 38 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> 40 41 <span class="c"># Autoflush STDOUT</span> 42 <span class="i">$|</span> = <span class="n">1</span><span class="sc">;</span> 43 44 <span class="i">$StartTime</span> = <span class="w">new</span> <span class="w">Benchmark</span><span class="sc">;</span> 45 46 <span class="c"># Starting message...</span> 47 <span class="i">$ScriptName</span> = <span class="w">basename</span> <span class="i">$0</span><span class="sc">;</span> 48 <span class="k">print</span> <span class="q">"\n$ScriptName:Starting...\n\n"</span><span class="sc">;</span> 49 50 <span class="c"># Get the options and setup script...</span> 51 <span class="i">SetupScriptUsage</span><span class="s">(</span><span class="s">)</span><span class="sc">;</span> 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> < <span class="n">1</span><span class="s">)</span> <span class="s">{</span> 53 <span class="k">die</span> <span class="i">GetUsageFromPod</span><span class="s">(</span><span class="q">"$FindBin::Bin/$ScriptName"</span><span class="s">)</span><span class="sc">;</span> 54 <span class="s">}</span> 55 56 <span class="k">my</span><span class="s">(</span><span class="i">@TextFilesList</span><span class="s">)</span><span class="sc">;</span> 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">"csv tsv"</span><span class="s">)</span><span class="sc">;</span> 58 59 <span class="c"># Process options...</span> 60 <span class="k">print</span> <span class="q">"Processing options...\n"</span><span class="sc">;</span> 61 <span class="k">my</span><span class="s">(</span><span class="i">%OptionsInfo</span><span class="s">)</span><span class="sc">;</span> 62 <span class="i">ProcessOptions</span><span class="s">(</span><span class="s">)</span><span class="sc">;</span> 63 64 <span class="c"># Collect column information for all the text files...</span> 65 <span class="k">print</span> <span class="q">"Checking input text file(s)...\n"</span><span class="sc">;</span> 66 <span class="k">my</span><span class="s">(</span><span class="i">%TextFilesInfo</span><span class="s">)</span><span class="sc">;</span> 67 <span class="i">RetrieveTextFilesInfo</span><span class="s">(</span><span class="s">)</span><span class="sc">;</span> 68 <span class="i">RetrieveColumnsAndRowsInfo</span><span class="s">(</span><span class="s">)</span><span class="sc">;</span> 69 70 <span class="c"># Generate output files...</span> 71 <span class="k">my</span><span class="s">(</span><span class="i">$FileIndex</span><span class="s">)</span><span class="sc">;</span> 72 <span class="k">if</span> <span class="s">(</span><span class="i">@TextFilesList</span> > <span class="n">1</span><span class="s">)</span> <span class="s">{</span> 73 <span class="k">print</span> <span class="q">"\nProcessing text files...\n"</span><span class="sc">;</span> 74 <span class="s">}</span> 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> 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> 77 <span class="k">print</span> <span class="q">"\nProcessing file $TextFilesList[$FileIndex]...\n"</span><span class="sc">;</span> 78 <span class="i">ExtractFromTextFile</span><span class="s">(</span><span class="i">$FileIndex</span><span class="s">)</span><span class="sc">;</span> 79 <span class="s">}</span> 80 <span class="s">}</span> 81 <span class="k">print</span> <span class="q">"\n$ScriptName:Done...\n\n"</span><span class="sc">;</span> 82 83 <span class="i">$EndTime</span> = <span class="w">new</span> <span class="w">Benchmark</span><span class="sc">;</span> 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> 85 <span class="k">print</span> <span class="q">"Total time: "</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">"\n"</span><span class="sc">;</span> 86 87 <span class="c">###############################################################################</span> 88 89 <span class="c"># Extract appropriate data from text file...</span> <a name="ExtractFromTextFile-"></a> 90 <span class="k">sub </span><span class="m">ExtractFromTextFile</span> <span class="s">{</span> 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> 92 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> 94 <span class="i">ExtractCategoryData</span><span class="s">(</span><span class="i">$Index</span><span class="s">)</span><span class="sc">;</span> 95 <span class="s">}</span> 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> 97 <span class="i">ExtractRowsData</span><span class="s">(</span><span class="i">$Index</span><span class="s">)</span><span class="sc">;</span> 98 <span class="s">}</span> 99 <span class="k">else</span> <span class="s">{</span> 100 <span class="i">ExtractColumnData</span><span class="s">(</span><span class="i">$Index</span><span class="s">)</span><span class="sc">;</span> 101 <span class="s">}</span> 102 <span class="s">}</span> 103 104 <span class="c"># Geneate category files...</span> <a name="ExtractCategoryData-"></a> 105 <span class="k">sub </span><span class="m">ExtractCategoryData</span> <span class="s">{</span> 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> 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> 108 109 <span class="i">$TextFile</span> = <span class="i">$TextFilesList</span>[<span class="i">$Index</span>]<span class="sc">;</span> 110 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> 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> 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> 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> 115 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> 117 <span class="c"># Collect category data...</span> 118 <span class="k">open</span> <span class="w">TEXTFILE</span><span class="cm">,</span> <span class="q">"$TextFile"</span> <span class="k">or</span> <span class="k">die</span> <span class="q">"Couldn't open $TextFile: $! \n"</span><span class="sc">;</span> 119 <span class="c"># Skip label line...</span> 120 <span class="i">$_</span> = <span class="q"><TEXTFILE></span><span class="sc">;</span> 121 122 <span class="i">%CategoriesNameToCountMap</span> = <span class="s">(</span><span class="s">)</span><span class="sc">;</span> 123 <span class="i">%CategoriesNameToLinesMap</span> = <span class="s">(</span><span class="s">)</span><span class="sc">;</span> 124 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> 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> 127 <span class="i">$CategoryName</span> = <span class="s">(</span><span class="i">$CategoryCol</span> <= <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">""</span><span class="sc">;</span> 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> 129 <span class="i">$CategoriesNameToCountMap</span>{<span class="i">$CategoryName</span>} += <span class="n">1</span><span class="sc">;</span> 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> 131 <span class="s">}</span> 132 <span class="k">else</span> <span class="s">{</span> 133 <span class="i">$CategoriesNameToCountMap</span>{<span class="i">$CategoryName</span>} = <span class="n">1</span><span class="sc">;</span> 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> 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> 136 <span class="s">}</span> 137 <span class="s">}</span> 138 <span class="k">close</span> <span class="w">TEXTFILE</span><span class="sc">;</span> 139 140 <span class="c"># Setup file names for individual category files...</span> 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> 142 143 <span class="i">%CategoriesNameToFileHandleMap</span> = <span class="s">(</span><span class="s">)</span><span class="sc">;</span> 144 <span class="i">%CategoriesNameToFileNameMap</span> = <span class="s">(</span><span class="s">)</span><span class="sc">;</span> 145 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> 147 <span class="i">$CategoryFile</span> = <span class="i">$TextFilesInfo</span>{<span class="w">CategoryOutFileRoot</span>}[<span class="i">$Index</span>] . <span class="q">"$CategoryName"</span> . <span class="q">".$TextFilesInfo{OutFileExt}[$Index]"</span><span class="sc">;</span><span class="sc">;</span> 148 <span class="i">$CategoryFile</span> =~ <span class="q">s/ //g</span><span class="sc">;</span> 149 <span class="i">$CategoryFileHandle</span> = <span class="w">new</span> <span class="w">FileHandle</span><span class="sc">;</span> 150 <span class="k">open</span> <span class="i">$CategoryFileHandle</span><span class="cm">,</span> <span class="q">">$CategoryFile"</span> <span class="k">or</span> <span class="k">die</span> <span class="q">"Couldn't open $CategoryFile: $! \n"</span><span class="sc">;</span> 151 <span class="i">$CategoriesNameToFileNameMap</span>{<span class="i">$CategoryName</span>} = <span class="i">$CategoryFile</span><span class="sc">;</span> 152 <span class="i">$CategoriesNameToFileHandleMap</span>{<span class="i">$CategoryName</span>} = <span class="i">$CategoryFileHandle</span><span class="sc">;</span> 153 <span class="s">}</span> 154 155 <span class="c"># Write out summary file...</span> 156 <span class="k">print</span> <span class="q">"Generating file $NewTextFile...\n"</span><span class="sc">;</span> 157 <span class="k">open</span> <span class="w">NEWTEXTFILE</span><span class="cm">,</span> <span class="q">">$NewTextFile"</span> <span class="k">or</span> <span class="k">die</span> <span class="q">"Couldn't open $NewTextFile: $! \n"</span><span class="sc">;</span> 158 159 <span class="c"># Write out column labels...</span> 160 <span class="i">@LineWords</span> = <span class="s">(</span><span class="q">"Category"</span><span class="cm">,</span><span class="q">"Count"</span><span class="s">)</span><span class="sc">;</span> 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> 162 <span class="k">print</span> <span class="i">NEWTEXTFILE</span> <span class="q">"$Line\n"</span><span class="sc">;</span> 163 164 <span class="c"># Write out the category names and count...</span> 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> 166 <span class="i">$CategoryCount</span> = <span class="i">$CategoriesNameToCountMap</span>{<span class="i">$CategoryName</span>}<span class="sc">;</span> 167 <span class="i">@LineWords</span> = <span class="s">(</span><span class="q">"$CategoryName"</span><span class="cm">,</span><span class="q">"$CategoryCount"</span><span class="s">)</span><span class="sc">;</span> 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> 169 <span class="k">print</span> <span class="i">NEWTEXTFILE</span> <span class="q">"$Line\n"</span><span class="sc">;</span> 170 <span class="s">}</span> 171 <span class="k">close</span> <span class="w">NEWTEXTFILE</span><span class="sc">;</span> 172 173 <span class="c"># Write out a file for each category...</span> 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> 175 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> 177 <span class="k">print</span> <span class="q">"\nGenerating text files for each category...\n"</span><span class="sc">;</span> 178 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> 180 <span class="k">print</span> <span class="q">"Generating file $CategoriesNameToFileNameMap{$CategoryName}...\n"</span><span class="sc">;</span> 181 <span class="i">$CategoryFileHandle</span> = <span class="i">$CategoriesNameToFileHandleMap</span>{<span class="i">$CategoryName</span>}<span class="sc">;</span> 182 <span class="k">print</span> <span class="i">$CategoryFileHandle</span> <span class="q">"$ColLabelLine\n"</span><span class="sc">;</span> 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> 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> 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> 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> 187 <span class="k">print</span> <span class="i">$CategoryFileHandle</span> <span class="q">"$Line\n"</span><span class="sc">;</span> 188 <span class="s">}</span> 189 <span class="k">close</span> <span class="i">$CategoryFileHandle</span><span class="sc">;</span> 190 <span class="s">}</span> 191 <span class="s">}</span> 192 193 <span class="c"># Extract data for specific columns...</span> <a name="ExtractColumnData-"></a> 194 <span class="k">sub </span><span class="m">ExtractColumnData</span> <span class="s">{</span> 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> 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> 197 198 <span class="i">$TextFile</span> = <span class="i">$TextFilesList</span>[<span class="i">$Index</span>]<span class="sc">;</span> 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> 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> 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> 202 203 <span class="k">print</span> <span class="q">"Generating file $NewTextFile...\n"</span><span class="sc">;</span> 204 <span class="k">open</span> <span class="w">TEXTFILE</span><span class="cm">,</span> <span class="q">"$TextFile"</span> <span class="k">or</span> <span class="k">die</span> <span class="q">"Couldn't open $TextFile: $! \n"</span><span class="sc">;</span> 205 <span class="k">open</span> <span class="w">NEWTEXTFILE</span><span class="cm">,</span> <span class="q">">$NewTextFile"</span> <span class="k">or</span> <span class="k">die</span> <span class="q">"Couldn't open $NewTextFile: $! \n"</span><span class="sc">;</span> 206 207 <span class="i">$_</span> = <span class="q"><TEXTFILE></span><span class="sc">;</span> 208 <span class="c"># Write out column labels...</span> 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> 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">""</span><span class="sc">;</span> 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> 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> 213 <span class="s">}</span> 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> 215 <span class="k">print</span> <span class="i">NEWTEXTFILE</span> <span class="q">"$ColLabelLine\n"</span><span class="sc">;</span> 216 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> 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> 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">""</span><span class="sc">;</span> 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> 221 <span class="i">$ColValue</span> = <span class="q">""</span><span class="sc">;</span> 222 <span class="k">if</span> <span class="s">(</span><span class="i">$ColNum</span> < <span class="i">@LineWords</span><span class="s">)</span> <span class="s">{</span> 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">""</span><span class="sc">;</span> 224 <span class="s">}</span> 225 <span class="k">push</span> <span class="i">@ColValues</span><span class="cm">,</span> <span class="i">$ColValue</span><span class="sc">;</span> 226 <span class="s">}</span> 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> 228 <span class="k">print</span> <span class="i">NEWTEXTFILE</span> <span class="q">"$ColValuesLine\n"</span><span class="sc">;</span> 229 <span class="s">}</span> 230 <span class="k">close</span> <span class="w">NEWTEXTFILE</span><span class="sc">;</span> 231 <span class="k">close</span> <span class="w">TEXTFILE</span><span class="sc">;</span> 232 <span class="s">}</span> 233 234 <span class="c"># Extract data for specific rows...</span> <a name="ExtractRowsData-"></a> 235 <span class="k">sub </span><span class="m">ExtractRowsData</span> <span class="s">{</span> 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> 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> 238 239 <span class="i">$TextFile</span> = <span class="i">$TextFilesList</span>[<span class="i">$Index</span>]<span class="sc">;</span> 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> 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> 242 243 <span class="i">$SpecifiedRowsMode</span> = <span class="i">$OptionsInfo</span>{<span class="w">SpecifiedRowsMode</span>}<span class="sc">;</span> 244 245 <span class="k">print</span> <span class="q">"Generating file $NewTextFile...\n"</span><span class="sc">;</span> 246 <span class="k">open</span> <span class="w">TEXTFILE</span><span class="cm">,</span> <span class="q">"$TextFile"</span> <span class="k">or</span> <span class="k">die</span> <span class="q">"Couldn't open $TextFile: $! \n"</span><span class="sc">;</span> 247 <span class="k">open</span> <span class="w">NEWTEXTFILE</span><span class="cm">,</span> <span class="q">">$NewTextFile"</span> <span class="k">or</span> <span class="k">die</span> <span class="q">"Couldn't open $NewTextFile: $! \n"</span><span class="sc">;</span> 248 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> 250 251 <span class="c"># Write out column labels...</span> 252 <span class="i">$Line</span> = <span class="q"><TEXTFILE></span><span class="sc">;</span> 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> 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> 255 <span class="k">print</span> <span class="i">NEWTEXTFILE</span> <span class="q">"$Line\n"</span><span class="sc">;</span> 256 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> 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> 259 <span class="s">}</span> 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> 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> 262 <span class="s">}</span> 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> 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> 265 <span class="s">}</span> 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> 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> 268 <span class="s">}</span> 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> 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> 271 <span class="s">}</span> 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> 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> 274 <span class="s">}</span> 275 276 <span class="k">close</span> <span class="w">NEWTEXTFILE</span><span class="sc">;</span> 277 <span class="k">close</span> <span class="w">TEXTFILE</span><span class="sc">;</span> 278 <span class="s">}</span> 279 280 <span class="c"># Extract rows by column value...</span> <a name="ExtractRowsByColValue-"></a> 281 <span class="k">sub </span><span class="m">ExtractRowsByColValue</span> <span class="s">{</span> 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> 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> 284 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> 286 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> 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> 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> < <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> 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> 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> 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> 293 <span class="k">if</span> <span class="s">(</span><span class="i">$ColNum</span> > <span class="i">$#LineWords</span><span class="s">)</span> <span class="s">{</span> 294 <span class="k">next</span> <span class="j">LINE</span><span class="sc">;</span> 295 <span class="s">}</span> 296 <span class="i">$Value</span> = <span class="i">$LineWords</span>[<span class="i">$ColNum</span>]<span class="sc">;</span> 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> 298 <span class="k">if</span> <span class="s">(</span><span class="i">$Value</span> > <span class="i">$ColValue</span><span class="s">)</span> <span class="s">{</span> 299 <span class="k">next</span> <span class="j">LINE</span><span class="sc">;</span> 300 <span class="s">}</span> 301 <span class="s">}</span> 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> 303 <span class="k">if</span> <span class="s">(</span><span class="i">$Value</span> < <span class="i">$ColValue</span><span class="s">)</span> <span class="s">{</span> 304 <span class="k">next</span> <span class="j">LINE</span><span class="sc">;</span> 305 <span class="s">}</span> 306 <span class="s">}</span> 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> 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> 309 <span class="k">next</span> <span class="j">LINE</span><span class="sc">;</span> 310 <span class="s">}</span> 311 <span class="s">}</span> 312 <span class="s">}</span> 313 <span class="c"># Write it out...</span> 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> 315 <span class="k">print</span> <span class="i">$NewTextFileRef</span> <span class="q">"$Line\n"</span><span class="sc">;</span> 316 <span class="s">}</span> 317 <span class="s">}</span> 318 <span class="c"># Extract rows by column value list...</span> <a name="ExtractRowsByColValueList-"></a> 319 <span class="k">sub </span><span class="m">ExtractRowsByColValueList</span> <span class="s">{</span> 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> 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> 322 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> 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> 325 326 <span class="c"># Setup a col value map...</span> 327 <span class="i">%ColValueMap</span> = <span class="s">(</span><span class="s">)</span><span class="sc">;</span> 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> 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> 330 <span class="i">$ColValueMap</span>{<span class="i">$Value</span>} = <span class="i">$Value</span><span class="sc">;</span> 331 <span class="s">}</span> 332 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> 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> 335 <span class="k">if</span> <span class="s">(</span><span class="i">$ColNum</span> > <span class="i">$#LineWords</span><span class="s">)</span> <span class="s">{</span> 336 <span class="k">next</span> <span class="j">LINE</span><span class="sc">;</span> 337 <span class="s">}</span> 338 <span class="i">$ColValue</span> = <span class="i">$LineWords</span>[<span class="i">$ColNum</span>]<span class="sc">;</span> 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> 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> 341 <span class="k">print</span> <span class="i">$NewTextFileRef</span> <span class="q">"$Line\n"</span><span class="sc">;</span> 342 <span class="s">}</span> 343 <span class="s">}</span> 344 <span class="s">}</span> 345 346 <span class="c"># Extract row by minimum column value...</span> <a name="ExtractRowByMinOrMaxColValue-"></a> 347 <span class="k">sub </span><span class="m">ExtractRowByMinOrMaxColValue</span> <span class="s">{</span> 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> 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> 350 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> 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> 353 354 <span class="i">$ValueLine</span> = <span class="q">''</span><span class="sc">;</span> <span class="i">$ColValue</span> = <span class="q">''</span><span class="sc">;</span> <span class="i">$FirstValue</span> = <span class="n">1</span><span class="sc">;</span> 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> 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> 357 <span class="k">if</span> <span class="s">(</span><span class="i">$ColNum</span> > <span class="i">$#LineWords</span><span class="s">)</span> <span class="s">{</span> 358 <span class="k">next</span> <span class="j">LINE</span><span class="sc">;</span> 359 <span class="s">}</span> 360 <span class="k">if</span> <span class="s">(</span><span class="i">$FirstValue</span><span class="s">)</span> <span class="s">{</span> 361 <span class="i">$FirstValue</span> = <span class="n">0</span><span class="sc">;</span> 362 <span class="i">$ColValue</span> = <span class="i">$LineWords</span>[<span class="i">$ColNum</span>]<span class="sc">;</span> 363 <span class="i">$ValueLine</span> = <span class="i">$Line</span><span class="sc">;</span> 364 <span class="k">next</span> <span class="j">LINE</span><span class="sc">;</span> 365 <span class="s">}</span> 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> 367 <span class="k">if</span> <span class="s">(</span><span class="i">$LineWords</span>[<span class="i">$ColNum</span>] > <span class="i">$ColValue</span><span class="s">)</span> <span class="s">{</span> 368 <span class="i">$ColValue</span> = <span class="i">$LineWords</span>[<span class="i">$ColNum</span>]<span class="sc">;</span> 369 <span class="i">$ValueLine</span> = <span class="i">$Line</span><span class="sc">;</span> 370 <span class="s">}</span> 371 <span class="s">}</span> 372 <span class="k">else</span> <span class="s">{</span> 373 <span class="k">if</span> <span class="s">(</span><span class="i">$LineWords</span>[<span class="i">$ColNum</span>] < <span class="i">$ColValue</span><span class="s">)</span> <span class="s">{</span> 374 <span class="i">$ColValue</span> = <span class="i">$LineWords</span>[<span class="i">$ColNum</span>]<span class="sc">;</span> 375 <span class="i">$ValueLine</span> = <span class="i">$Line</span><span class="sc">;</span> 376 <span class="s">}</span> 377 <span class="s">}</span> 378 <span class="s">}</span> 379 <span class="k">if</span> <span class="s">(</span><span class="i">$ValueLine</span><span class="s">)</span> <span class="s">{</span> 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> 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> 382 <span class="k">print</span> <span class="i">$NewTextFileRef</span> <span class="q">"$Line\n"</span><span class="sc">;</span> 383 <span class="s">}</span> 384 <span class="s">}</span> 385 386 <span class="c"># Extract rows by column value range...</span> <a name="ExtractRowsByColValueRange-"></a> 387 <span class="k">sub </span><span class="m">ExtractRowsByColValueRange</span> <span class="s">{</span> 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> 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> 390 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> 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> 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> 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> 395 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> 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> 398 <span class="k">if</span> <span class="s">(</span><span class="i">$ColNum</span> > <span class="i">$#LineWords</span><span class="s">)</span> <span class="s">{</span> 399 <span class="k">next</span> <span class="j">LINE</span><span class="sc">;</span> 400 <span class="s">}</span> 401 <span class="i">$ColValue</span> = <span class="i">$LineWords</span>[<span class="i">$ColNum</span>]<span class="sc">;</span> 402 <span class="k">if</span> <span class="s">(</span><span class="i">$ColValue</span> >= <span class="i">$MinValue</span> && <span class="i">$ColValue</span> <= <span class="i">$MaxValue</span><span class="s">)</span> <span class="s">{</span> 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> 404 <span class="k">print</span> <span class="i">$NewTextFileRef</span> <span class="q">"$Line\n"</span><span class="sc">;</span> 405 <span class="s">}</span> 406 <span class="s">}</span> 407 <span class="s">}</span> 408 409 <span class="c"># Extract rows by row number range...</span> <a name="ExtractRowsByRowNumRange-"></a> 410 <span class="k">sub </span><span class="m">ExtractRowsByRowNumRange</span> <span class="s">{</span> 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> 412 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> 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> 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> 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> 417 418 <span class="i">$RowCount</span> = <span class="n">1</span><span class="sc">;</span> 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> 420 <span class="i">$RowCount</span>++<span class="sc">;</span> 421 <span class="k">if</span> <span class="s">(</span><span class="i">$RowCount</span> >= <span class="i">$MinRowNum</span> && <span class="i">$RowCount</span> <= <span class="i">$MaxRowNum</span><span class="s">)</span> <span class="s">{</span> 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> 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> 424 <span class="k">print</span> <span class="i">$NewTextFileRef</span> <span class="q">"$Line\n"</span><span class="sc">;</span> 425 <span class="s">}</span> 426 <span class="k">elsif</span> <span class="s">(</span><span class="i">$RowCount</span> > <span class="i">$MaxRowNum</span><span class="s">)</span> <span class="s">{</span> 427 <span class="k">last</span> <span class="j">LINE</span><span class="sc">;</span> 428 <span class="s">}</span> 429 <span class="s">}</span> 430 <span class="s">}</span> 431 432 <span class="c"># Extract rows by row numbers...</span> <a name="ExtractRowsByRowNums-"></a> 433 <span class="k">sub </span><span class="m">ExtractRowsByRowNums</span> <span class="s">{</span> 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> 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> 436 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> 438 439 <span class="c"># Setup a row nums map...</span> 440 <span class="i">%RowNumMap</span> = <span class="s">(</span><span class="s">)</span><span class="sc">;</span> 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> 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> 443 <span class="k">if</span> <span class="s">(</span><span class="i">$RowNum</span> > <span class="i">$MaxRowNum</span><span class="s">)</span> <span class="s">{</span> 444 <span class="i">$MaxRowNum</span> = <span class="i">$RowNum</span><span class="sc">;</span> 445 <span class="s">}</span> 446 <span class="i">$RowNumMap</span>{<span class="i">$RowNum</span>} = <span class="i">$RowNum</span><span class="sc">;</span> 447 <span class="s">}</span> 448 449 <span class="i">$RowCount</span> = <span class="n">1</span><span class="sc">;</span> 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> 451 <span class="i">$RowCount</span>++<span class="sc">;</span> 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> 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> 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> 455 <span class="k">print</span> <span class="i">$NewTextFileRef</span> <span class="q">"$Line\n"</span><span class="sc">;</span> 456 <span class="s">}</span> 457 <span class="k">elsif</span> <span class="s">(</span><span class="i">$RowCount</span> > <span class="i">$MaxRowNum</span><span class="s">)</span> <span class="s">{</span> 458 <span class="k">last</span> <span class="j">LINE</span><span class="sc">;</span> 459 <span class="s">}</span> 460 <span class="s">}</span> 461 <span class="s">}</span> 462 463 <span class="c"># Retrieve text file columns and rows information for specified options...</span> <a name="RetrieveColumnsAndRowsInfo-"></a> 464 <span class="k">sub </span><span class="m">RetrieveColumnsAndRowsInfo</span> <span class="s">{</span> 465 <span class="i">ProcessColumnsInfo</span><span class="s">(</span><span class="s">)</span><span class="sc">;</span> 466 <span class="i">ProcessRowsInfo</span><span class="s">(</span><span class="s">)</span><span class="sc">;</span> 467 <span class="s">}</span> 468 469 <span class="c"># Make sure the specified columns exists in text files...</span> <a name="ProcessColumnsInfo-"></a> 470 <span class="k">sub </span><span class="m">ProcessColumnsInfo</span> <span class="s">{</span> 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> 472 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> 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> 475 476 <span class="i">$SpecifiedCategoryCol</span> = <span class="i">$OptionsInfo</span>{<span class="w">SpecifiedCategoryCol</span>}<span class="sc">;</span> 477 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> 479 <span class="i">$TextFile</span> = <span class="i">$TextFilesList</span>[<span class="i">$Index</span>]<span class="sc">;</span> 480 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> 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> 483 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> 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> 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> 487 488 <span class="i">$CategoryColNum</span> = <span class="n">0</span><span class="sc">;</span> 489 <span class="i">$CategoryColValid</span> = <span class="n">1</span><span class="sc">;</span> 490 <span class="k">if</span> <span class="s">(</span><span class="i">$SpecifiedCategoryCol</span><span class="s">)</span> <span class="s">{</span> 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> 492 <span class="k">if</span> <span class="s">(</span><span class="i">$SpecifiedCategoryCol</span> <= <span class="i">$TextFilesInfo</span>{<span class="w">ColCount</span>}[<span class="i">$Index</span>]<span class="s">)</span> <span class="s">{</span> 493 <span class="i">$CategoryColNum</span> = <span class="i">$SpecifiedCategoryCol</span> - <span class="n">1</span><span class="sc">;</span> 494 <span class="s">}</span> 495 <span class="k">else</span> <span class="s">{</span> 496 <span class="i">$CategoryColValid</span> = <span class="n">0</span><span class="sc">;</span> 497 <span class="s">}</span> 498 <span class="s">}</span> 499 <span class="k">else</span> <span class="s">{</span> 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> 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> 502 <span class="s">}</span> 503 <span class="k">else</span> <span class="s">{</span> 504 <span class="i">$CategoryColValid</span> = <span class="n">0</span><span class="sc">;</span> 505 <span class="s">}</span> 506 <span class="s">}</span> 507 <span class="s">}</span> 508 <span class="k">if</span> <span class="s">(</span><span class="i">$CategoryColValid</span><span class="s">)</span> <span class="s">{</span> 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> 510 <span class="s">}</span> 511 <span class="k">else</span> <span class="s">{</span> 512 <span class="k">warn</span> <span class="q">"Warning: Ignoring file $TextFile: Category column specified, $SpecifiedCategoryCol, using \"--categorycol\" option doesn't exist\n"</span><span class="sc">;</span> 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> 514 <span class="s">}</span> 515 <span class="s">}</span> 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> 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> 518 519 <span class="i">$ColNum</span> = <span class="n">0</span><span class="sc">;</span> 520 <span class="i">@ColNumsToExtract</span> = <span class="s">(</span><span class="s">)</span><span class="sc">;</span> 521 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> 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> 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> 525 <span class="k">if</span> <span class="s">(</span><span class="i">$SpecifiedColNum</span> >=<span class="n">1</span> && <span class="i">$SpecifiedColNum</span> <= <span class="i">$TextFilesInfo</span>{<span class="w">ColCount</span>}[<span class="i">$Index</span>]<span class="s">)</span> <span class="s">{</span> 526 <span class="i">$ColNum</span> = <span class="i">$SpecifiedColNum</span> - <span class="n">1</span><span class="sc">;</span> 527 <span class="k">push</span> <span class="i">@ColNumsToExtract</span><span class="cm">,</span> <span class="i">$ColNum</span><span class="sc">;</span> 528 <span class="s">}</span> 529 <span class="s">}</span> 530 <span class="s">}</span> 531 <span class="k">else</span> <span class="s">{</span> 532 <span class="k">my</span><span class="s">(</span><span class="i">$ColLabel</span><span class="s">)</span><span class="sc">;</span> 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> 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> 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> 536 <span class="s">}</span> 537 <span class="s">}</span> 538 <span class="s">}</span> 539 <span class="s">}</span> 540 <span class="k">else</span> <span class="s">{</span> 541 <span class="k">push</span> <span class="i">@ColNumsToExtract</span><span class="cm">,</span> <span class="i">$ColNum</span><span class="sc">;</span> 542 <span class="s">}</span> 543 <span class="k">if</span> <span class="s">(</span><span class="i">@ColNumsToExtract</span><span class="s">)</span> <span class="s">{</span> 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> 545 <span class="s">}</span> 546 <span class="k">else</span> <span class="s">{</span> 547 <span class="k">warn</span> <span class="q">"Warning: Ignoring file $TextFile: None of the columns specified, @{$OptionsInfo{SpecifiedColumns}}, using \"--columns\" option exist\n"</span><span class="sc">;</span> 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> 549 <span class="s">}</span> 550 <span class="s">}</span> 551 <span class="s">}</span> 552 <span class="s">}</span> 553 <span class="s">}</span> 554 555 <span class="c"># Process specified rows info...</span> <a name="ProcessRowsInfo-"></a> 556 <span class="k">sub </span><span class="m">ProcessRowsInfo</span> <span class="s">{</span> 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> 558 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> 560 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> 562 <span class="i">$TextFile</span> = <span class="i">$TextFilesList</span>[<span class="i">$Index</span>]<span class="sc">;</span> 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> 564 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> 566 <span class="k">next</span> <span class="j">FILELIST</span><span class="sc">;</span> 567 <span class="s">}</span> 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> 569 <span class="k">next</span> <span class="j">FILELIST</span><span class="sc">;</span> 570 <span class="s">}</span> 571 572 <span class="i">@RowValues</span> = <span class="s">(</span><span class="s">)</span><span class="sc">;</span> 573 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> 575 <span class="k">my</span><span class="s">(</span><span class="i">$ValueIndex</span><span class="s">)</span><span class="sc">;</span> 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> < <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> 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> 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> 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> 580 581 <span class="i">$ColIDOkay</span> = <span class="n">0</span><span class="sc">;</span> 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> 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> 584 <span class="i">$ColIDOkay</span> = <span class="n">1</span><span class="sc">;</span> 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> 586 <span class="s">}</span> 587 <span class="s">}</span> 588 <span class="k">else</span> <span class="s">{</span> 589 <span class="k">if</span> <span class="s">(</span><span class="i">$ColID</span> >=<span class="n">1</span> && <span class="i">$ColID</span> <= <span class="i">$TextFilesInfo</span>{<span class="w">ColCount</span>}[<span class="i">$Index</span>]<span class="s">)</span> <span class="s">{</span> 590 <span class="i">$ColNum</span> = <span class="i">$ColID</span> - <span class="n">1</span><span class="sc">;</span> 591 <span class="i">$ColIDOkay</span> = <span class="n">1</span><span class="sc">;</span> 592 <span class="s">}</span> 593 <span class="s">}</span> 594 <span class="k">if</span> <span class="s">(</span><span class="i">$ColIDOkay</span><span class="s">)</span> <span class="s">{</span> 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> 596 <span class="s">}</span> 597 <span class="s">}</span> 598 <span class="s">}</span> 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> 600 <span class="c"># Process coulumn id...</span> 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> 602 <span class="i">$ColIDOkay</span> = <span class="n">0</span><span class="sc">;</span> 603 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> 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> 606 <span class="i">$ColIDOkay</span> = <span class="n">1</span><span class="sc">;</span> 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> 608 <span class="s">}</span> 609 <span class="s">}</span> 610 <span class="k">else</span> <span class="s">{</span> 611 <span class="k">if</span> <span class="s">(</span><span class="i">$ColID</span> >=<span class="n">1</span> && <span class="i">$ColID</span> <= <span class="i">$TextFilesInfo</span>{<span class="w">ColCount</span>}[<span class="i">$Index</span>]<span class="s">)</span> <span class="s">{</span> 612 <span class="i">$ColIDOkay</span> = <span class="n">1</span><span class="sc">;</span> 613 <span class="i">$ColNum</span> = <span class="i">$ColID</span> - <span class="n">1</span><span class="sc">;</span> 614 <span class="s">}</span> 615 <span class="s">}</span> 616 <span class="k">if</span> <span class="s">(</span><span class="i">$ColIDOkay</span><span class="s">)</span> <span class="s">{</span> 617 <span class="k">push</span> <span class="i">@RowValues</span><span class="cm">,</span> <span class="i">$ColNum</span><span class="sc">;</span> 618 <span class="c"># Get rest of the specified values...</span> 619 <span class="k">if</span> <span class="s">(</span><span class="i">@</span>{<span class="i">$OptionsInfo</span>{<span class="w">SpecifiedRowValues</span>}} > <span class="n">1</span><span class="s">)</span> <span class="s">{</span> 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> 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> 622 <span class="s">}</span> 623 <span class="s">}</span> 624 <span class="s">}</span> 625 <span class="s">}</span> 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> 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> 628 <span class="s">}</span> 629 630 <span class="k">if</span> <span class="s">(</span><span class="i">@RowValues</span><span class="s">)</span> <span class="s">{</span> 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> 632 <span class="s">}</span> 633 <span class="k">else</span> <span class="s">{</span> 634 <span class="k">warn</span> <span class="q">"Warning: Ignoring file $TextFile: Column specified, $ColID, using \"--rows\" option doesn't exist\n"</span><span class="sc">;</span> 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> 636 <span class="s">}</span> 637 <span class="s">}</span> 638 <span class="s">}</span> 639 640 <span class="c"># Retrieve information about input text files...</span> <a name="RetrieveTextFilesInfo-"></a> 641 <span class="k">sub </span><span class="m">RetrieveTextFilesInfo</span> <span class="s">{</span> 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> 643 644 <span class="i">%TextFilesInfo</span> = <span class="s">(</span><span class="s">)</span><span class="sc">;</span> 645 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> 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> 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> 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> 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> 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> 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> 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> 654 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> 656 <span class="i">$TextFile</span> = <span class="i">$TextFilesList</span>[<span class="i">$Index</span>]<span class="sc">;</span> 657 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> 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> 660 <span class="i">$TextFilesInfo</span>{<span class="w">InDelim</span>}[<span class="i">$Index</span>] = <span class="q">""</span><span class="sc">;</span> 661 <span class="i">$TextFilesInfo</span>{<span class="w">OutFile</span>}[<span class="i">$Index</span>] = <span class="q">""</span><span class="sc">;</span> 662 <span class="i">$TextFilesInfo</span>{<span class="w">OutFileExt</span>}[<span class="i">$Index</span>] = <span class="q">""</span><span class="sc">;</span> 663 <span class="i">$TextFilesInfo</span>{<span class="w">CategoryOutFileRoot</span>}[<span class="i">$Index</span>] = <span class="q">""</span><span class="sc">;</span> 664 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> 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> 667 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> 669 <span class="k">warn</span> <span class="q">"Warning: Ignoring file $TextFile: It doesn't exist\n"</span><span class="sc">;</span> 670 <span class="k">next</span> <span class="j">FILELIST</span><span class="sc">;</span> 671 <span class="s">}</span> 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">"csv tsv"</span><span class="s">)</span><span class="s">)</span> <span class="s">{</span> 673 <span class="k">warn</span> <span class="q">"Warning: Ignoring file $TextFile: It's not a csv or tsv file\n"</span><span class="sc">;</span> 674 <span class="k">next</span> <span class="j">FILELIST</span><span class="sc">;</span> 675 <span class="s">}</span> 676 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> 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> 679 <span class="i">$InDelim</span> = <span class="q">"\t"</span><span class="sc">;</span> 680 <span class="s">}</span> 681 <span class="k">else</span> <span class="s">{</span> 682 <span class="i">$InDelim</span> = <span class="q">"\,"</span><span class="sc">;</span> 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> 684 <span class="k">warn</span> <span class="q">"Warning: Ignoring file $TextFile: The value specified, $OptionsInfo{InDelim}, for option \"--indelim\" is not valid for csv files\n"</span><span class="sc">;</span> 685 <span class="k">next</span> <span class="j">FILELIST</span><span class="sc">;</span> 686 <span class="s">}</span> 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> 688 <span class="i">$InDelim</span> = <span class="q">"\;"</span><span class="sc">;</span> 689 <span class="s">}</span> 690 <span class="s">}</span> 691 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">"$TextFile"</span><span class="s">)</span> <span class="s">{</span> 693 <span class="k">warn</span> <span class="q">"Warning: Ignoring file $TextFile: Couldn't open it: $! \n"</span><span class="sc">;</span> 694 <span class="k">next</span> <span class="j">FILELIST</span><span class="sc">;</span> 695 <span class="s">}</span> 696 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> 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> 699 <span class="k">close</span> <span class="w">TEXTFILE</span><span class="sc">;</span> 700 701 <span class="i">$FileDir</span> = <span class="q">""</span><span class="sc">;</span> <span class="i">$FileName</span> = <span class="q">""</span><span class="sc">;</span> <span class="i">$FileExt</span> = <span class="q">""</span><span class="sc">;</span> 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> 703 <span class="i">$FileExt</span> = <span class="q">"csv"</span><span class="sc">;</span> 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> 705 <span class="i">$FileExt</span> = <span class="q">"tsv"</span><span class="sc">;</span> 706 <span class="s">}</span> 707 708 <span class="k">if</span> <span class="s">(</span><span class="i">$OptionsInfo</span>{<span class="w">OutFileRoot</span>} && <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> 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> 710 <span class="k">if</span> <span class="s">(</span><span class="i">$RootFileName</span> && <span class="i">$RootFileExt</span><span class="s">)</span> <span class="s">{</span> 711 <span class="i">$FileName</span> = <span class="i">$RootFileName</span><span class="sc">;</span> 712 <span class="s">}</span> 713 <span class="k">else</span> <span class="s">{</span> 714 <span class="i">$FileName</span> = <span class="i">$OptionsInfo</span>{<span class="w">OutFileRoot</span>}<span class="sc">;</span> 715 <span class="s">}</span> 716 <span class="i">$OutFileRoot</span> .= <span class="i">$FileName</span><span class="sc">;</span> 717 <span class="s">}</span> 718 <span class="k">else</span> <span class="s">{</span> 719 <span class="i">$OutFileRoot</span> = <span class="i">$FileName</span><span class="sc">;</span> 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">"CategoriesSummary"</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">"ExtractedRows"</span> <span class="co">:</span> <span class="q">"ExtractedColumns"</span><span class="s">)</span><span class="sc">;</span> 721 <span class="s">}</span> 722 <span class="i">$CategoryOutFileRoot</span> = <span class="q">"$FileName"</span> . <span class="q">"Category"</span><span class="sc">;</span> 723 724 <span class="i">$OutFile</span> = <span class="i">$OutFileRoot</span> . <span class="q">".$FileExt"</span><span class="sc">;</span> 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> 726 <span class="k">warn</span> <span class="q">"Warning: Ignoring file $TextFile:Output file name, $OutFile, is same as input text file name, $TextFile\n"</span><span class="sc">;</span> 727 <span class="k">next</span> <span class="j">FILELIST</span><span class="sc">;</span> 728 <span class="s">}</span> 729 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> 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> 732 <span class="k">warn</span> <span class="q">"Warning: Ignoring file $TextFile: The file $OutFile already exists\n"</span><span class="sc">;</span> 733 <span class="k">next</span> <span class="j">FILELIST</span><span class="sc">;</span> 734 <span class="s">}</span> 735 <span class="s">}</span> 736 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> 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> 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> 740 <span class="i">$TextFilesInfo</span>{<span class="w">OutFile</span>}[<span class="i">$Index</span>] = <span class="q">"$OutFile"</span><span class="sc">;</span> 741 <span class="i">$TextFilesInfo</span>{<span class="w">OutFileExt</span>}[<span class="i">$Index</span>] = <span class="q">"$FileExt"</span><span class="sc">;</span> 742 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> 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> 745 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> 747 <span class="i">$ColLabel</span> = <span class="i">$ColLabels</span>[<span class="i">$ColNum</span>]<span class="sc">;</span> 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> 749 <span class="s">}</span> 750 <span class="s">}</span> 751 <span class="s">}</span> 752 753 <span class="c"># Process option values...</span> <a name="ProcessOptions-"></a> 754 <span class="k">sub </span><span class="m">ProcessOptions</span> <span class="s">{</span> 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> 756 757 <span class="i">%OptionsInfo</span> = <span class="s">(</span><span class="s">)</span><span class="sc">;</span> 758 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> 760 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> 762 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> 764 <span class="i">$OptionsInfo</span>{<span class="w">SpecifiedCategoryCol</span>} = <span class="q">""</span><span class="sc">;</span> 765 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> 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">","</span><span class="cm">,</span> <span class="i">$Options</span>{<span class="w">categorycol</span>}<span class="sc">;</span> 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> 769 <span class="k">die</span> <span class="q">"Error: Invalid number of values, "</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">" using \"--categorycol\" option: Only one value is allowed.\n"</span><span class="sc">;</span> 770 <span class="s">}</span> 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> 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> 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> 774 <span class="k">die</span> <span class="q">"Error: Category column value, $OptionsInfo{SpecifiedCategoryCol}, specified using \"--categorycol\" is not valid. Allowed integer values: > 0.\n"</span><span class="sc">;</span> 775 <span class="s">}</span> 776 <span class="s">}</span> 777 <span class="s">}</span> 778 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> 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> 781 <span class="i">@SpecifiedColumns</span> = <span class="s">(</span><span class="s">)</span><span class="sc">;</span> 782 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> 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">","</span><span class="cm">,</span> <span class="i">$Options</span>{<span class="w">columns</span>}<span class="sc">;</span> 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> 786 <span class="k">my</span><span class="s">(</span><span class="i">$ColValue</span><span class="s">)</span><span class="sc">;</span> 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> 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> 789 <span class="k">die</span> <span class="q">"Error: Column value, $ColValue, specified using \"--columns\" is not valid: Allowed integer values: > 0.\n"</span><span class="sc">;</span> 790 <span class="s">}</span> 791 <span class="s">}</span> 792 <span class="s">}</span> 793 <span class="k">push</span> <span class="i">@SpecifiedColumns</span><span class="cm">,</span> <span class="i">@SpecifiedValues</span><span class="sc">;</span> 794 <span class="s">}</span> 795 <span class="i">@</span>{<span class="i">$OptionsInfo</span>{<span class="w">SpecifiedColumns</span>}} = <span class="i">@SpecifiedColumns</span><span class="sc">;</span> 796 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> 798 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">"\t"</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">"\;"</span> <span class="co">:</span> <span class="q">"\,"</span><span class="s">)</span><span class="sc">;</span> 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> 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> 802 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> 804 805 <span class="c"># Process any specified rows values...</span> 806 <span class="i">@SpecifiedRowValues</span> = <span class="s">(</span><span class="s">)</span><span class="sc">;</span> 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> 808 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> 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> 811 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> 813 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> 815 <span class="s">(</span><span class="i">@SpecifiedRowValues</span><span class="s">)</span> = <span class="k">split</span> <span class="q">","</span><span class="cm">,</span> <span class="i">$Options</span>{<span class="w">rows</span>}<span class="sc">;</span> 816 <span class="s">}</span> 817 <span class="k">else</span> <span class="s">{</span> 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> 819 <span class="k">die</span> <span class="q">"Error: Specify value for \"--rows\" option with \"--rowsmode\" value of $Options{rowsmode}.\n"</span><span class="sc">;</span> 820 <span class="s">}</span> 821 <span class="k">push</span> <span class="i">@SpecifiedRowValues</span><span class="cm">,</span> <span class="q">"1"</span><span class="sc">;</span> 822 <span class="s">}</span> 823 <span class="i">@</span>{<span class="i">$OptionsInfo</span>{<span class="w">SpecifiedRowValues</span>}} = <span class="i">@SpecifiedRowValues</span><span class="sc">;</span> 824 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> 826 <span class="c"># Make sure specified values are okay...</span> 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> 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> 829 <span class="k">die</span> <span class="q">"Error: Invalid number of values, "</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">", specified by \"--rows\" option with \"--rowsmode\" value of $Options{rowsmode}.\nIt must contain triplets.\n"</span><span class="sc">;</span> 830 <span class="s">}</span> 831 <span class="c"># Triplet format: colid,value,criteria. Criterion: le,ge,eq</span> 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> 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> < <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> 834 <span class="i">$ColID</span> = <span class="i">$SpecifiedRowValues</span>[<span class="i">$Index</span>]<span class="sc">;</span> 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> 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> 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> 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> 839 <span class="k">die</span> <span class="q">"Error: Invalid column id, $ColID, specified in triplet, \"$ColID,$Criterion,$Value\", using \"--rows\" option with \"--rowsmode\" value of $Options{rowsmode} is not valid. Allowed integer values: > 0.\n"</span><span class="sc">;</span> 840 <span class="s">}</span> 841 <span class="s">}</span> 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> 843 <span class="k">die</span> <span class="q">"Error: Invalid criterion value, $Criterion, specified in triplet, \"$ColID,$Criterion,$Value\", using \"--rows\" option with \"--rowsmode\" value of $Options{rowsmode} is not valid. Allowed values: le, ge, or eq.\n"</span><span class="sc">;</span> 844 <span class="s">}</span> 845 <span class="s">}</span> 846 <span class="s">}</span> 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> 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> 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> 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> 851 <span class="k">die</span> <span class="q">"Error: Rows value, $SpecifiedColID, specified using \"--rows\" option with \"--rowsmode\" value of $Options{rowsmode} is not valid. Allowed integer values: > 0.\n"</span><span class="sc">;</span> 852 <span class="s">}</span> 853 <span class="s">}</span> 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> 855 <span class="k">die</span> <span class="q">"Error: Invalid number of values, "</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">", specified by \"--rows\" option with \"--rowsmode\" value of $Options{rowsmode}.\nIt must contain more than one value\n"</span><span class="sc">;</span> 856 <span class="s">}</span> 857 <span class="s">}</span> 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> 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> 860 <span class="k">die</span> <span class="q">"Error: Invalid number of values, "</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">", specified by \"--rows\" option with \"--rowsmode\" value of $Options{rowsmode}.\nIt must contain three values\n"</span><span class="sc">;</span> 861 <span class="s">}</span> 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> 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> 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> 865 <span class="k">die</span> <span class="q">"Error: Rows value, $SpecifiedColID, specified using \"--rows\" option with \"--rowsmode\" value of $Options{rowsmode} is not valid. Allowed integer values: > 0.\n"</span><span class="sc">;</span> 866 <span class="s">}</span> 867 <span class="s">}</span> 868 <span class="k">if</span> <span class="s">(</span><span class="i">$SpecifiedRowValues</span>[<span class="n">1</span>] >= <span class="i">$SpecifiedRowValues</span>[<span class="n">2</span>]<span class="s">)</span> <span class="s">{</span> 869 <span class="k">die</span> <span class="q">"Error: Invalid value triplet - "</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">','</span><span class="cm">,</span> <span class="n">0</span><span class="s">)</span> <span class="cm">,</span> <span class="q">" - specified by \"--rows\" option with \"--rowsmode\" value of $Options{rowsmode}.\nAllowed values: second value < third value\n"</span><span class="sc">;</span> 870 <span class="s">}</span> 871 <span class="s">}</span> 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> 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> 874 <span class="k">die</span> <span class="q">"Error: Invalid number of values, "</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">", specified by \"--rows\" option with \"--rowsmode\" value of $Options{rowsmode}.\nOnly one value is allowed.\n"</span><span class="sc">;</span> 875 <span class="s">}</span> 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> 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> 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> 879 <span class="k">die</span> <span class="q">"Error: Rows value, $SpecifiedColID, specified using \"--rows\" option with \"--rowsmode\" value of $Options{rowsmode} is not valid. Allowed integer values: > 0.\n"</span><span class="sc">;</span> 880 <span class="s">}</span> 881 <span class="s">}</span> 882 <span class="s">}</span> 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> 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> 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> 886 <span class="k">die</span> <span class="q">"Error: Rows value, $SpecifiedRowID, specified using \"--rows\" option with \"--rowsmode\" value of $Options{rowsmode} is not valid. Allowed integer values: > 0.\n"</span><span class="sc">;</span> 887 <span class="s">}</span> 888 <span class="s">}</span> 889 <span class="s">}</span> 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> 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> 892 <span class="k">die</span> <span class="q">"Error: Invalid number of values, "</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">", specified by \"--rows\" option with \"--rowsmode\" value of $Options{rowsmode}.\nIt must contain only two values.\n"</span><span class="sc">;</span> 893 <span class="s">}</span> 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> 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> 896 <span class="k">die</span> <span class="q">"Error: Rows value, $SpecifiedRowID, specified using \"--rows\" option with \"--rowsmode\" value of $Options{rowsmode} is not valid. Allowed integer values: > 0.\n"</span><span class="sc">;</span> 897 <span class="s">}</span> 898 <span class="s">}</span> 899 <span class="k">if</span> <span class="s">(</span><span class="i">$SpecifiedRowValues</span>[<span class="n">0</span>] >= <span class="i">$SpecifiedRowValues</span>[<span class="n">1</span>]<span class="s">)</span> <span class="s">{</span> 900 <span class="k">die</span> <span class="q">"Error: Invalid value pair - "</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">','</span><span class="cm">,</span> <span class="n">0</span><span class="s">)</span> <span class="cm">,</span> <span class="q">" - specified by \"--rows\" option with \"--rowsmode\" value of $Options{rowsmode}.\nAllowed values: First value < second value\n"</span><span class="sc">;</span> 901 <span class="s">}</span> 902 <span class="s">}</span> 903 <span class="s">}</span> 904 905 <span class="c"># Setup script usage and retrieve command line arguments specified using various options...</span> <a name="SetupScriptUsage-"></a> 906 <span class="k">sub </span><span class="m">SetupScriptUsage</span> <span class="s">{</span> 907 908 <span class="c"># Setup default and retrieve all the options...</span> 909 <span class="i">%Options</span> = <span class="s">(</span><span class="s">)</span><span class="sc">;</span> 910 <span class="i">$Options</span>{<span class="w">colmode</span>} = <span class="q">"colnum"</span><span class="sc">;</span> 911 <span class="i">$Options</span>{<span class="w">indelim</span>} = <span class="q">"comma"</span><span class="sc">;</span> 912 <span class="i">$Options</span>{<span class="w">mode</span>} = <span class="q">"columns"</span><span class="sc">;</span> 913 <span class="i">$Options</span>{<span class="w">outdelim</span>} = <span class="q">"comma"</span><span class="sc">;</span> 914 <span class="i">$Options</span>{<span class="w">quote</span>} = <span class="q">"yes"</span><span class="sc">;</span> 915 <span class="i">$Options</span>{<span class="w">rowsmode</span>} = <span class="q">"rownums"</span><span class="sc">;</span> 916 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">"categorycol=s"</span><span class="cm">,</span> <span class="q">"columns=s"</span><span class="cm">,</span> <span class="q">"colmode|c=s"</span><span class="cm">,</span> <span class="q">"help|h"</span><span class="cm">,</span> <span class="q">"indelim=s"</span><span class="cm">,</span> <span class="q">"mode|m=s"</span><span class="cm">,</span> <span class="q">"outdelim=s"</span><span class="cm">,</span> <span class="q">"overwrite|o"</span><span class="cm">,</span> <span class="q">"quote|q=s"</span><span class="cm">,</span> <span class="q">"root|r=s"</span><span class="cm">,</span> <span class="q">"rows=s"</span><span class="cm">,</span> <span class="q">"rowsmode=s"</span><span class="cm">,</span> <span class="q">"workingdir|w=s"</span><span class="s">)</span><span class="s">)</span> <span class="s">{</span> 918 <span class="k">die</span> <span class="q">"\nTo get a list of valid options and their values, use \"$ScriptName -h\" or\n\"perl -S $ScriptName -h\" command and try again...\n"</span><span class="sc">;</span> 919 <span class="s">}</span> 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> 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> 922 <span class="k">die</span> <span class="q">"Error: The value specified, $Options{workingdir}, for option \"-w --workingdir\" is not a directory name.\n"</span><span class="sc">;</span> 923 <span class="s">}</span> 924 <span class="k">chdir</span> <span class="i">$Options</span>{<span class="w">workingdir</span>} || <span class="k">die</span> <span class="q">"Error: Couldn't chdir $Options{workingdir}: $! \n"</span><span class="sc">;</span> 925 <span class="s">}</span> 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> 927 <span class="k">die</span> <span class="q">"Error: The value specified, $Options{mode}, for option \"-m --mode\" is not valid. Allowed values: columns, rows or categories \n"</span><span class="sc">;</span> 928 <span class="s">}</span> 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> 930 <span class="k">die</span> <span class="q">"Error: The value specified, $Options{colmode}, for option \"--colmode\" is not valid. Allowed values: colnum or collabel \n"</span><span class="sc">;</span> 931 <span class="s">}</span> 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> 933 <span class="k">die</span> <span class="q">"Error: The value specified, $Options{indelim}, for option \"--indelim\" is not valid. Allowed values: comma or semicolon\n"</span><span class="sc">;</span> 934 <span class="s">}</span> 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> 936 <span class="k">die</span> <span class="q">"Error: The value specified, $Options{outdelim}, for option \"--outdelim\" is not valid. Allowed values: comma, tab, or semicolon\n"</span><span class="sc">;</span> 937 <span class="s">}</span> 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> 939 <span class="k">die</span> <span class="q">"Error: The value specified, $Options{quote}, for option \"-q --quote\" is not valid. Allowed values: yes or no\n"</span><span class="sc">;</span> 940 <span class="s">}</span> 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> 942 <span class="k">die</span> <span class="q">"Error: The value specified, $Options{rowsmode}, for option \"--rowsmode\" is not valid. Allowed values: rowsbycolvalue, rowsbycolvaluelist, rowsbycolvaluerange, rowbymincolvalue, rowbymaxcolvalue, rownum, rownumrange\n"</span><span class="sc">;</span> 943 <span class="s">}</span> 944 <span class="s">}</span> <a name="EOF-"></a></pre> <p> </p> <br /> <center> <img src="../../../images/h2o2.png"> </center> </body> </html>