annotate mayachemtools/lib/TextUtil.pm @ 0:73ae111cf86f draft

Uploaded
author deepakjadmin
date Wed, 20 Jan 2016 11:55:01 -0500
parents
children
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
rev   line source
0
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
1 package TextUtil;
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
2 #
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
3 # $RCSfile: TextUtil.pm,v $
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
4 # $Date: 2015/03/22 20:08:26 $
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
5 # $Revision: 1.45 $
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
6 #
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
7 # Author: Manish Sud <msud@san.rr.com>
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
8 #
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
9 # Copyright (C) 2015 Manish Sud. All rights reserved.
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
10 #
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
11 # This file is part of MayaChemTools.
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
12 #
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
13 # MayaChemTools is free software; you can redistribute it and/or modify it under
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
14 # the terms of the GNU Lesser General Public License as published by the Free
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
15 # Software Foundation; either version 3 of the License, or (at your option) any
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
16 # later version.
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
17 #
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
18 # MayaChemTools is distributed in the hope that it will be useful, but without
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
19 # any warranty; without even the implied warranty of merchantability of fitness
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
20 # for a particular purpose. See the GNU Lesser General Public License for more
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
21 # details.
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
22 #
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
23 # You should have received a copy of the GNU Lesser General Public License
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
24 # along with MayaChemTools; if not, see <http://www.gnu.org/licenses/> or
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
25 # write to the Free Software Foundation Inc., 59 Temple Place, Suite 330,
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
26 # Boston, MA, 02111-1307, USA.
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
27 #
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
28
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
29 use strict;
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
30 use Exporter;
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
31
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
32 use vars qw(@ISA @EXPORT @EXPORT_OK %EXPORT_TAGS);
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
33
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
34 @ISA = qw(Exporter);
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
35 @EXPORT = qw(AddNumberSuffix ContainsWhiteSpaces GetTextLine GetTextFileDataByUniqueKey GetTextFileDataByNonUniqueKey HashCode IsEmpty IsNumberPowerOfNumber IsInteger IsPositiveInteger IsFloat IsNotEmpty IsNumerical JoinWords SplitWords QuoteAWord RemoveLeadingWhiteSpaces RemoveTrailingWhiteSpaces RemoveLeadingAndTrailingWhiteSpaces WrapText);
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
36 @EXPORT_OK = qw();
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
37 %EXPORT_TAGS = (all => [@EXPORT, @EXPORT_OK]);
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
38
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
39 # Add number suffix...
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
40 sub AddNumberSuffix {
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
41 my($Value) = @_;
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
42 my($ValueWithSuffix, $Suffix);
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
43
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
44 $ValueWithSuffix = $Value;
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
45 if (!IsPositiveInteger($Value)) {
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
46 return $ValueWithSuffix;
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
47 }
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
48 $Suffix = "th";
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
49 if ($Value < 10 || $Value > 20) {
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
50 my $Remainder = $Value % 10;
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
51 $Suffix = ($Remainder == 1) ? "st" : (($Remainder == 2) ? "nd" : (($Remainder == 3) ? "rd" : "th"));
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
52 }
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
53 $ValueWithSuffix = "${ValueWithSuffix}${Suffix}";
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
54 return $ValueWithSuffix;
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
55 }
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
56
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
57 # Check out the string: Doen it contain any white space characters?
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
58 sub ContainsWhiteSpaces {
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
59 my($TheString) = @_;
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
60 my($Status) = 0;
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
61
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
62 if (defined($TheString) && length($TheString)) {
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
63 $Status = ($TheString =~ /[ \t\r\n\f]/ ) ? 1 : 0;
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
64 }
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
65 return $Status;
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
66 }
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
67
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
68 # Read the line, change to UNIX new line char, and chop off new line char as well...
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
69 sub GetTextLine {
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
70 my($TextFileRef) = @_;
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
71 my($Line) = '';
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
72
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
73 # Get the next non empty line...
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
74 LINE: while (defined($_ = <$TextFileRef>)) {
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
75 # Change Windows and Mac new line char to UNIX...
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
76 s/(\r\n)|(\r)/\n/g;
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
77
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
78 # Take out any new line char at the end by explicitly removing it instead of using
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
79 # chomp, which might not always work correctly on files generated on a system
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
80 # with a value of input line separator different from the current system...
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
81 s/\n$//g;
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
82
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
83 # Doesn't hurt to chomp...
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
84 chomp;
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
85
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
86 $Line = $_;
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
87 if (length $Line) {
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
88 last LINE;
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
89 }
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
90 }
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
91 return $Line;
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
92 }
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
93
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
94 # Load data from a CSV file into the specified hash reference using a specific
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
95 # column for unique data key values.
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
96 #
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
97 # The lines starting with # are treated as comments and ignored. First line
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
98 # not starting with # must contain column labels and the number of columns in
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
99 # all other data rows must match the number of column labels.
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
100 #
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
101 # The first column is assumed to contain data key value by default; all other columns
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
102 # contain data as indicated in their column labels.
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
103 #
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
104 # In order to avoid dependence of data access on the specified column labels, the
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
105 # column data is loaded into hash with Column<Num> hash keys, where column number
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
106 # start from 1. The data key column is not available as Colnum<Num> hash key;
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
107 #
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
108 # The format of the data structure loaded into a specified hash reference is:
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
109 #
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
110 # @{$TextDataMapRef->{DataKeys}} - Array of unique data keys
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
111 # @{$TextDataMapRef->{ColLabels}} - Array of column labels
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
112 # @{$TextDataMapRef->{DataColIDs}} - Array of data column IDs
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
113 # $TextDataMapRef->{NumOfCols} - Number of columns
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
114 # %{$TextDataMapRef->{DataKey}} - Hash keys pair: <DataKey, DataKey>
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
115 # %{$TextDataMapRef->{DataCol<Num>}} - Hash keys pair: <DataCol<Num>, DataKey>
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
116 #
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
117 # Caveats:
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
118 # . The column number start from 1.
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
119 # . Column data for data key column column is not loaded into <Column<Num>, DataKey> hash keys pairs.
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
120 #
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
121 sub GetTextFileDataByUniqueKey {
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
122 my($TextDataFile, $TextDataMapRef, $DataKeyColNum, $InDelim) = @_;
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
123
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
124 return _GetTextFileData("UniqueKey", $TextDataFile, $TextDataMapRef, $DataKeyColNum, $InDelim);
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
125 }
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
126
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
127 # Load data from a CSV file into the specified hash reference using a specific
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
128 # column for non-unique data key values.
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
129 #
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
130 # The lines starting with # are treated as comments and ignored. First line
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
131 # not starting with # must contain column labels and the number of columns in
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
132 # all other data rows must match the number of column labels.
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
133 #
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
134 # The first column is assumed to contain data key value by default; all other columns
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
135 # contain data as indicated in their column labels.
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
136 #
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
137 # In order to avoid dependence of data access on the specified column labels, the
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
138 # column data is loaded into hash with Column<Num> hash keys, where column number
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
139 # start from 1. The data key column is not available as Colnum<Num> hash key;
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
140 #
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
141 # The format of the data structure loaded into a specified hash reference is:
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
142 #
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
143 # @{$TextDataMapRef->{DataKeys}} - Array of unique data keys
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
144 # @{$TextDataMapRef->{ColLabels}} - Array of column labels
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
145 # @{$TextDataMapRef->{DataColIDs}} - Array of data column IDs
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
146 # $TextDataMapRef->{NumOfCols} - Number of columns
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
147 # %{$TextDataMapRef->{DataKey}} - Hash keys pair: <DataKey, DataKey>
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
148 # @{$TextDataMapRef->{DataCol<Num>}} - Hash keys pair with data as an array: <DataCol<Num>, DataKey>
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
149 #
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
150 # Caveats:
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
151 # . The column number start from 1.
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
152 # . Column data for data key column column is not loaded into <Column<Num>, DataKey> hash keys pairs.
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
153 #
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
154 sub GetTextFileDataByNonUniqueKey {
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
155 my($TextDataFile, $TextDataMapRef, $DataKeyColNum, $InDelim) = @_;
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
156
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
157 return _GetTextFileData("NonUniqueKey", $TextDataFile, $TextDataMapRef, $DataKeyColNum, $InDelim);
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
158 }
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
159
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
160 # Loadtext file data using unique or non-uniqye data column key...
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
161 #
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
162 sub _GetTextFileData {
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
163 my($DataKeyMode, $TextDataFile, $TextDataMapRef, $DataKeyColNum, $InDelim) = @_;
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
164 my($DataKeyColIndex, $LineCount, $IgnoredLineCount, $UniqueDataKeyMode, $DataKey, $Line, $NumOfCols, $ColIndex, $ColNum, $ColID, $ColValue, @LineWords, @ColLabels, @DataColIDs, @DataColNums);
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
165
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
166 print "\nProcessing text data file $TextDataFile...\n";
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
167
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
168 $UniqueDataKeyMode = 0;
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
169 if ($DataKeyMode =~ /^UniqueKey$/i) {
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
170 $UniqueDataKeyMode = 1;
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
171 }
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
172
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
173 # Setup default values...
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
174 $DataKeyColNum = defined $DataKeyColNum ? $DataKeyColNum : 1;
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
175
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
176 if ($TextDataFile =~ /^\.tsv$/i) {
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
177 $InDelim = "\t";
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
178 }
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
179 else {
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
180 $InDelim = "\,";
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
181 if ($InDelim =~ /^semicolon$/i) {
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
182 $InDelim = "\;";
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
183 }
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
184 }
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
185
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
186 ($LineCount, $IgnoredLineCount) = (0) x 2;
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
187
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
188 open TEXTDATAFILE, "$TextDataFile" or die "Couldn't open $TextDataFile: $! ...";
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
189
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
190 # Skip lines up to column labels...
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
191 LINE: while ($Line = TextUtil::GetTextLine(\*TEXTDATAFILE)) {
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
192 $LineCount++;
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
193 if ($Line =~ /^#/) {
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
194 $IgnoredLineCount++;
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
195 }
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
196 else {
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
197 last LINE;
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
198 }
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
199 }
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
200
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
201 # Initialize data map...
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
202 %{$TextDataMapRef} = ();
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
203 @{$TextDataMapRef->{DataKeys}} = ();
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
204 @{$TextDataMapRef->{ColLabels}} = ();
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
205 @{$TextDataMapRef->{DataColIDs}} = ();
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
206 $TextDataMapRef->{NumOfCols} = undef;
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
207
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
208 # Process column labels...
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
209 @ColLabels= quotewords($InDelim, 0, $Line);
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
210 $NumOfCols = @ColLabels;
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
211
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
212 if ($DataKeyColNum < 1 || $DataKeyColNum > $NumOfCols) {
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
213 warn "Warning: Ignoring text data file $TextDataFile: Invalid data key column number, $DataKeyColNum, specified. It must be > 0 or <= $NumOfCols, number of columns in the text file ...";
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
214 return;
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
215 }
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
216 $DataKeyColIndex = $DataKeyColNum - 1;
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
217
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
218 $TextDataMapRef->{NumOfCols} = $NumOfCols;
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
219 push @{$TextDataMapRef->{ColLabels}}, @ColLabels;
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
220
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
221 # Set up column data IDs for tracking the data...
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
222 @DataColNums = ();
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
223 @DataColIDs = ();
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
224 COLNUM: for $ColNum (1 .. $NumOfCols) {
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
225 if ($ColNum == $DataKeyColNum) {
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
226 next COLNUM;
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
227 }
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
228 push @DataColNums, $ColNum;
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
229 $ColID = "DataCol${ColNum}";
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
230 push @DataColIDs, $ColID;
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
231 }
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
232 push @{$TextDataMapRef->{DataColIDs}}, @DataColIDs;
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
233
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
234 # Initialize column data hash...
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
235 %{$TextDataMapRef->{DataKey}} = ();
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
236 for $ColIndex (0 .. $#DataColNums) {
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
237 $ColNum = $DataColNums[$ColIndex];
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
238 $ColID = $DataColIDs[$ColIndex];
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
239 %{$TextDataMapRef->{$ColID}} = ();
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
240 }
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
241
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
242 LINE: while ($Line = TextUtil::GetTextLine(\*TEXTDATAFILE)) {
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
243 $LineCount++;
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
244 if ($Line =~ /^#/) {
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
245 $IgnoredLineCount++;
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
246 next LINE;
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
247 }
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
248
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
249 @LineWords = quotewords($InDelim, 0, $Line);
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
250 if (@LineWords != $NumOfCols) {
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
251 $IgnoredLineCount++;
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
252 warn "Warning: The number of data fields, @LineWords, in $TextDataFile must be $NumOfCols.\nIgnoring line number $LineCount: $Line...\n";
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
253 next LINE;
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
254 }
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
255 $DataKey = $LineWords[$DataKeyColIndex];
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
256
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
257 if ($UniqueDataKeyMode) {
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
258 if (exists $TextDataMapRef->{DataKey}{$DataKey}) {
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
259 $IgnoredLineCount++;
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
260 warn "Warning: The data key, $DataKey, in data column key number, $DataKeyColNum, is already present.\nIgnoring line number $LineCount: $Line...\n";
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
261 next LINE;
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
262 }
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
263 push @{$TextDataMapRef->{DataKeys}}, $DataKey;
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
264 $TextDataMapRef->{DataKey}{$DataKey} = $DataKey;
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
265 }
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
266 else {
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
267 if (!exists $TextDataMapRef->{DataKey}{$DataKey}) {
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
268 push @{$TextDataMapRef->{DataKeys}}, $DataKey;
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
269 $TextDataMapRef->{DataKey}{$DataKey} = $DataKey;
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
270
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
271 for $ColIndex (0 .. $#DataColNums) {
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
272 $ColNum = $DataColNums[$ColIndex];
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
273 $ColID = $DataColIDs[$ColIndex];
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
274 @{$TextDataMapRef->{$ColID}{$DataKey}} = ();
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
275 }
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
276 }
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
277 }
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
278
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
279 # Track column data values...
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
280 for $ColIndex (0 .. $#DataColNums) {
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
281 $ColID = $DataColIDs[$ColIndex];
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
282
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
283 $ColNum = $DataColNums[$ColIndex];
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
284 $ColValue = $LineWords[$ColNum - 1];
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
285
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
286 if ($UniqueDataKeyMode) {
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
287 $TextDataMapRef->{$ColID}{$DataKey} = $ColValue;
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
288 }
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
289 else {
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
290 push @{$TextDataMapRef->{$ColID}{$DataKey}}, $ColValue;
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
291 }
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
292 }
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
293
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
294 }
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
295
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
296 print "\nTotal number of lines in file $TextDataFile: $LineCount\n";
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
297 print "Total number of lines ignored: $IgnoredLineCount\n";
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
298
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
299 close TEXTDATAFILE;
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
300 }
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
301
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
302 # Returns a 32 bit integer hash code using One-at-a-time algorithm By Bob Jenkins [Ref 38]. It's also implemented in
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
303 # Perl for internal hash keys in hv.h include file.
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
304 #
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
305 # It's not clear how to force Perl perform unsigned integer arithmetic irrespective of the OS/Platform and
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
306 # the value of use64bitint flag used during its compilation.
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
307 #
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
308 # In order to generate a consistent 32 bit has code across OS/platforms, the following methodology appear
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
309 # to work:
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
310 #
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
311 # o Use MaxHashCodeMask to retrieve appropriate bits after left shifting by bit operators and additions
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
312 # o Stay away from "use integer" to avoid signed integer arithmetic for bit operators
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
313 #
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
314 #
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
315 # MaxHashCodeMask (2147483647) corresponds to the maximum value which can be stored in 31 bits
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
316 #
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
317 my($MaxHashCodeMask);
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
318 $MaxHashCodeMask = 2**31 - 1;
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
319
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
320 sub HashCode {
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
321 my($String) = @_;
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
322 my($HashCode, $Value, $ShiftedHashCode);
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
323
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
324 $HashCode = 0;
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
325 for $Value (unpack('C*', $String)) {
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
326 $HashCode += $Value;
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
327
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
328 $ShiftedHashCode = $HashCode << 10;
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
329 if ($ShiftedHashCode > $MaxHashCodeMask) {
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
330 $ShiftedHashCode = $ShiftedHashCode & $MaxHashCodeMask;
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
331 }
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
332
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
333 $HashCode += $ShiftedHashCode;
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
334 if ($HashCode > $MaxHashCodeMask) {
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
335 $HashCode = $HashCode & $MaxHashCodeMask;
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
336 }
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
337
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
338 $HashCode ^= ($HashCode >> 6);
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
339 }
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
340
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
341 $ShiftedHashCode = $HashCode << 3;
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
342 if ($ShiftedHashCode > $MaxHashCodeMask) {
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
343 $ShiftedHashCode = $ShiftedHashCode & $MaxHashCodeMask;
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
344 }
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
345
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
346 $HashCode += $ShiftedHashCode;
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
347 if ($HashCode > $MaxHashCodeMask) {
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
348 $HashCode = $HashCode & $MaxHashCodeMask;
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
349 }
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
350 $HashCode ^= ($HashCode >> 11);
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
351
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
352 $ShiftedHashCode = $HashCode << 15;
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
353 if ($ShiftedHashCode > $MaxHashCodeMask) {
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
354 $ShiftedHashCode = $ShiftedHashCode & $MaxHashCodeMask;
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
355 }
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
356
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
357 $HashCode += $ShiftedHashCode;
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
358 if ($HashCode > $MaxHashCodeMask) {
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
359 $HashCode = $HashCode & $MaxHashCodeMask;
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
360 }
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
361 return $HashCode;
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
362 }
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
363
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
364 # Check out the string: Is it defined and has a non zero length?
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
365 sub IsEmpty {
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
366 my($TheString) = @_;
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
367 my($Status) = 1;
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
368
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
369 $Status = (defined($TheString) && length($TheString)) ? 0 : 1;
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
370
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
371 return $Status;
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
372 }
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
373
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
374 # Is first specified number power of second specified number...
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
375 sub IsNumberPowerOfNumber {
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
376 my($FirstNum, $SecondNum) = @_;
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
377 my($PowerValue);
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
378
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
379 $PowerValue = log($FirstNum)/log($SecondNum);
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
380
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
381 return IsInteger($PowerValue) ? 1 : 0;
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
382 }
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
383
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
384 # Check out the string: Is it an integer?
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
385 sub IsInteger {
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
386 my($TheString) = @_;
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
387 my($Status) = 0;
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
388
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
389 if (defined($TheString) && length($TheString)) {
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
390 $TheString = RemoveLeadingAndTrailingWhiteSpaces($TheString);
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
391 $TheString =~ s/^[+-]//;
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
392 $Status = ($TheString =~ /[^0-9]/) ? 0 : 1;
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
393 }
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
394 return $Status;
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
395 }
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
396
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
397 # Check out the string: Is it an integer with value > 0?
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
398 sub IsPositiveInteger {
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
399 my($TheString) = @_;
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
400 my($Status) = 0;
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
401
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
402 $Status = IsInteger($TheString) ? ($TheString > 0 ? 1 : 0) : 0;
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
403
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
404 return $Status;
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
405 }
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
406
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
407
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
408 # Check out the string: Is it a float?
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
409 sub IsFloat {
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
410 my($TheString) = @_;
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
411 my($Status) = 0;
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
412
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
413 if (defined($TheString) && length($TheString)) {
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
414 $TheString = RemoveLeadingAndTrailingWhiteSpaces($TheString);
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
415 $TheString =~ s/^[+-]//;
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
416 $Status = ($TheString =~ /[^0-9.eE]/) ? 0 : (((length($TheString) == 1) && ($TheString =~ /[.eE]/)) ? 0 : 1);
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
417 }
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
418 return $Status;
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
419 }
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
420
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
421 # Check out the string: Is it defined and has a non zero length?
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
422 sub IsNotEmpty {
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
423 my($TheString) = @_;
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
424 my($Status);
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
425
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
426 $Status = IsEmpty($TheString) ? 0 : 1;
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
427
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
428 return $Status;
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
429 }
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
430
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
431 # Check out the string: Does it only contain numerical data?
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
432 sub IsNumerical {
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
433 my($TheString) = @_;
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
434 my($Status) = 0;
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
435
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
436 if (defined($TheString) && length($TheString)) {
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
437 $TheString = RemoveLeadingAndTrailingWhiteSpaces($TheString);
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
438 $TheString =~ s/^[+-]//;
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
439 $Status = ($TheString =~ /[^0-9.eE]/) ? 0 : (((length($TheString) == 1) && ($TheString =~ /[.eE]/)) ? 0 : 1);
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
440 }
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
441 return $Status;
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
442 }
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
443
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
444 # Join different words using delimiter and quote parameters. And return as
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
445 # a string value.
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
446 sub JoinWords {
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
447 my($Words, $Delim, $Quote) = @_;
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
448
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
449 if (!@$Words) {
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
450 return "";
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
451 }
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
452
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
453 $Quote = $Quote ? "\"" : "";
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
454 my(@NewWords) = map { (defined($_) && length($_)) ? "${Quote}$_${Quote}" : "${Quote}${Quote}" } @$Words;
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
455
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
456 return join $Delim, @NewWords;
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
457 }
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
458
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
459 # Split string value containing quoted or unquoted words in to an array containing
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
460 # unquoted words.
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
461 #
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
462 # This function is used to split strings generated by JoinWords.
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
463 #
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
464 sub SplitWords {
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
465 my($Line, $Delim) = @_;
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
466
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
467 if (!$Line) {
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
468 return ();
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
469 }
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
470
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
471 # Is it a quoted string?
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
472 if ($Line =~ /^\"/) {
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
473 # Take out first and last quote...
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
474 $Line =~ s/^\"//; $Line =~ s/\"$//;
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
475
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
476 $Delim = "\"$Delim\"";
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
477 }
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
478 return split /$Delim/, $Line;
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
479 }
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
480
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
481 # Based on quote parameter, figure out what to do
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
482 sub QuoteAWord {
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
483 my($Word, $Quote) = @_;
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
484 my($QuotedWord);
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
485
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
486 $QuotedWord = "";
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
487 if ($Word) {
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
488 $QuotedWord = $Word;
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
489 }
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
490 if ($Quote) {
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
491 $QuotedWord = "\"$QuotedWord\"";
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
492 }
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
493 return ($QuotedWord);
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
494 }
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
495
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
496 # Remove leading white space characters from the string...
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
497 sub RemoveLeadingWhiteSpaces {
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
498 my($InString) = @_;
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
499 my($OutString, $TrailingString, $LeadingWhiteSpace);
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
500
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
501 $OutString = $InString;
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
502 if (length($InString) && ContainsWhiteSpaces($InString)) {
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
503 $OutString =~ s/^([ \t\r\n\f]*)(.*?)$/$2/;
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
504 }
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
505 return $OutString;
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
506 }
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
507
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
508 # Remove Trailing white space characters from the string...
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
509 sub RemoveTrailingWhiteSpaces {
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
510 my($InString) = @_;
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
511 my($OutString, $LeadingString, $TrailingWhiteSpace);
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
512
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
513 $OutString = $InString;
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
514 if (length($InString) && ContainsWhiteSpaces($InString)) {
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
515 $OutString =~ s/^(.*?)([ \t\r\n\f]*)$/$1/;
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
516 }
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
517 return $OutString;
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
518 }
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
519
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
520 # Remove both leading and trailing white space characters from the string...
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
521 sub RemoveLeadingAndTrailingWhiteSpaces {
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
522 my($InString) = @_;
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
523 my($OutString);
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
524
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
525 $OutString = $InString;
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
526 if (length($InString) && ContainsWhiteSpaces($InString)) {
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
527 $OutString =~ s/^([ \t\r\n\f]*)(.*?)([ \t\r\n\f]*)$/$2/;
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
528 }
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
529 return $OutString;
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
530 }
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
531
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
532 # Wrap text string...
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
533 sub WrapText {
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
534 my($InString, $WrapLength, $WrapDelimiter);
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
535 my($OutString);
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
536
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
537 $WrapLength = 40;
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
538 $WrapDelimiter = "\n";
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
539 if (@_ == 3) {
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
540 ($InString, $WrapLength, $WrapDelimiter) = @_;
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
541 }
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
542 elsif (@_ == 2) {
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
543 ($InString, $WrapLength) = @_;
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
544 }
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
545 else {
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
546 ($InString, $WrapLength) = @_;
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
547 }
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
548 $OutString = $InString;
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
549 if ($InString && (length($InString) > $WrapLength)) {
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
550 $OutString = "";
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
551 my($Index, $Length, $FirstPiece, $StringPiece);
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
552 $Index = 0; $Length = length($InString);
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
553 $FirstPiece = 1;
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
554 for ($Index = 0; $Index < $Length; $Index += $WrapLength) {
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
555 if (($Index + $WrapLength) < $Length) {
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
556 $StringPiece = substr($InString, $Index, $WrapLength);
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
557 }
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
558 else {
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
559 # Last piece of the string...
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
560 $StringPiece = substr($InString, $Index, $WrapLength);
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
561 }
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
562 if ($FirstPiece) {
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
563 $FirstPiece = 0;
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
564 $OutString = $StringPiece;
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
565 }
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
566 else {
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
567 $OutString .= "${WrapDelimiter}${StringPiece}";
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
568 }
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
569 }
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
570 }
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
571 return $OutString;
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
572 }
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
573
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
574 1;
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
575
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
576 __END__
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
577
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
578 =head1 NAME
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
579
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
580 TextUtil
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
581
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
582 =head1 SYNOPSIS
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
583
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
584 use TextUtil;
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
585
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
586 use TextUtil qw(:all);
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
587
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
588 =head1 DESCRIPTION
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
589
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
590 B<TextUtil> module provides the following functions:
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
591
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
592 AddNumberSuffix, ContainsWhiteSpaces, GetTextFileDataByNonUniqueKey,
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
593 GetTextFileDataByUniqueKey, GetTextLine, HashCode, IsEmpty, IsFloat, IsInteger,
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
594 IsNotEmpty, IsNumberPowerOfNumber, IsNumerical, IsPositiveInteger, JoinWords,
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
595 QuoteAWord, RemoveLeadingAndTrailingWhiteSpaces, RemoveLeadingWhiteSpaces,
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
596 RemoveTrailingWhiteSpaces, SplitWords, WrapText
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
597
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
598 =head1 FUNCTIONS
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
599
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
600 =over 4
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
601
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
602 =item B<AddNumberSuffix>
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
603
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
604 $NumberWithSuffix = AddNumberSuffix($IntegerValue);
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
605
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
606 Returns number with appropriate suffix: 0, 1st, 2nd, 3rd, 4th, and so on.
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
607
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
608 =item B<ContainsWhiteSpaces>
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
609
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
610 $Status = ContainsWhiteSpaces($TheString);
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
611
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
612 Returns 1 or 0 based on whether the string contains any white spaces.
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
613
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
614 =item B<GetTextLine>
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
615
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
616 $Line = GetTextLine(\*TEXTFILE);
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
617
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
618 Reads next line from an already opened text file, takes out any carriage return,
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
619 and returns it as a string. NULL is returned for EOF.
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
620
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
621 =item B<GetTextFileDataByNonUniqueKey>
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
622
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
623 GetTextFileDataByNonUniqueKey($TextDataFile, $TextDataMapRef,
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
624 $DataKeyColNum, $InDelim);
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
625
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
626 Load data from a text file into the specified hash reference using a specific
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
627 column for non-unique data key values.
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
628
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
629 The lines starting with # are treated as comments and ignored. First line
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
630 not starting with # must contain column labels and the number of columns in
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
631 all other data rows must match the number of column labels.
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
632
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
633 The first column is assumed to contain data key value by default; all other columns
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
634 contain data as indicated in their column labels.
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
635
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
636 In order to avoid dependence of data access on the specified column labels, the
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
637 column data is loaded into hash with Column<Num> hash keys, where column number
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
638 start from 1. The data key column is not available as Colnum<Num> hash key;
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
639
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
640 The format of the data structure loaded into a specified hash reference is:
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
641
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
642 @{$TextDataMapRef->{DataKeys}} - Array of unique data keys
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
643 @{$TextDataMapRef->{ColLabels}} - Array of column labels
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
644 @{$TextDataMapRef->{DataColIDs}} - Array of data column IDs
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
645 $TextDataMapRef->{NumOfCols} - Number of columns
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
646 %{$TextDataMapRef->{DataKey}} - Hash keys pair: <DataKey, DataKey>
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
647 @{$TextDataMapRef->{DataCol<Num>}} - Hash keys pair with data as an array:
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
648 <DataCol<Num>, DataKey>
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
649
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
650 =item B<GetTextFileDataByUniqueKey>
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
651
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
652 GetTextFileDataByUniqueKey($TextDataFile, $TextDataMapRef, $DataKeyColNum,
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
653 $InDelim);
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
654
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
655 Load data from a text file into the specified hash reference using a a specific
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
656 column for unique data key values.
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
657
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
658 The lines starting with # are treated as comments and ignored. First line
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
659 not starting with # must contain column labels and the number of columns in
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
660 all other data rows must match the number of column labels.
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
661
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
662 The first column is assumed to contain data key value by default; all other columns
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
663 contain data as indicated in their column labels.
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
664
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
665 In order to avoid dependence of data access on the specified column labels, the
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
666 column data is loaded into hash with Column<Num> hash keys, where column number
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
667 start from 1. The data key column is not available as Colnum<Num> hash key;
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
668
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
669 The format of the data structure loaded into a specified hash reference is:
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
670
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
671 @{$TextDataMapRef->{DataKeys}} - Array of unique data keys
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
672 @{$TextDataMapRef->{ColLabels}} - Array of column labels
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
673 @{$TextDataMapRef->{DataColIDs}} - Array of data column IDs
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
674 $TextDataMapRef->{NumOfCols} - Number of columns
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
675 %{$TextDataMapRef->{DataKey}} - Hash keys pair: <DataKey, DataKey>
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
676 %{$TextDataMapRef->{DataCol<Num>}} - Hash keys pair: <DataCol<Num>, DataKey>
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
677
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
678 =item B<HashCode>
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
679
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
680 $HashCode = HashCode($TheString);
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
681
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
682 Returns a 32 bit integer hash code using One-at-a-time algorithm By Bob Jenkins [Ref 38].
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
683 It's also implemented in Perl for internal hash keys in hv.h include file.
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
684
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
685 =item B<IsEmpty>
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
686
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
687 $Status = IsEmpty($TheString);
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
688
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
689 Returns 1 or 0 based on whether the string is empty.
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
690
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
691 =item B<IsInteger>
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
692
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
693 $Status = IsInteger($TheString);
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
694
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
695 Returns 1 or 0 based on whether the string is a positive integer.
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
696
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
697 =item B<IsPositiveInteger>
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
698
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
699 $Status = IsPositiveInteger($TheString);
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
700
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
701 Returns 1 or 0 based on whether the string is an integer.
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
702
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
703 =item B<IsFloat>
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
704
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
705 $Status = IsFloat($TheString);
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
706
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
707 Returns 1 or 0 based on whether the string is a float.
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
708
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
709 =item B<IsNotEmpty>
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
710
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
711 $Status = IsNotEmpty($TheString);
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
712
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
713 Returns 0 or 1 based on whether the string is empty.
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
714
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
715 =item B<IsNumerical>
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
716
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
717 $Status = IsNumerical($TheString);
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
718
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
719 Returns 1 or 0 based on whether the string is a number.
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
720
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
721 =item B<IsNumberPowerOfNumber>
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
722
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
723 $Status = IsNumberPowerOfNumber($FirstNum, $SecondNum);
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
724
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
725 Returns 1 or 0 based on whether the first number is a power of second number.
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
726
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
727 =item B<JoinWords>
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
728
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
729 $JoinedWords = JoinWords($Words, $Delim, $Quote);
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
730
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
731 Joins different words using delimiter and quote parameters, and returns it
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
732 as a string.
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
733
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
734 =item B<QuoteAWord>
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
735
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
736 $QuotedWord = QuoteAWord($Word, $Quote);
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
737
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
738 Returns a quoted string based on I<Quote> value.
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
739
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
740 =item B<RemoveLeadingWhiteSpaces>
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
741
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
742 $OutString = RemoveLeadingWhiteSpaces($InString);
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
743
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
744 Returns a string without any leading and traling white spaces.
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
745
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
746 =item B<RemoveTrailingWhiteSpaces>
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
747
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
748 $OutString = RemoveTrailingWhiteSpaces($InString);
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
749
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
750 Returns a string without any trailing white spaces.
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
751
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
752 =item B<RemoveLeadingAndTrailingWhiteSpaces>
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
753
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
754 $OutString = RemoveLeadingAndTrailingWhiteSpaces($InString);
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
755
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
756 Returns a string without any leading and traling white spaces.
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
757
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
758 =item B<SplitWords>
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
759
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
760 @Words = SplitWords($Line, $Delimiter);
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
761
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
762 Returns an array I<Words> ontaining unquoted words generated after spliting
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
763 string value I<Line> containing quoted or unquoted words.
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
764
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
765 This function is used to split strings generated by JoinWords as replacement
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
766 for Perl's core module funtion Text::ParseWords::quotewords() which dumps core
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
767 on very long strings.
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
768
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
769 =item B<WrapText>
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
770
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
771 $OutString = WrapText($InString, [$WrapLength, $WrapDelimiter]);
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
772
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
773 Returns a wrapped string. By default, I<WrapLenght> is I<40> and I<WrapDelimiter>
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
774 is Unix new line character.
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
775
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
776 =back
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
777
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
778 =head1 AUTHOR
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
779
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
780 Manish Sud <msud@san.rr.com>
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
781
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
782 =head1 SEE ALSO
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
783
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
784 FileUtil.pm
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
785
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
786 =head1 COPYRIGHT
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
787
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
788 Copyright (C) 2015 Manish Sud. All rights reserved.
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
789
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
790 This file is part of MayaChemTools.
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
791
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
792 MayaChemTools is free software; you can redistribute it and/or modify it under
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
793 the terms of the GNU Lesser General Public License as published by the Free
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
794 Software Foundation; either version 3 of the License, or (at your option)
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
795 any later version.
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
796
73ae111cf86f Uploaded
deepakjadmin
parents:
diff changeset
797 =cut