Mercurial > repos > deepakjadmin > mayatool3_test2
diff 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 diff
--- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/docs/scripts/html/code/ExtractFromTextFiles.html Wed Jan 20 09:23:18 2016 -0500 @@ -0,0 +1,965 @@ +<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>