mayatool3_test1: docs/scripts/html/code/ExtractFromTextFiles.html annotate

annotate docs/scripts/html/code/ExtractFromTextFiles.html @ 1:2abf0d43254d draft

Uploaded

author	deepakjadmin
date	Wed, 20 Jan 2016 09:10:43 -0500
parents
children

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

Mercurial > repos > deepakjadmin > mayatool3_test1

annotate docs/scripts/html/code/ExtractFromTextFiles.html @ 1:2abf0d43254d draft