10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
hello,
i have a undelimited file which contains 229 byte records. i want to change column 23 - 26 with a new value and also change the sign of the data in colulmn 30 - 70. i've tried SED for the first change, but nothing happens:
sed 's/\(^.\{22\}\).\{4\}\(.*\)/\0603\2/' inputfile
heres an... (8 Replies)
Discussion started by: blt123
8 Replies
2. Shell Programming and Scripting
Hi,
Please help with this.
I have several excel files (with and .xlsx format) with 10-15 columns each.
They all have the same type of data but the columns are not ordered in the same way.
Here is a 3 column example. What I want to do add the alphabet
from column 2 to column 3, provided... (9 Replies)
Discussion started by: newbie83
9 Replies
3. Shell Programming and Scripting
Hi Friends,
This is the only solution to my task. So, any help is highly appreciated.
I have a file
cat input1.bed
chr1 100 200 abc
chr1 120 300 def
chr1 145 226 ghi
chr2 567 600 unix
Now, I have another file by name
input2.bed (This file is a binary file not readable by the... (7 Replies)
Discussion started by: jacobs.smith
7 Replies
4. Shell Programming and Scripting
Hello,
I have some tab delimited data and I need to move the last col. I could hard code it,
awk '{ print $1,$NF,$2,$3,$4,etc }' infile > outfile
but it would be nice to know the syntax to print a range cols.
I know in cut you can do,
cut -f 1,4-8,11-
to print fields 1,... (8 Replies)
Discussion started by: LMHmedchem
8 Replies
5. UNIX for Advanced & Expert Users
Hello everyone,
I am writing a script to process data from the ATP world tour.
I have a file which contains:
t=540 y=2011 r=1 p=N409
t=540 y=2011 r=2 p=N409
t=540 y=2011 r=3 p=N409
t=540 y=2011 r=4 p=N409
t=520 y=2011 r=1 p=N409
t=520 y=2011 r=2 p=N409
t=520 y=2011 r=3 p=N409
The... (4 Replies)
Discussion started by: imahmoud
4 Replies
6. Shell Programming and Scripting
Hi, Experts,
I have a requirement as following:
my source file:
a
a
a
b
b
c
c
c
c
I need add one more colume as following:
1 a
2 a
3 a
1 b
2 b
1 c
2 c (4 Replies)
Discussion started by: ken002
4 Replies
7. Shell Programming and Scripting
Hi,
My first file has
592155 9 rs16916098 1
592156 19 rs7249604 1
592157 4 rs885156 1
592158 5 rs350067 12nd file has
9 rs16916098 0 113228129 2 4
19 rs7249604 0 58709070 4 2
2 rs17042833 0 113558750 4 2... (2 Replies)
Discussion started by: genehunter
2 Replies
8. Shell Programming and Scripting
Hi,
I have two different files, one has two columns and other has only one column. I would like to compare the first column in the first file with the data in the second file and write a third file with the data that is not present is not common to them.
First file:... (26 Replies)
Discussion started by: swame_sp
26 Replies
9. Shell Programming and Scripting
Dear All,
I am a newbie to shell scripting so this one is really over my head.
I have a text file with five fields as below:
76576.867188 6232.454102 2.008904 55.000000 3
76576.867188 6232.454102 3.607231 55.000000 4
76576.867188 6232.454102 1.555146 65.000000 3
76576.867188 6232.454102... (19 Replies)
Discussion started by: Ghetz
19 Replies
10. Shell Programming and Scripting
Hi
I have an file which looks like
country address phone amount
sweden |address |phone | 10 |
Singapo |address |phone | 20 |
Italy-N |address |phone | 30 |
denmar |address |phone | 40 |
Here i need to do the sum(amount), how to do this in shell scripting
Thanks
Babu (11 Replies)
Discussion started by: ksmbabu
11 Replies
Template::Plugin::Table(3) User Contributed Perl Documentation Template::Plugin::Table(3)
NAME
Template::Plugin::Table - Plugin to present data in a table
SYNOPSIS
[% USE table(list, rows=n, cols=n, overlap=n, pad=0) %]
[% FOREACH item IN table.row(n) %]
[% item %]
[% END %]
[% FOREACH item IN table.col(n) %]
[% item %]
[% END %]
[% FOREACH row IN table.rows %]
[% FOREACH item IN row %]
[% item %]
[% END %]
[% END %]
[% FOREACH col IN table.cols %]
[% col.first %] - [% col.last %] ([% col.size %] entries)
[% END %]
DESCRIPTION
The "Table" plugin allows you to format a list of data items into a virtual table. When you create a "Table" plugin via the "USE"
directive, simply pass a list reference as the first parameter and then specify a fixed number of rows or columns.
[% USE Table(list, rows=5) %]
[% USE table(list, cols=5) %]
The "Table" plugin name can also be specified in lower case as shown in the second example above. You can also specify an alternative
variable name for the plugin as per regular Template Toolkit syntax.
[% USE mydata = table(list, rows=5) %]
The plugin then presents a table based view on the data set. The data isn't actually reorganised in any way but is available via the
"row()", "col()", "rows()" and "cols()" as if formatted into a simple two dimensional table of "n" rows x "n" columns.
So if we had a sample "alphabet" list contained the letters '"a"' to '"z"', the above "USE" directives would create plugins that
represented the following views of the alphabet.
[% USE table(alphabet, ... %]
rows=5 cols=5
a f k p u z a g m s y
b g l q v b h n t z
c h m r w c i o u
d i n s x d j p v
e j o t y e k q w
f l r x
We can request a particular row or column using the "row()" and "col()" methods.
[% USE table(alphabet, rows=5) %]
[% FOREACH item = table.row(0) %]
# [% item %] set to each of [ a f k p u z ] in turn
[% END %]
[% FOREACH item = table.col(2) %]
# [% item %] set to each of [ m n o p q r ] in turn
[% END %]
Data in rows is returned from left to right, columns from top to bottom. The first row/column is 0. By default, rows or columns that
contain empty values will be padded with the undefined value to fill it to the same size as all other rows or columns.
For example, the last row (row 4) in the first example would contain the values "[ e j o t y undef ]". The Template Toolkit will safely
accept these undefined values and print a empty string. You can also use the IF directive to test if the value is set.
[% FOREACH item = table.row(4) %]
[% IF item %]
Item: [% item %]
[% END %]
[% END %]
You can explicitly disable the "pad" option when creating the plugin to returned shortened rows/columns where the data is empty.
[% USE table(alphabet, cols=5, pad=0) %]
[% FOREACH item = table.col(4) %]
# [% item %] set to each of 'y z'
[% END %]
The "rows()" method returns all rows/columns in the table as a reference to a list of rows (themselves list references). The "row()"
methods when called without any arguments calls "rows()" to return all rows in the table.
Ditto for "cols()" and "col()".
[% USE table(alphabet, cols=5) %]
[% FOREACH row = table.rows %]
[% FOREACH item = row %]
[% item %]
[% END %]
[% END %]
The Template Toolkit provides the "first", "last" and "size" virtual methods that can be called on list references to return the first/last
entry or the number of entries in a list. The following example shows how we might use this to provide an alphabetical index split into 3
even parts.
[% USE table(alphabet, cols=3, pad=0) %]
[% FOREACH group = table.col %]
[ [% group.first %] - [% group.last %] ([% group.size %] letters) ]
[% END %]
This produces the following output:
[ a - i (9 letters) ]
[ j - r (9 letters) ]
[ s - z (8 letters) ]
We can also use the general purpose "join" virtual method which joins the items of the list using the connecting string specified.
[% USE table(alphabet, cols=5) %]
[% FOREACH row = table.rows %]
[% row.join(' - ') %]
[% END %]
Data in the table is ordered downwards rather than across but can easily be transformed on output. For example, to format our data in 5
columns with data ordered across rather than down, we specify "rows=5" to order the data as such:
a f . .
b g .
c h
d i
e j
and then iterate down through each column (a-e, f-j, etc.) printing the data across.
a b c d e
f g h i j
. .
.
Example code to do so would be much like the following:
[% USE table(alphabet, rows=3) %]
[% FOREACH cols = table.cols %]
[% FOREACH item = cols %]
[% item %]
[% END %]
[% END %]
Output:
a b c
d e f
g h i
j . .
.
In addition to a list reference, the "Table" plugin constructor may be passed a reference to a Template::Iterator object or subclass
thereof. The Template::Iterator get_all() method is first called on the iterator to return all remaining items. These are then available
via the usual Table interface.
[% USE DBI(dsn,user,pass) -%]
# query() returns an iterator
[% results = DBI.query('SELECT * FROM alphabet ORDER BY letter') %]
# pass into Table plugin
[% USE table(results, rows=8 overlap=1 pad=0) -%]
[% FOREACH row = table.cols -%]
[% row.first.letter %] - [% row.last.letter %]:
[% row.join(', ') %]
[% END %]
AUTHOR
Andy Wardley <abw@wardley.org> <http://wardley.org/>
COPYRIGHT
Copyright (C) 1996-2007 Andy Wardley. All Rights Reserved.
This module is free software; you can redistribute it and/or modify it under the same terms as Perl itself.
SEE ALSO
Template::Plugin
perl v5.16.3 2011-12-20 Template::Plugin::Table(3)