04-17-2013
Thanks hanson44. SED script helped us.
We don't have gawk,nawk in our env.
Thanks
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Can we transpose rows to columns? Fields within row are separated by a comma. (10 Replies)
Discussion started by: videsh77
10 Replies
2. Shell Programming and Scripting
Hi i have a file which has values seperated by "," as shown below and I want to transpose for every doc_id in one row.
Input:
DOC_ID,KEYWORD
105,REGISTROS
105,GEOLOGIA
105,NUCLEOS
105,EXPEDIENTE
105,PROGRAMAS
10025,EXPEDIENTE
10025,LOCALIZACIONES
10025,OFICIOS
10025,PROGRAMAS... (4 Replies)
Discussion started by: juelillo
4 Replies
3. Shell Programming and Scripting
Hi All,
I have been trying to transpose rows to column in an large file (about 15000 lines) between matching pattern. Searched all posts in this forum, but not able find the solution to my problem. Any help appreciated.!!
Input
/*------XXXXXX-------*/
owner: XXXX
location: XXXX... (3 Replies)
Discussion started by: RobP
3 Replies
4. Shell Programming and Scripting
Hi Folks,
Iam a kinda newbie to unix shell scripting, the scenario is i have a text file containing the following info
Charlie chicago 15
Charlie newyork 26
jonny chicago 14
jonny newyork 15
joe chicago 15
joe newyork 18output should be
Name chicago ... (3 Replies)
Discussion started by: tech_frk
3 Replies
5. Shell Programming and Scripting
Hi there,
I have a small csv file example below:
source,cu_001,cu_001_volume,cu_001_mass,cu_002,cu_002_volume,cu_002_mass,cu_003,cu_003_volume,cu_003_mass
ja116,1.33,3024000,9374400,1.54,3026200,9375123,1.98,3028000,9385512
I want to transpose columns to rows starting at the second... (3 Replies)
Discussion started by: theflamingmoe
3 Replies
6. Shell Programming and Scripting
Hi All,
In shell, I have below data coming from some some text file as below:
. 351706 5861.8 0.026 0.012 12.584 0.026 0.012 12.582 0.000 0.000 0.000
Now i need the above data to be transposed as below
351706... (16 Replies)
Discussion started by: Anamica
16 Replies
7. Shell Programming and Scripting
I'm using the testawk.awk from the following thread
https://www.unix.com/shell-programming-and-scripting/18897-row-column-transpose.htmlI'm getting the following output
fieldname1 data1
fieldname2 data2
fieldname3 data3
How can I get like this instead
1 fieldname1 data1
2 fieldname2 data2... (1 Reply)
Discussion started by: makkan
1 Replies
8. Shell Programming and Scripting
Gents,
Transpose from row to column, taking in consideration the first column, which contends the date.
Input file
72918,111000009,111000009,111000009,111000009,111000009,111000009,111000009,111000009,111000009
72918,2356,2357,2358,2359,2360,2361,2362,2363,2364
72918,0,0,0,0,0,0,0,0,0... (12 Replies)
Discussion started by: jiam912
12 Replies
9. Shell Programming and Scripting
Hello guys,
First of all happy holidays and happy new year.
I'm new in bioinformatic and also it is my first time that I write in this forum. Therefore, sorry if I make some mistakes.
I'm writing to ask your help to fix a problem:
I have a file like this:
gene1 GO:0016491|GO:0055114... (8 Replies)
Discussion started by: Salvatore_espos
8 Replies
10. UNIX for Beginners Questions & Answers
Hi,
I have data in form of
A ram
B shyam
C seeta
D geeta
A bob
B methew
C Richad
D Mike
and i want it in this form.
A B C D
ram shyam seeta geeta
bob methew Richard Mike.
please help by providing the scripting for this. (3 Replies)
Discussion started by: ricbha
3 Replies
LEARN ABOUT DEBIAN
alzabo::runtime::joincursor
Alzabo::Runtime::JoinCursor(3pm) User Contributed Perl Documentation Alzabo::Runtime::JoinCursor(3pm)
NAME
Alzabo::Runtime::JoinCursor - Cursor that returns arrays of "Alzabo::Runtime::Row" objects
SYNOPSIS
use Alzabo::Runtime::JoinCursor;
my $cursor = $schema->join( tables => [ $foo, $bar ],
where => [ $foo->column('foo_id'), '=', 1 ] );
while ( my @rows = $cursor->next )
{
print $rows[0]->select('foo'), "
";
print $rows[1]->select('bar'), "
";
}
DESCRIPTION
Objects in this class are used to return arrays of Alzabo::Runtime::Row objects when requested. The cursor does not preload objects but
rather creates them on demand, which is much more efficient. For more details on the rational please see the RATIONALE FOR CURSORS section
in Alzabo::Design.
INHERITS FROM
"Alzabo::Runtime::Cursor"
METHODS
next
Returns the next array of "Alzabo::Runtime::Row" objects or an empty list if no more are available.
If an individual row could not be fetched, then the array may contain some "undef" values. For outer joins, this is normal behavior, but
for regular joins, this probably indicates a data error.
all_rows
This method fetches all the rows available from the current point onwards. This means that if there are five set of rows that will be
returned when the object is created and you call "next()" twice, calling "all_rows()" after it will only return three sets.
The return value is an array of array references. Each of these references represents a single set of rows as they would be returned from
the "next" method.
reset
Resets the cursor so that the next "next()" call will return the first row of the set.
count
Returns the number of rowsets returned by the cursor so far.
next_as_hash
Returns the next rows in a hash, where the hash keys are the table names and the hash values are the row object. If a table has been
included in the join via an outer join, then it is only included in the hash if there is a row for that table.
AUTHOR
Dave Rolsky, <autarch@urth.org>
perl v5.8.8 2007-12-23 Alzabo::Runtime::JoinCursor(3pm)