|
|
Sponsored Content
Top Forums
Shell Programming and Scripting
awk, string as record separator, transposing rows into columns
Post 302513541 by Shell_Life on Wednesday 13th of April 2011 02:03:46 PM
04-13-2011
|
|
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
----File attached.
Input file
===========
COL_1 <IP Add 1>
COL_2 <Service1>
COL_3 <ABCDEFG>
COL_4 <IP ADD:PORT>
COL_4 <IP ADD:PORT>
COL_1 <IP Add 2>
COL_2 <Service2>
COL_2 <Service3>
COL_2 <Service4>
COL_3 <AAAABBB>
COL_4 <IP ADD:PORT>
COL_4 <IP ADD:PORT>
COL_4 <IP... (27 Replies)
Discussion started by: bluethunder
27 Replies
2. Shell Programming and Scripting
I want a sweet simple time efficient awk script in online which gets output
001_r 0.0265185 0.0437049 0.0240642 0.0310264 0.0200482 0.0146746 0.0351344 0.0347856 0.036119 1.49
firstcoloumnvalue allvaluesof 'c' in one row
001_r : 002_r c: 0.0265185 N: 548
001_r : 007_r c:... (5 Replies)
Discussion started by: phoenix_nebula
5 Replies
3. Shell Programming and Scripting
I have a file like the one given below
P1|V1|V2
P1|V1|V3
P1V1|V2
P2|V1|V4
P2|V2|V6
P2|V1|V4
I want it convert to
P1|V1|V2|V2|V3
P2|V1|V4|V2|V6
2nd and 3rd column should be considered as together and so the tird row is duplicate
Any ideas? (3 Replies)
Discussion started by: prasperl
3 Replies
4. Shell Programming and Scripting
I have 1000s of these rows that I would like to transpose to columns. However I would like the transpose every 3 consecutive rows to columns like below, sorted by column 3 and provide a total for each occurrences. Finally I would like a grand total of column 3.
21|FE|41|0B
50\65\78
15... (2 Replies)
Discussion started by: ravzter
2 Replies
5. Shell Programming and Scripting
I have to create a Perl script which will transpose the data output from my experiment, from columns to rows, in order for me to analyse the data.
I am a complete Perl novice so any help would be greatly appreciated.
The data as it stands looks like this:
Subject Condition Fp1 ... (12 Replies)
Discussion started by: Sarah_W
12 Replies
6. Shell Programming and Scripting
Hi, I need to transpose columns of my files into rows and save it as individual files. sample contents of the file below.
0.9120 0.7782 0.6959 0.6904 0.6322 0.8068 0.9082
0.9290 0.7272 0.9870 0.7648 0.8053 0.8300 0.9520
0.8614 0.6734 0.7910 0.6413 0.7126 0.7364 0.8491
0.8868 0.7586 0.8949... (8 Replies)
Discussion started by: ida1215
8 Replies
7. Shell Programming and Scripting
Here is the contents of an input file.
A,1,2,3,4
10,aaa,bbb,ccc,ddd
11,eee,fff,ggg,hhh
12,iii,jjj,lll,mmm
13,nnn,ooo,ppp
I wanted the output to be
A
10 1 aaa
10 2 bbb
10 3 ccc
10 4 ddd
11 1 eee
11 2 fff
11 3 ggg
11 4 hhh .....
and so on How to do it in ksh... (9 Replies)
Discussion started by: ksatish89
9 Replies
8. Shell Programming and Scripting
Hi,
I am trying to transpose rows to columns for thousands of records. The problem is there are records that have the same lines that need to be separated. the input file as below:-
ID 1A02_HUMAN
AC P01892; O19619; P06338; P10313; P30444; P30445; P30446; P30514;
AC Q29680; Q29837;... (2 Replies)
Discussion started by: redse171
2 Replies
9. Shell Programming and Scripting
Hello to all,
Please some help on this. I have the file in format as below.
How can I set the record separator as the string below in red
"No. Time Source Destination Protocol Length Info"
I've tried code below but it doesn't seem to... (6 Replies)
Discussion started by: cgkmal
6 Replies
10. Shell Programming and Scripting
Hi All,
I have a requirement to flatten data out, based on the value in COL_2. Our file is pipe delimited, however COL_2 contains a comma separated string, which we would like to pivot out from one row into multiple rows. Please see my example input data below:
Input Data
... (4 Replies)
Discussion started by: RichZR
4 Replies
LEARN ABOUT PHP
db2_field_display_size
DB2_FIELD_DISPLAY_SIZE(3) 1 DB2_FIELD_DISPLAY_SIZE(3) db2_field_display_size - Returns the maximum number of bytes required to display a column SYNOPSIS
int db2_field_display_size (resource $stmt, mixed $column) DESCRIPTION
Returns the maximum number of bytes required to display a column in a result set. PARAMETERS
o $stmt - Specifies a statement resource containing a result set. o $column - Specifies the column in the result set. This can either be an integer representing the 0-indexed position of the column, or a string containing the name of the column. RETURN VALUES
Returns an integer value with the maximum number of bytes required to display the specified column. If the column does not exist in the result set, db2_field_display_size(3) returns FALSE. SEE ALSO
db2_field_name(3), db2_field_num(3), db2_field_precision(3), db2_field_scale(3), db2_field_type(3), db2_field_width(3). PHP Documentation Group DB2_FIELD_DISPLAY_SIZE(3)