diff docs/scripts/html/code/SortTextFiles.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/SortTextFiles.html	Wed Jan 20 09:23:18 2016 -0500
@@ -0,0 +1,431 @@
+<html>
+<head>
+<title>MayaChemTools:Code:SortTextFiles.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: SortTextFiles.pl,v $</span>
+   4 <span class="c"># $Date: 2015/02/28 20:46:21 $</span>
+   5 <span class="c"># $Revision: 1.36 $</span>
+   6 <span class="c">#</span>
+   7 <span class="c"># Author: Manish Sud &lt;msud@san.rr.com&gt;</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 &lt;http://www.gnu.org/licenses/&gt; 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">&quot;$FindBin::Bin/../lib&quot;</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">Benchmark</span><span class="sc">;</span>
+  35 <span class="k">use</span> <span class="w">FileUtil</span><span class="sc">;</span>
+  36 <span class="k">use</span> <span class="w">TextUtil</span><span class="sc">;</span>
+  37 
+  38 <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>
+  39 
+  40 <span class="c"># Autoflush STDOUT</span>
+  41 <span class="i">$|</span> = <span class="n">1</span><span class="sc">;</span>
+  42 
+  43 <span class="c"># Starting message...</span>
+  44 <span class="i">$ScriptName</span> = <span class="i">basename</span><span class="s">(</span><span class="i">$0</span><span class="s">)</span><span class="sc">;</span>
+  45 <span class="k">print</span> <span class="q">&quot;\n$ScriptName: Starting...\n\n&quot;</span><span class="sc">;</span>
+  46 <span class="i">$StartTime</span> = <span class="w">new</span> <span class="w">Benchmark</span><span class="sc">;</span>
+  47 
+  48 <span class="c"># Get the options and setup script...</span>
+  49 <span class="i">SetupScriptUsage</span><span class="s">(</span><span class="s">)</span><span class="sc">;</span>
+  50 <span class="k">if</span> <span class="s">(</span><span class="i">$Options</span>{<span class="w">help</span>} || <span class="i">@ARGV</span> &lt; <span class="n">1</span><span class="s">)</span> <span class="s">{</span>
+  51   <span class="k">die</span> <span class="i">GetUsageFromPod</span><span class="s">(</span><span class="q">&quot;$FindBin::Bin/$ScriptName&quot;</span><span class="s">)</span><span class="sc">;</span>
+  52 <span class="s">}</span>
+  53 
+  54 <span class="k">my</span><span class="s">(</span><span class="i">@TextFilesList</span><span class="s">)</span><span class="sc">;</span>
+  55 <span class="i">@TextFilesList</span> = <span class="i">ExpandFileNames</span><span class="s">(</span>\<span class="i">@ARGV</span><span class="cm">,</span> <span class="q">&quot;csv tsv&quot;</span><span class="s">)</span><span class="sc">;</span>
+  56 
+  57 <span class="k">print</span> <span class="q">&quot;Processing options...\n&quot;</span><span class="sc">;</span>
+  58 <span class="k">my</span><span class="s">(</span><span class="i">%OptionsInfo</span><span class="s">)</span><span class="sc">;</span>
+  59 <span class="i">ProcessOptions</span><span class="s">(</span><span class="s">)</span><span class="sc">;</span>
+  60 
+  61 <span class="k">print</span> <span class="q">&quot;Checking input text file(s)...\n&quot;</span><span class="sc">;</span>
+  62 <span class="k">my</span><span class="s">(</span><span class="i">%TextFilesInfo</span><span class="s">)</span><span class="sc">;</span>
+  63 <span class="i">RetrieveTextFilesInfo</span><span class="s">(</span><span class="s">)</span><span class="sc">;</span>
+  64 <span class="i">ProcessColumnsInfo</span><span class="s">(</span><span class="s">)</span><span class="sc">;</span>
+  65 
+  66 <span class="c"># Generate output files...</span>
+  67 <span class="k">my</span><span class="s">(</span><span class="i">$FileIndex</span><span class="s">)</span><span class="sc">;</span>
+  68 <span class="k">if</span> <span class="s">(</span><span class="i">@TextFilesList</span> &gt; <span class="n">1</span><span class="s">)</span> <span class="s">{</span>
+  69   <span class="k">print</span> <span class="q">&quot;\nProcessing text files...\n&quot;</span><span class="sc">;</span>
+  70 <span class="s">}</span>
+  71 <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>
+  72   <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>
+  73     <span class="k">print</span> <span class="q">&quot;\nProcessing file $TextFilesList[$FileIndex]...\n&quot;</span><span class="sc">;</span>
+  74     <span class="i">SortTextFile</span><span class="s">(</span><span class="i">$FileIndex</span><span class="s">)</span><span class="sc">;</span>
+  75   <span class="s">}</span>
+  76 <span class="s">}</span>
+  77 <span class="k">print</span> <span class="q">&quot;\n$ScriptName:Done...\n\n&quot;</span><span class="sc">;</span>
+  78 
+  79 <span class="i">$EndTime</span> = <span class="w">new</span> <span class="w">Benchmark</span><span class="sc">;</span>
+  80 <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>
+  81 <span class="k">print</span> <span class="q">&quot;Total time: &quot;</span><span class="cm">,</span> <span class="i">timestr</span><span class="s">(</span><span class="i">$TotalTime</span><span class="s">)</span><span class="cm">,</span> <span class="q">&quot;\n&quot;</span><span class="sc">;</span>
+  82 
+  83 <span class="c">###############################################################################</span>
+  84 
+  85 <span class="c"># Sort it out...</span>
+<a name="SortTextFile-"></a>  86 <span class="k">sub </span><span class="m">SortTextFile</span> <span class="s">{</span>
+  87   <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>
+  88   <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">$KeyCol</span><span class="cm">,</span> <span class="i">$Line</span><span class="cm">,</span> <span class="i">$KeyColValue</span><span class="cm">,</span> <span class="i">$InDelim</span><span class="cm">,</span> <span class="i">@ColLabels</span><span class="cm">,</span> <span class="i">@LineWords</span><span class="s">)</span><span class="sc">;</span>
+  89 
+  90   <span class="i">$TextFile</span> = <span class="i">$TextFilesList</span>[<span class="i">$Index</span>]<span class="sc">;</span>
+  91   <span class="i">$InDelim</span> = <span class="i">$TextFilesInfo</span>{<span class="w">InDelim</span>}[<span class="i">$Index</span>]<span class="sc">;</span>
+  92   <span class="i">$NewTextFile</span> = <span class="i">$TextFilesInfo</span>{<span class="w">OutFile</span>}[<span class="i">$Index</span>]<span class="sc">;</span>
+  93   <span class="i">$KeyCol</span> = <span class="i">$TextFilesInfo</span>{<span class="w">KeyColNum</span>}[<span class="i">$Index</span>]<span class="sc">;</span>
+  94   <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>
+  95 
+  96   <span class="k">print</span> <span class="q">&quot;Generating new Text file $NewTextFile...\n&quot;</span><span class="sc">;</span>
+  97   <span class="k">open</span> <span class="w">NEWTEXTFILE</span><span class="cm">,</span> <span class="q">&quot;&gt;$NewTextFile&quot;</span> <span class="k">or</span> <span class="k">die</span> <span class="q">&quot;Error: Couldn&#39;t open $NewTextFile: $! \n&quot;</span><span class="sc">;</span>
+  98   <span class="k">open</span> <span class="w">TEXTFILE</span><span class="cm">,</span> <span class="q">&quot;$TextFile&quot;</span> <span class="k">or</span> <span class="k">die</span> <span class="q">&quot;Error: Can&#39;t open $TextFile: $! \n&quot;</span><span class="sc">;</span>
+  99 
+ 100   <span class="c"># Skip over column labels from old file...</span>
+ 101   <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>
+ 102 
+ 103   <span class="c"># Add column lablels in new file...</span>
+ 104   <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>
+ 105   <span class="k">print</span> <span class="i">NEWTEXTFILE</span> <span class="q">&quot;$Line\n&quot;</span><span class="sc">;</span>
+ 106 
+ 107   <span class="c"># Go over all rows and store the lines using key value as hash...</span>
+ 108   <span class="k">my</span><span class="s">(</span><span class="i">%KeyToLinesMap</span><span class="cm">,</span> <span class="i">@InvalidDataLines</span><span class="cm">,</span> <span class="i">$LineCount</span><span class="s">)</span><span class="sc">;</span>
+ 109 
+ 110   <span class="i">%KeyToLinesMap</span> = <span class="s">(</span><span class="s">)</span><span class="sc">;</span>
+ 111   <span class="i">@InvalidDataLines</span> = <span class="s">(</span><span class="s">)</span><span class="sc">;</span>
+ 112   <span class="i">$LineCount</span> = <span class="n">1</span><span class="sc">;</span>
+ 113   <span class="j">TEXTLINE:</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">*TEXTFILE</span><span class="s">)</span><span class="s">)</span> <span class="s">{</span>
+ 114     <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>
+ 115     <span class="i">$LineCount</span>++<span class="sc">;</span>
+ 116     <span class="k">if</span> <span class="s">(</span><span class="i">$KeyCol</span> &lt; <span class="i">@LineWords</span><span class="s">)</span> <span class="s">{</span>
+ 117       <span class="i">$KeyColValue</span> = <span class="i">$LineWords</span>[<span class="i">$KeyCol</span>]<span class="sc">;</span>
+ 118       <span class="k">if</span> <span class="s">(</span>!<span class="i">IsNotEmpty</span><span class="s">(</span><span class="i">$KeyColValue</span><span class="s">)</span><span class="s">)</span> <span class="s">{</span>
+ 119         <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>
+ 120         <span class="k">push</span> <span class="i">@InvalidDataLines</span><span class="cm">,</span> <span class="i">$Line</span><span class="sc">;</span>
+ 121         <span class="k">if</span> <span class="s">(</span><span class="i">$OptionsInfo</span>{<span class="w">DetailLevel</span>} &gt;= <span class="n">3</span> <span class="s">)</span> <span class="s">{</span>
+ 122           <span class="k">print</span> <span class="q">&quot;Ignoring line $LineCount: Contains empty value for key column $ColLabels[$KeyCol]: $Line\n&quot;</span><span class="sc">;</span>
+ 123         <span class="s">}</span>
+ 124         <span class="k">elsif</span> <span class="s">(</span><span class="i">$OptionsInfo</span>{<span class="w">DetailLevel</span>} &gt;= <span class="n">2</span><span class="s">)</span> <span class="s">{</span>
+ 125           <span class="k">print</span> <span class="q">&quot;Ignoring line $LineCount: Contains empty value for key column $ColLabels[$KeyCol]...\n&quot;</span><span class="sc">;</span>
+ 126         <span class="s">}</span>
+ 127         <span class="k">next</span> <span class="j">TEXTLINE</span><span class="sc">;</span>
+ 128       <span class="s">}</span>
+ 129       <span class="k">if</span> <span class="s">(</span><span class="i">$OptionsInfo</span>{<span class="w">KeyData</span>} =~ <span class="q">/^numeric$/i</span><span class="s">)</span> <span class="s">{</span>
+ 130         <span class="k">if</span> <span class="s">(</span>!<span class="i">IsFloat</span><span class="s">(</span><span class="i">$KeyColValue</span><span class="s">)</span><span class="s">)</span> <span class="s">{</span>
+ 131           <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>
+ 132           <span class="k">push</span> <span class="i">@InvalidDataLines</span><span class="cm">,</span> <span class="i">$Line</span><span class="sc">;</span>
+ 133           <span class="k">if</span> <span class="s">(</span><span class="i">$OptionsInfo</span>{<span class="w">DetailLevel</span>} &gt;= <span class="n">3</span> <span class="s">)</span> <span class="s">{</span>
+ 134             <span class="k">print</span> <span class="q">&quot;Line number $LineCount: Contains non-numerical value for key column $ColLabels[$KeyCol]: $Line\n&quot;</span><span class="sc">;</span>
+ 135           <span class="s">}</span>
+ 136           <span class="k">elsif</span> <span class="s">(</span><span class="i">$OptionsInfo</span>{<span class="w">DetailLevel</span>} &gt;= <span class="n">2</span><span class="s">)</span> <span class="s">{</span>
+ 137             <span class="k">print</span> <span class="q">&quot;Line number $LineCount: Contains non-numerical value for key column $ColLabels[$KeyCol]...\n&quot;</span><span class="sc">;</span>
+ 138           <span class="s">}</span>
+ 139           <span class="k">next</span> <span class="j">TEXTLINE</span><span class="sc">;</span>
+ 140         <span class="s">}</span>
+ 141       <span class="s">}</span>
+ 142       <span class="k">if</span> <span class="s">(</span><span class="k">exists</span><span class="s">(</span><span class="i">$KeyToLinesMap</span>{<span class="i">$KeyColValue</span>}<span class="s">)</span><span class="s">)</span> <span class="s">{</span>
+ 143         <span class="c"># Append to existing line...</span>
+ 144         <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>
+ 145         <span class="i">$KeyToLinesMap</span>{<span class="i">$KeyColValue</span>} .= <span class="q">&quot;\n&quot;</span> . <span class="i">$Line</span><span class="sc">;</span>
+ 146       <span class="s">}</span>
+ 147       <span class="k">else</span> <span class="s">{</span>
+ 148         <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>
+ 149         <span class="i">$KeyToLinesMap</span>{<span class="i">$KeyColValue</span>} = <span class="i">$Line</span><span class="sc">;</span>
+ 150       <span class="s">}</span>
+ 151     <span class="s">}</span>
+ 152   <span class="s">}</span>
+ 153   <span class="k">if</span> <span class="s">(</span><span class="i">$OptionsInfo</span>{<span class="w">Sort</span>} =~ <span class="q">/^ascending$/i</span><span class="s">)</span> <span class="s">{</span>
+ 154     <span class="k">if</span> <span class="s">(</span><span class="i">$OptionsInfo</span>{<span class="w">KeyData</span>} =~ <span class="q">/^alphanumeric$/i</span><span class="s">)</span> <span class="s">{</span>
+ 155       <span class="k">for</span> <span class="i">$KeyColValue</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">%KeyToLinesMap</span> <span class="s">)</span> <span class="s">{</span>
+ 156         <span class="k">print</span> <span class="i">NEWTEXTFILE</span> <span class="q">&quot;$KeyToLinesMap{$KeyColValue}\n&quot;</span><span class="sc">;</span>
+ 157       <span class="s">}</span>
+ 158     <span class="s">}</span>
+ 159     <span class="k">else</span> <span class="s">{</span>
+ 160       <span class="k">for</span> <span class="i">$KeyColValue</span> <span class="s">(</span><span class="k">sort</span> <span class="s">{</span> <span class="i">$a</span> &lt;=&gt; <span class="i">$b</span> <span class="s">}</span> <span class="k">keys</span> <span class="i">%KeyToLinesMap</span> <span class="s">)</span> <span class="s">{</span>
+ 161         <span class="k">print</span> <span class="i">NEWTEXTFILE</span> <span class="q">&quot;$KeyToLinesMap{$KeyColValue}\n&quot;</span><span class="sc">;</span>
+ 162       <span class="s">}</span>
+ 163     <span class="s">}</span>
+ 164   <span class="s">}</span>
+ 165   <span class="k">else</span> <span class="s">{</span>
+ 166     <span class="k">if</span> <span class="s">(</span><span class="i">$OptionsInfo</span>{<span class="w">KeyData</span>} =~ <span class="q">/^alphanumeric$/i</span><span class="s">)</span> <span class="s">{</span>
+ 167       <span class="k">for</span> <span class="i">$KeyColValue</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">$b</span><span class="s">)</span> <span class="k">cmp</span> <span class="k">lc</span><span class="s">(</span><span class="i">$a</span><span class="s">)</span> <span class="s">}</span> <span class="k">keys</span> <span class="i">%KeyToLinesMap</span> <span class="s">)</span> <span class="s">{</span>
+ 168         <span class="k">print</span> <span class="i">NEWTEXTFILE</span> <span class="q">&quot;$KeyToLinesMap{$KeyColValue}\n&quot;</span><span class="sc">;</span>
+ 169       <span class="s">}</span>
+ 170     <span class="s">}</span>
+ 171     <span class="k">else</span> <span class="s">{</span>
+ 172       <span class="k">for</span> <span class="i">$KeyColValue</span> <span class="s">(</span><span class="k">sort</span> <span class="s">{</span> <span class="i">$b</span> &lt;=&gt; <span class="i">$a</span> <span class="s">}</span> <span class="k">keys</span> <span class="i">%KeyToLinesMap</span> <span class="s">)</span> <span class="s">{</span>
+ 173         <span class="k">print</span> <span class="i">NEWTEXTFILE</span> <span class="q">&quot;$KeyToLinesMap{$KeyColValue}\n&quot;</span><span class="sc">;</span>
+ 174       <span class="s">}</span>
+ 175     <span class="s">}</span>
+ 176   <span class="s">}</span>
+ 177   <span class="c"># Write out the lines with invalid data...</span>
+ 178   <span class="k">if</span> <span class="s">(</span><span class="i">@InvalidDataLines</span><span class="s">)</span> <span class="s">{</span>
+ 179     <span class="k">print</span> <span class="q">&quot;Placing &quot;</span><span class="cm">,</span> <span class="k">scalar</span><span class="s">(</span><span class="i">@InvalidDataLines</span><span class="s">)</span><span class="cm">,</span><span class="q">&quot; line(s) with invalid column key data at the end...\n&quot;</span><span class="sc">;</span>
+ 180     <span class="k">for</span> <span class="i">$Line</span> <span class="s">(</span><span class="i">@InvalidDataLines</span><span class="s">)</span> <span class="s">{</span>
+ 181       <span class="k">print</span> <span class="i">NEWTEXTFILE</span> <span class="q">&quot;$Line\n&quot;</span><span class="sc">;</span>
+ 182     <span class="s">}</span>
+ 183   <span class="s">}</span>
+ 184   <span class="k">close</span> <span class="w">NEWTEXTFILE</span><span class="sc">;</span>
+ 185   <span class="k">close</span> <span class="w">TEXTFILE</span><span class="sc">;</span>
+ 186 
+ 187 <span class="s">}</span>
+ 188 
+ 189 <span class="c"># Retrieve information about input text files...</span>
+<a name="RetrieveTextFilesInfo-"></a> 190 <span class="k">sub </span><span class="m">RetrieveTextFilesInfo</span> <span class="s">{</span>
+ 191   <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">$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>
+ 192 
+ 193   <span class="i">%TextFilesInfo</span> = <span class="s">(</span><span class="s">)</span><span class="sc">;</span>
+ 194 
+ 195   <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>
+ 196   <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>
+ 197   <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>
+ 198   <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>
+ 199   <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>
+ 200   <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>
+ 201 
+ 202   <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>
+ 203     <span class="i">$TextFile</span> = <span class="i">$TextFilesList</span>[<span class="i">$Index</span>]<span class="sc">;</span>
+ 204 
+ 205     <span class="i">$TextFilesInfo</span>{<span class="w">FileOkay</span>}[<span class="i">$Index</span>] = <span class="n">0</span><span class="sc">;</span>
+ 206     <span class="i">$TextFilesInfo</span>{<span class="w">ColCount</span>}[<span class="i">$Index</span>] = <span class="n">0</span><span class="sc">;</span>
+ 207     <span class="i">$TextFilesInfo</span>{<span class="w">InDelim</span>}[<span class="i">$Index</span>] = <span class="q">&quot;&quot;</span><span class="sc">;</span>
+ 208     <span class="i">$TextFilesInfo</span>{<span class="w">OutFile</span>}[<span class="i">$Index</span>] = <span class="q">&quot;&quot;</span><span class="sc">;</span>
+ 209     <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>
+ 210     <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>
+ 211 
+ 212     <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>
+ 213       <span class="k">warn</span> <span class="q">&quot;Warning: Ignoring file $TextFile: It doesn&#39;t exist\n&quot;</span><span class="sc">;</span>
+ 214       <span class="k">next</span> <span class="j">FILELIST</span><span class="sc">;</span>
+ 215     <span class="s">}</span>
+ 216     <span class="k">if</span> <span class="s">(</span>!<span class="i">CheckFileType</span><span class="s">(</span><span class="i">$TextFile</span><span class="cm">,</span> <span class="q">&quot;csv tsv&quot;</span><span class="s">)</span><span class="s">)</span> <span class="s">{</span>
+ 217       <span class="k">warn</span> <span class="q">&quot;Warning: Ignoring file $TextFile: It&#39;s not a csv or tsv file\n&quot;</span><span class="sc">;</span>
+ 218       <span class="k">next</span> <span class="j">FILELIST</span><span class="sc">;</span>
+ 219     <span class="s">}</span>
+ 220     <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>
+ 221     <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>
+ 222       <span class="i">$InDelim</span> = <span class="q">&quot;\t&quot;</span><span class="sc">;</span>
+ 223     <span class="s">}</span>
+ 224     <span class="k">else</span> <span class="s">{</span>
+ 225       <span class="i">$InDelim</span> = <span class="q">&quot;\,&quot;</span><span class="sc">;</span>
+ 226       <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>
+ 227         <span class="k">warn</span> <span class="q">&quot;Warning: Ignoring file $TextFile: The value specified, $Options{indelim}, for option \&quot;--indelim\&quot; is not valid for csv files\n&quot;</span><span class="sc">;</span>
+ 228         <span class="k">next</span> <span class="j">FILELIST</span><span class="sc">;</span>
+ 229       <span class="s">}</span>
+ 230       <span class="k">if</span> <span class="s">(</span><span class="i">$Options</span>{<span class="w">indelim</span>} =~ <span class="q">/^semicolon$/i</span><span class="s">)</span> <span class="s">{</span>
+ 231         <span class="i">$InDelim</span> = <span class="q">&quot;\;&quot;</span><span class="sc">;</span>
+ 232       <span class="s">}</span>
+ 233     <span class="s">}</span>
+ 234 
+ 235     <span class="k">if</span> <span class="s">(</span>!<span class="k">open</span> <span class="w">TEXTFILE</span><span class="cm">,</span> <span class="q">&quot;$TextFile&quot;</span><span class="s">)</span> <span class="s">{</span>
+ 236       <span class="k">warn</span> <span class="q">&quot;Warning: Ignoring file $TextFile: Couldn&#39;t open it: $! \n&quot;</span><span class="sc">;</span>
+ 237       <span class="k">next</span> <span class="j">FILELIST</span><span class="sc">;</span>
+ 238     <span class="s">}</span>
+ 239 
+ 240     <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>
+ 241     <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>
+ 242     <span class="k">close</span> <span class="w">TEXTFILE</span><span class="sc">;</span>
+ 243 
+ 244     <span class="i">$FileDir</span> = <span class="q">&quot;&quot;</span><span class="sc">;</span> <span class="i">$FileName</span> = <span class="q">&quot;&quot;</span><span class="sc">;</span> <span class="i">$FileExt</span> = <span class="q">&quot;&quot;</span><span class="sc">;</span>
+ 245     <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>
+ 246     <span class="i">$FileExt</span> = <span class="q">&quot;csv&quot;</span><span class="sc">;</span>
+ 247     <span class="k">if</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="s">{</span>
+ 248       <span class="i">$FileExt</span> = <span class="q">&quot;tsv&quot;</span><span class="sc">;</span>
+ 249     <span class="s">}</span>
+ 250     <span class="k">if</span> <span class="s">(</span><span class="i">$Options</span>{<span class="w">root</span>} &amp;&amp; <span class="s">(</span><span class="i">@TextFilesList</span> == <span class="n">1</span><span class="s">)</span><span class="s">)</span> <span class="s">{</span>
+ 251       <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">$Options</span>{<span class="w">root</span>}<span class="s">)</span><span class="sc">;</span>
+ 252       <span class="k">if</span> <span class="s">(</span><span class="i">$RootFileName</span> &amp;&amp; <span class="i">$RootFileExt</span><span class="s">)</span> <span class="s">{</span>
+ 253         <span class="i">$FileName</span> = <span class="i">$RootFileName</span><span class="sc">;</span>
+ 254       <span class="s">}</span>
+ 255       <span class="k">else</span> <span class="s">{</span>
+ 256         <span class="i">$FileName</span> = <span class="i">$Options</span>{<span class="w">root</span>}<span class="sc">;</span>
+ 257       <span class="s">}</span>
+ 258       <span class="i">$OutFileRoot</span> = <span class="i">$FileName</span><span class="sc">;</span>
+ 259     <span class="s">}</span>
+ 260     <span class="k">else</span> <span class="s">{</span>
+ 261       <span class="i">$OutFileRoot</span> = <span class="i">$FileName</span> . <span class="q">&quot;SortedByColumn&quot;</span><span class="sc">;</span>
+ 262     <span class="s">}</span>
+ 263 
+ 264     <span class="i">$OutFile</span> = <span class="i">$OutFileRoot</span> . <span class="q">&quot;.$FileExt&quot;</span><span class="sc">;</span>
+ 265     <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>
+ 266       <span class="k">warn</span> <span class="q">&quot;Warning: Ignoring file $TextFile:Output file name, $OutFile, is same as input text file name, $TextFile\n&quot;</span><span class="sc">;</span>
+ 267       <span class="k">next</span> <span class="j">FILELIST</span><span class="sc">;</span>
+ 268     <span class="s">}</span>
+ 269     <span class="k">if</span> <span class="s">(</span>!<span class="i">$Options</span>{<span class="w">overwrite</span>}<span class="s">)</span> <span class="s">{</span>
+ 270       <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>
+ 271         <span class="k">warn</span> <span class="q">&quot;Warning: Ignoring file $TextFile: The file $OutFile already exists\n&quot;</span><span class="sc">;</span>
+ 272         <span class="k">next</span> <span class="j">FILELIST</span><span class="sc">;</span>
+ 273       <span class="s">}</span>
+ 274     <span class="s">}</span>
+ 275 
+ 276     <span class="i">$TextFilesInfo</span>{<span class="w">FileOkay</span>}[<span class="i">$Index</span>] = <span class="n">1</span><span class="sc">;</span>
+ 277     <span class="i">$TextFilesInfo</span>{<span class="w">InDelim</span>}[<span class="i">$Index</span>] = <span class="i">$InDelim</span><span class="sc">;</span>
+ 278     <span class="i">$TextFilesInfo</span>{<span class="w">OutFile</span>}[<span class="i">$Index</span>] = <span class="q">&quot;$OutFile&quot;</span><span class="sc">;</span>
+ 279 
+ 280     <span class="i">$TextFilesInfo</span>{<span class="w">ColCount</span>}[<span class="i">$Index</span>] = <span class="i">@ColLabels</span><span class="sc">;</span>
+ 281     <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>
+ 282     <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>
+ 283       <span class="i">$ColLabel</span> = <span class="i">$ColLabels</span>[<span class="i">$ColNum</span>]<span class="sc">;</span>
+ 284       <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>
+ 285     <span class="s">}</span>
+ 286   <span class="s">}</span>
+ 287 
+ 288 <span class="s">}</span>
+ 289 
+ 290 <span class="c"># Make sure specified key column are okay...</span>
+<a name="ProcessColumnsInfo-"></a> 291 <span class="k">sub </span><span class="m">ProcessColumnsInfo</span> <span class="s">{</span>
+ 292   <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">$SpecifiedKeyCol</span><span class="s">)</span><span class="sc">;</span>
+ 293 
+ 294   <span class="i">@</span>{<span class="i">$TextFilesInfo</span>{<span class="w">KeyColNum</span>}} = <span class="s">(</span><span class="s">)</span><span class="sc">;</span>
+ 295 
+ 296   <span class="i">$SpecifiedKeyCol</span> = <span class="i">$OptionsInfo</span>{<span class="w">SpecifiedKeyCol</span>}<span class="sc">;</span>
+ 297 
+ 298   <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>
+ 299     <span class="i">$TextFile</span> = <span class="i">$TextFilesList</span>[<span class="i">$Index</span>]<span class="sc">;</span>
+ 300     <span class="i">$TextFilesInfo</span>{<span class="w">KeyColNum</span>}[<span class="i">$Index</span>] = <span class="n">0</span><span class="sc">;</span>
+ 301 
+ 302     <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>
+ 303       <span class="k">my</span><span class="s">(</span><span class="i">$KeyColNum</span><span class="cm">,</span> <span class="i">$KeyColValid</span><span class="s">)</span><span class="sc">;</span>
+ 304 
+ 305       <span class="i">$KeyColNum</span> = <span class="n">0</span><span class="sc">;</span>
+ 306       <span class="i">$KeyColValid</span> = <span class="n">1</span><span class="sc">;</span>
+ 307       <span class="k">if</span> <span class="s">(</span><span class="i">$SpecifiedKeyCol</span><span class="s">)</span> <span class="s">{</span>
+ 308         <span class="k">if</span> <span class="s">(</span><span class="i">$OptionsInfo</span>{<span class="w">Mode</span>} =~ <span class="q">/^colnum$/i</span><span class="s">)</span> <span class="s">{</span>
+ 309           <span class="k">if</span> <span class="s">(</span><span class="i">$SpecifiedKeyCol</span> &lt;= <span class="i">$TextFilesInfo</span>{<span class="w">ColCount</span>}[<span class="i">$Index</span>]<span class="s">)</span> <span class="s">{</span>
+ 310             <span class="i">$KeyColNum</span> = <span class="i">$SpecifiedKeyCol</span> - <span class="n">1</span><span class="sc">;</span>
+ 311           <span class="s">}</span>
+ 312           <span class="k">else</span> <span class="s">{</span>
+ 313             <span class="i">$KeyColValid</span> = <span class="n">0</span><span class="sc">;</span>
+ 314           <span class="s">}</span>
+ 315         <span class="s">}</span>
+ 316         <span class="k">else</span> <span class="s">{</span>
+ 317           <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">$SpecifiedKeyCol</span>}<span class="s">)</span><span class="s">)</span> <span class="s">{</span>
+ 318             <span class="i">$KeyColNum</span> =  <span class="i">$TextFilesInfo</span>{<span class="w">ColLabelToNumMap</span>}[<span class="i">$Index</span>]{<span class="i">$SpecifiedKeyCol</span>}<span class="sc">;</span>
+ 319           <span class="s">}</span>
+ 320           <span class="k">else</span> <span class="s">{</span>
+ 321             <span class="i">$KeyColValid</span> = <span class="n">0</span><span class="sc">;</span>
+ 322           <span class="s">}</span>
+ 323         <span class="s">}</span>
+ 324       <span class="s">}</span>
+ 325       <span class="k">if</span> <span class="s">(</span><span class="i">$KeyColValid</span><span class="s">)</span> <span class="s">{</span>
+ 326         <span class="i">$TextFilesInfo</span>{<span class="w">KeyColNum</span>}[<span class="i">$Index</span>] = <span class="i">$KeyColNum</span><span class="sc">;</span>
+ 327       <span class="s">}</span>
+ 328       <span class="k">else</span> <span class="s">{</span>
+ 329         <span class="k">warn</span> <span class="q">&quot;Warning: Ignoring file $TextFile: Column key specified, $SpecifiedKeyCol, using \&quot;k --key\&quot; option doesn&#39;t exist\n&quot;</span><span class="sc">;</span>
+ 330         <span class="i">$TextFilesInfo</span>{<span class="w">FileOkay</span>}[<span class="i">$Index</span>] = <span class="n">0</span><span class="sc">;</span>
+ 331       <span class="s">}</span>
+ 332     <span class="s">}</span>
+ 333   <span class="s">}</span>
+ 334 <span class="s">}</span>
+ 335 
+ 336 <span class="c"># Process option values...</span>
+<a name="ProcessOptions-"></a> 337 <span class="k">sub </span><span class="m">ProcessOptions</span> <span class="s">{</span>
+ 338   <span class="i">%OptionsInfo</span> = <span class="s">(</span><span class="s">)</span><span class="sc">;</span>
+ 339 
+ 340   <span class="i">$OptionsInfo</span>{<span class="w">Mode</span>} = <span class="i">$Options</span>{<span class="w">mode</span>}<span class="sc">;</span>
+ 341 
+ 342   <span class="i">$OptionsInfo</span>{<span class="w">DetailLevel</span>} = <span class="i">$Options</span>{<span class="w">detail</span>}<span class="sc">;</span>
+ 343 
+ 344   <span class="i">$OptionsInfo</span>{<span class="w">Sort</span>} = <span class="i">$Options</span>{<span class="w">sort</span>}<span class="sc">;</span>
+ 345   <span class="i">$OptionsInfo</span>{<span class="w">KeyData</span>} = <span class="i">$Options</span>{<span class="w">keydata</span>}<span class="sc">;</span>
+ 346 
+ 347   <span class="i">$OptionsInfo</span>{<span class="w">InDelim</span>} = <span class="i">$Options</span>{<span class="w">indelim</span>}<span class="sc">;</span>
+ 348 
+ 349   <span class="i">$OptionsInfo</span>{<span class="w">OutDelim</span>} = <span class="s">(</span><span class="i">$Options</span>{<span class="w">outdelim</span>} =~ <span class="q">/^tab$/i</span> <span class="s">)</span> ? <span class="q">&quot;\t&quot;</span> <span class="co">:</span> <span class="s">(</span><span class="s">(</span><span class="i">$Options</span>{<span class="w">outdelim</span>} =~ <span class="q">/^semicolon$/i</span><span class="s">)</span> ? <span class="q">&quot;\;&quot;</span> <span class="co">:</span> <span class="q">&quot;\,&quot;</span><span class="s">)</span><span class="sc">;</span>
+ 350   <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>
+ 351 
+ 352   <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>
+ 353   <span class="i">$OptionsInfo</span>{<span class="w">Root</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>
+ 354 
+ 355   <span class="i">$OptionsInfo</span>{<span class="w">Key</span>} = <span class="k">defined</span> <span class="i">$Options</span>{<span class="w">key</span>} ? <span class="i">$Options</span>{<span class="w">key</span>} <span class="co">:</span> <span class="k">undef</span><span class="sc">;</span>
+ 356   <span class="i">$OptionsInfo</span>{<span class="w">SpecifiedKeyCol</span>} = <span class="q">&quot;&quot;</span><span class="sc">;</span>
+ 357 
+ 358   <span class="k">if</span> <span class="s">(</span><span class="k">defined</span> <span class="i">$Options</span>{<span class="w">key</span>}<span class="s">)</span> <span class="s">{</span>
+ 359     <span class="i">$OptionsInfo</span>{<span class="w">SpecifiedKeyCol</span>} = <span class="i">$Options</span>{<span class="w">key</span>}<span class="sc">;</span>
+ 360     <span class="k">if</span> <span class="s">(</span><span class="i">$Options</span>{<span class="w">mode</span>} =~ <span class="q">/^colnum$/i</span><span class="s">)</span> <span class="s">{</span>
+ 361       <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">SpecifiedKeyCol</span>}<span class="s">)</span><span class="s">)</span> <span class="s">{</span>
+ 362         <span class="k">die</span> <span class="q">&quot;Error: Invalid value $Options{key} specified using \&quot;-k --key\&quot; option: Allowed values: &gt; 0\n&quot;</span><span class="sc">;</span>
+ 363       <span class="s">}</span>
+ 364     <span class="s">}</span>
+ 365   <span class="s">}</span>
+ 366 <span class="s">}</span>
+ 367 
+ 368 <span class="c"># Setup script usage  and retrieve command line arguments specified using various options...</span>
+<a name="SetupScriptUsage-"></a> 369 <span class="k">sub </span><span class="m">SetupScriptUsage</span> <span class="s">{</span>
+ 370   <span class="i">%Options</span> = <span class="s">(</span><span class="s">)</span><span class="sc">;</span>
+ 371 
+ 372   <span class="i">$Options</span>{<span class="w">detail</span>} = <span class="n">1</span><span class="sc">;</span>
+ 373   <span class="i">$Options</span>{<span class="w">mode</span>} = <span class="q">&quot;colnum&quot;</span><span class="sc">;</span>
+ 374   <span class="i">$Options</span>{<span class="w">sort</span>} = <span class="q">&quot;ascending&quot;</span><span class="sc">;</span>
+ 375   <span class="i">$Options</span>{<span class="w">keydata</span>} = <span class="q">&quot;numeric&quot;</span><span class="sc">;</span>
+ 376   <span class="i">$Options</span>{<span class="w">indelim</span>} = <span class="q">&quot;comma&quot;</span><span class="sc">;</span>
+ 377   <span class="i">$Options</span>{<span class="w">outdelim</span>} = <span class="q">&quot;comma&quot;</span><span class="sc">;</span>
+ 378   <span class="i">$Options</span>{<span class="w">quote</span>} = <span class="q">&quot;yes&quot;</span><span class="sc">;</span>
+ 379   <span class="k">if</span> <span class="s">(</span>!<span class="i">GetOptions</span><span class="s">(</span>\<span class="i">%Options</span><span class="cm">,</span> <span class="q">&quot;detail|d=i&quot;</span><span class="cm">,</span> <span class="q">&quot;help|h&quot;</span><span class="cm">,</span> <span class="q">&quot;indelim=s&quot;</span><span class="cm">,</span> <span class="q">&quot;key|k=s&quot;</span><span class="cm">,</span> <span class="q">&quot;keydata=s&quot;</span><span class="cm">,</span> <span class="q">&quot;mode|m=s&quot;</span><span class="cm">,</span> <span class="q">&quot;outdelim=s&quot;</span><span class="cm">,</span> <span class="q">&quot;overwrite|o&quot;</span><span class="cm">,</span> <span class="q">&quot;quote|q=s&quot;</span><span class="cm">,</span> <span class="q">&quot;root|r=s&quot;</span><span class="cm">,</span> <span class="q">&quot;sort|s=s&quot;</span><span class="cm">,</span> <span class="q">&quot;workingdir|w=s&quot;</span><span class="s">)</span><span class="s">)</span> <span class="s">{</span>
+ 380     <span class="k">die</span> <span class="q">&quot;\nTo get a list of valid options and their values, use \&quot;$ScriptName -h\&quot; or\n\&quot;perl -S $ScriptName -h\&quot; command and try again...\n&quot;</span><span class="sc">;</span>
+ 381   <span class="s">}</span>
+ 382   <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>
+ 383     <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>
+ 384       <span class="k">die</span> <span class="q">&quot;Error: The value specified, $Options{workingdir}, for option \&quot;-w --workingdir\&quot; is not a directory name.\n&quot;</span><span class="sc">;</span>
+ 385     <span class="s">}</span>
+ 386     <span class="k">chdir</span> <span class="i">$Options</span>{<span class="w">workingdir</span>} <span class="k">or</span> <span class="k">die</span> <span class="q">&quot;Error: Couldn&#39;t chdir $Options{workingdir}: $! \n&quot;</span><span class="sc">;</span>
+ 387   <span class="s">}</span>
+ 388   <span class="k">if</span> <span class="s">(</span><span class="i">$Options</span>{<span class="w">mode</span>} !~ <span class="q">/^(colnum|collabel)$/i</span><span class="s">)</span> <span class="s">{</span>
+ 389     <span class="k">die</span> <span class="q">&quot;Error: The value specified, $Options{mode}, for option \&quot;-m --mode\&quot; is not valid. Allowed values: colnum or collabel\n&quot;</span><span class="sc">;</span>
+ 390   <span class="s">}</span>
+ 391   <span class="k">if</span> <span class="s">(</span><span class="i">$Options</span>{<span class="w">keydata</span>} !~ <span class="q">/^(numeric|alphanumeric)$/i</span><span class="s">)</span> <span class="s">{</span>
+ 392     <span class="k">die</span> <span class="q">&quot;Error: The value specified, $Options{keydata}, for option \&quot;--keydata\&quot; is not valid. Allowed values: numeric or alphanumeric\n&quot;</span><span class="sc">;</span>
+ 393   <span class="s">}</span>
+ 394   <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>
+ 395     <span class="k">die</span> <span class="q">&quot;Error: The value specified, $Options{indelim}, for option \&quot;--indelim\&quot; is not valid. Allowed values: comma or semicolon\n&quot;</span><span class="sc">;</span>
+ 396   <span class="s">}</span>
+ 397   <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>
+ 398     <span class="k">die</span> <span class="q">&quot;Error: The value specified, $Options{outdelim}, for option \&quot;--outdelim\&quot; is not valid. Allowed values: comma, tab, or semicolon\n&quot;</span><span class="sc">;</span>
+ 399   <span class="s">}</span>
+ 400   <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>
+ 401     <span class="k">die</span> <span class="q">&quot;Error: The value specified, $Options{quote}, for option \&quot;-q --quote\&quot; is not valid. Allowed values: yes or no\n&quot;</span><span class="sc">;</span>
+ 402   <span class="s">}</span>
+ 403   <span class="k">if</span> <span class="s">(</span><span class="i">$Options</span>{<span class="w">sort</span>} !~ <span class="q">/^(ascending|descending)$/i</span><span class="s">)</span> <span class="s">{</span>
+ 404     <span class="k">die</span> <span class="q">&quot;Error: The value specified, $Options{sort}, for option \&quot;-s --sort\&quot; is not valid. Allowed values: ascending or descending\n&quot;</span><span class="sc">;</span>
+ 405   <span class="s">}</span>
+ 406   <span class="k">if</span> <span class="s">(</span>!<span class="i">IsPositiveInteger</span><span class="s">(</span><span class="i">$Options</span>{<span class="w">detail</span>}<span class="s">)</span><span class="s">)</span> <span class="s">{</span>
+ 407     <span class="k">die</span> <span class="q">&quot;Error: The value specified, $Options{detail}, for option \&quot;-d --detail\&quot; is not valid. Allowed values: &gt; 0\n&quot;</span><span class="sc">;</span>
+ 408   <span class="s">}</span>
+ 409 <span class="s">}</span>
+ 410 
+<a name="EOF-"></a></pre>
+<p>&nbsp;</p>
+<br />
+<center>
+<img src="../../../images/h2o2.png">
+</center>
+</body>
+</html>