Convert columns to row using awk Post: 302756069

8 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

convert matrix to row and columns

Dear Unix Gurus, I have a sample data set that looks like this y1 y2 y3 y4 y5 x1 0.3 0.5 2.3 3.1 5.1 x2 1.2 4.1 3.5 1.7 1.2 x3 3.1 2.1 1.0 4.1 2.1 x4 5.0 4.0 6.0 7.0 1.1 I want to open it up so that I get x1 y1 0.3 x2 y1 1.2 x3 y1 3.1 x4 y1 5.0 x1 y2 0.5 x2 y2...

2. Shell Programming and Scripting

How to convert 2 column data into multiple columns based on a keyword in a row??

Hi Friends I have the following input data in 2 columns. SNo 1 I1 Value I2 Value I3 Value SNo 2 I4 Value I5 Value I6 Value I7 Value SNo 3 I8 Value I9 Value ............... ................ SNo N

3. Shell Programming and Scripting

Convert columns to single row

Hello all I have data like 1 2 3 4 5 I wish my output would be like 1,2,3,4,5 For this i have executed 'BEGIN {FS="\n"; ORS=","} {print $0}' test and got the output as 1,2,3,4,5, I do not want to have , at the end of 5. output should be like

4. Shell Programming and Scripting

By using AWK can I convert matrice shaped data to a row ?

Hello, I have output in the matrice form , for example: 1 2 3 4 a b c d jim joe sue tom how can I convert this line-column data into a row as follows 1 2 3 4 a b c d jim joe sue tom thank you

5. Shell Programming and Scripting

awk print specific columns one row at a time

Hello, I have the following piece of code: roleName =`cat $inputFile | awk -F';' '{ print $1 }'` roleDescription =`cat $inputFile | awk -F';' '{ print $2 }'` roleAuthProfile =`cat $inputFile | awk -F';' '{ print $3 }'` mappedUserID

6. UNIX for Dummies Questions & Answers

awk: convert column to row in a specific way

Hi all! I have this kind of output: a1|b1|c1|d1|e1 a2|b2|c2 a3|b3|c3|d3 I would like to transpose columns d and e (when they exist) in column c, and under the row where they come from. Then copying the beginning of the row. In order to obtain: a1|b1|c1 a1|b1|d1 a1|b1|e1 a2|b2|c2...

7. Shell Programming and Scripting

Convert row to columns start from nth column

Dear All, We have input like this: 161 57 1378 176 1392 262 1444 441 1548 538 1611 670 1684 241 57 1378 208 1393 269 1447 444 1549 538 1610 677 1700 321 ...

8. Shell Programming and Scripting

awk split columns to row after N number of column

I want to split this with every 5 or 50 depend on how much data the file will have. And remove the comma on the end Source file will have 001,0002,0003,004,005,0006,0007,007A,007B,007C,007E,007F,008A,008C Need Output from every 5 tab and remove the comma from end of each row ...

LEARN ABOUT SUSE

gtk2::table

Gtk2::Table(3)						User Contributed Perl Documentation					    Gtk2::Table(3)

NAME

       Gtk2::Table

HIERARCHY

	 Glib::Object
	 +----Glib::InitiallyUnowned
	      +----Gtk2::Object
		   +----Gtk2::Widget
			+----Gtk2::Container
			     +----Gtk2::Table

INTERFACES

	 Glib::Object::_Unregistered::AtkImplementorIface
	 Gtk2::Buildable

METHODS

   widget = Gtk2::Table->new ($rows, $columns, $homogeneous=FALSE)
       o   $rows (integer)

       o   $columns (integer)

       o   $homogeneous (boolean)

   $table->attach ($child, $left_attach, $right_attach, $top_attach, $bottom_attach, $xoptions, $yoptions, $xpadding, $ypadding)
       o   $child (Gtk2::Widget)

       o   $left_attach (integer)

       o   $right_attach (integer)

       o   $top_attach (integer)

       o   $bottom_attach (integer)

       o   $xoptions (Gtk2::AttachOptions)

       o   $yoptions (Gtk2::AttachOptions)

       o   $xpadding (integer)

       o   $ypadding (integer)

   $table->attach_defaults ($widget, $left_attach, $right_attach, $top_attach, $bottom_attach)
       o   $widget (Gtk2::Widget)

       o   $left_attach (integer)

       o   $right_attach (integer)

       o   $top_attach (integer)

       o   $bottom_attach (integer)

   integer = $table->get_col_spacing ($column)
       o   $column (integer)

   $table->set_col_spacing ($column, $spacing)
       o   $column (integer)

       o   $spacing (integer)

   $table->set_col_spacings ($spacing)
       o   $spacing (integer)

   integer = $table->get_default_col_spacing
   integer = $table->get_default_row_spacing
   boolean = $table->get_homogeneous
   $table->set_homogeneous ($homogeneous)
       o   $homogeneous (boolean)

   $table->resize ($rows, $columns)
       o   $rows (integer)

       o   $columns (integer)

   integer = $table->get_row_spacing ($row)
       o   $row (integer)

   $table->set_row_spacing ($row, $spacing)
       o   $row (integer)

       o   $spacing (integer)

   $table->set_row_spacings ($spacing)
       o   $spacing (integer)

PROPERTIES

       'column-spacing' (Glib::UInt : readable / writable / private)
	   The amount of space between two consecutive columns

       'homogeneous' (boolean : readable / writable / private)
	   If TRUE, the table cells are all the same width/height

       'n-columns' (Glib::UInt : readable / writable / private)
	   The number of columns in the table

       'n-rows' (Glib::UInt : readable / writable / private)
	   The number of rows in the table

       'row-spacing' (Glib::UInt : readable / writable / private)
	   The amount of space between two consecutive rows

ENUMS AND FLAGS

   flags Gtk2::AttachOptions
       o   'expand' / 'GTK_EXPAND'

       o   'shrink' / 'GTK_SHRINK'

       o   'fill' / 'GTK_FILL'

SEE ALSO

       Gtk2, Glib::Object, Glib::InitiallyUnowned, Gtk2::Object, Gtk2::Widget, Gtk2::Container

COPYRIGHT

       Copyright (C) 2003-2008 by the gtk2-perl team.

       This software is licensed under the LGPL.  See Gtk2 for a full notice.

perl v5.12.1							    2010-07-05							    Gtk2::Table(3)