annotate mayachemtool/mayachemtools/lib/TextUtil.pm @ 0:68300206e90d draft default tip

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