10 More Discussions You Might Find Interesting
1. UNIX for Beginners Questions & Answers
I have a large csv dataset like this : A value1
A value2
A value3
B value1
B value2
B value3
C value1
C value2
C value3
what I expected output is :A value1 value2 value3
B value1 value2 value3
C value1 value2 value3
I'm thinking of use like awk, columns , but haven't find a proper... (4 Replies)
Discussion started by: nengcheng
4 Replies
2. UNIX for Beginners Questions & Answers
Hi,
I have input dataset as below:
Cl.jenn,1051,ABCD
JEN.HEA,9740|1517|8119|2145,ZZZZ,REPEAT
Rich.Sm,
Ann.Car,3972|4051|1064|4323|4122|2394|2574|4507
Sta.for,7777,ABCD,UUUU
Sm.Ric,
Ch.LRD,
Eh.ab,
Gr.sh,
Expected output:
-------------------
Cl.jenn,1051,ABCD... (6 Replies)
Discussion started by: saravananravim
6 Replies
3. Shell Programming and Scripting
Any one can help me in converting columns into rows.
example
I have input file
10000|
10002|
10003|
10004|
10005|
I want output in below format
PARTY|PART_DT
10000|12080000000
10002|13075200000
10003|13939200000
10004|1347200000
10004|133600000
10004|1152000000 (13 Replies)
Discussion started by: syd
13 Replies
4. Shell Programming and Scripting
Hi
I have a requirement, where i will receive multiple files in a folder (say: /fol1/fol2/). There will be at least 14 to 16 files. The size of the files will different, some may be 80GB or 90GB, some may be less than 5 GB (and the size of the files are very unpredictable). But the names of the... (10 Replies)
Discussion started by: kpk_ds
10 Replies
5. Shell Programming and Scripting
Dear community,
I have to split string in table and list all values. I'll skip the code and jump directly to mysql query.
This is the table:
category title
======= =======
7,3 title 1
1,3 title 2
1,2,3 title 3
Now, what I need is split category into single... (2 Replies)
Discussion started by: Lord Spectre
2 Replies
6. Shell Programming and Scripting
Hi,
I have a file as
ABC 123_456_789 234_678_901
XYZ 1100_1250_1580_1680 1175_1440_1620_1890
so on
What I want my output file to look is "split by underscore and then place the contents in rows"
output
ABC 123 234
ABC 456 678
ABC 789 901
XYZ 1100 1175
XYZ 1250 1440... (3 Replies)
Discussion started by: Diya123
3 Replies
7. Shell Programming and Scripting
Hi pls help me out to short out this problem
rm PAB113_011.out
rm: PAB113_011.out: override protection 644 (yes/no)? n
If i give y it remove the file.
But i added the rm command as a part of ksh file and i tried to remove the file. Its not removing and the the file prompting as... (7 Replies)
Discussion started by: sri_aue
7 Replies
8. Shell Programming and Scripting
Hi Experts,
I am working on HP-UX. I am new to shell scripting. I would like to have a shell script which will prefix:
1. "H|" before first row of my file and,
2. "T" for all other rows of the file.
For Example - File before running the script 20100430|4123451810|218.50|TC
20100430 ... (4 Replies)
Discussion started by: phani333
4 Replies
9. Shell Programming and Scripting
Hi all,
I need a simple bin/sh script
FILE1:
ab1 gegege swgdeyedg
ac2 jxjjxjxjxxjxjx
ad3
ae4 xjxjxj zhzhzh ahahs
af5 sjsjsjs ssjsjsjsj sjsjsj
ag6 shshshshs sjjssj
shhshshs
myScript.sh has to return:
ROW ab1
ROW ac2
ROW ad3
ROW ae4
In other words: "ROW " + the first world... (3 Replies)
Discussion started by: ric79
3 Replies
10. Shell Programming and Scripting
Hi I wanted to split rows based on the number of 1's present in 21st field(21st field is 40 length field) so I wrote the below awk code. However, the tool that I am using to invoke the command is not recognising the command. So, could you please help me to translate this command to sed?
awk... (5 Replies)
Discussion started by: ahmedwaseem2000
5 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)