Hi,
I have a file with multiple tab delimited columns and I would like to have the average of each column:
Iteration Tree No Lh HMean
1000 1 -78.834717 -78.834717
1100 1 -77.991031 -78.624046
1200 1 -79.416055 -78.761861
1300 1 -79.280494 -78.968099
1400 1 -82.846275 -80.808696 ... (4 Replies)
awk experts,
I have a big file of 4000 columns with header. Would like to print the columns with string value of "Commands" in header. File has "," separator. This file is on ESX host with Bash.
Thanks,
Arv (21 Replies)
Hi All,
I need help for below scenario :
I have a principals.xml_24092012backup file :
cat principals.xml_24092012backup
</user>
<user username="eramire" password="2D393C01720749256303D204826A374D9AE9ABABBF8A">
<roleMapping rolename="VIEW_EVERYTHING"/>
</user>
... (2 Replies)
Hi all,
My input file is :
0 13400000 sil
13400000 14400000 a
14400000 14900000 dh
14900000 15300000 a
15300000 16500000 R
16500000 17000000 k
17000000 17300000 u
17300000 17600000 th
17600000 17900000 sil
17900000 18400000 th
18400000 18900000 a
18900000 19600000 g
19600000 19900000... (1 Reply)
Hi,
I have multiple files that each contain one column of strings:
File1:
123abc
456def
789ghi
File2:
123abc
456def
891jkl
File3:
234mno
123abc
456def
In total I have 25 of these type of file. (5 Replies)
Hi, I have a large data file, want to separate it into 100 part and export one specific field as a file; then I want to append each part's column into one file. How to realize that?
1 2 3 1
2 3 4 2
2 3 4 3
3 3 4 4
3 4 5 5
3 4 5 6
I want the last column of the data file, e.g divide it... (5 Replies)
Hi guys,
I have hundreds file like this, here I only show two of them:
file 1
feco4_s_BB95.log ZE_1=-1717.5206260
feco4_t_BB95.log ZE_1=-1717.5169250
feco5_s_BB95.log ZE_1=-1830.9322060... (11 Replies)
Hello,
I have to fish out some specific columns from a file based on the header value. I have the list of columns I need in a different file. I thought I could read in the list of headers I need,
# file with header names of required columns in required order
headers_file=$2
# read contents... (11 Replies)
Hello, I have two tab files with headers
File1: with 4 columns
header1 header2 header3 header4
44 a bb 1
57 c ab 4
64 d d 5
File2: with 26 columns
header1.. header5 header6 header7 ... header 22...header26
id1 44 a bb
id2 57 ... (6 Replies)
Hello,
I have a requirement to apply hashing algorithm on flat file on one or more columns dynamically based on header
sample input file
ID|NAME|AGE|GENDER
10|ABC|30|M
20|DEF|20|F
say if i want multiple columns based on the header example id,name or id,age or name,gender and hash and... (13 Replies)
Discussion started by: mkathi
13 Replies
LEARN ABOUT DEBIAN
alzabo::index
Alzabo::Index(3pm) User Contributed Perl Documentation Alzabo::Index(3pm)NAME
Alzabo::Index - Index objects
SYNOPSIS
foreach my $i ($table->indexes)
{
foreach my $c ($i->columns)
{
print $c->name;
print '(' . $i->prefix($c) . ')' if $i->prefix($c);
}
}
DESCRIPTION
This object represents an index on a table. Indexes consist of columns and optional prefixes for each column. The prefix specifies how
many characters of the columns should be indexes (the first X chars). Some RDBMS's do not have a concept of index prefixes. Not all col-
umn types are likely to allow prefixes though this depends on the RDBMS. The order of the columns is significant.
METHODS
columns
Returns an ordered list of the "Alzabo::Column" objects that are being indexed.
prefix ("Alzabo::Column" object)
A column prefix is, to the best of my knowledge, a MySQL specific concept, and as such cannot be set when using an RDBMSRules module for a
different RDBMS. However, it is important enough for MySQL to have the functionality be present. It allows you to specify that the index
should only look at a certain portion of a field (the first N characters). This prefix is required to index any sort of BLOB column in
MySQL.
This method returns the prefix for the column in the index. If there is no prefix for this column in the index, then it returns undef.
unique
Returns a boolean value indicating whether the index is a unique index.
fulltext
Returns a boolean value indicating whether the index is a fulltext index.
function
For function indexes, this returns the function being indexed.
id
The id is generated from the table, column and prefix information for the index. This is useful as a canonical name for a hash key, for
example.
Returns a string that is the id which uniquely identifies the index in this schema.
table
Returns the "Alzabo::Table" object to which the index belongs.
AUTHOR
Dave Rolsky, <autarch@urth.org>
perl v5.8.8 2007-12-23 Alzabo::Index(3pm)