Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Row to Columns
Top Forums UNIX for Dummies Questions & Answers Row to Columns Post 302111349 by vskr72 on Wednesday 21st of March 2007 12:25:57 AM
Old 03-21-2007
Row to Columns
Hi,

I have a file like this.

1,1,1,0,0,0
1,1,2,1,0,0
1,1,3,0,0,0
1,1,4,0,0,0
...........
...........
1,1,24,0,0,0
1,1,25,0,0,0
1,1,26,1,0,0
1,1,27,0,0,0
1,2,1,0,0,0
1,2,2,0,0,0
1,2,3,0,0,0
1,2,4,0,0,0
1,2,5,1,0,0
1,2,6,1,0,0
............

I need to create an output file like this:

1
1
1
0
0
0
2
1
0
0

Basically, the output is like this:
1. The first record repeats as it is in vertical format.
2. Second record does not repeat completely. If u look at the file between teh first and 2nd record, what si common is 1,1. So, that is not repeated. But the data from 3rd column and onwards comes.
3. This repeats till we loop through all the 1,1 in the first and 2nd columns.
4. Then we start with record 1,2,1,0,0,0, because the first and the 2nd columns do not match
5. When we read the next record, we skip 1,2 and just take values from 3rd column onwards.

Hope my requirement or description is clear. Thanks.

Satish
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

how to change row into columns

hi, I have a input file like a,123,456,789,012,.......,b I need to change the output file into a,123,b a,456,b a,789,b a,012,b a,...,b like that.. how to achieve that through UNIX................. (5 Replies)
Discussion started by: aaha_naga
5 Replies

2. Shell Programming and Scripting

3 Columns to Row question

I have a file that looks like this... a b c d e f g h i I would like to it to be like this a b c d e f g h i Thanks (8 Replies)
Discussion started by: elbombillo
8 Replies

3. Shell Programming and Scripting

Row to Columns question

Hi, I have a question for Row to Columns by script. e.g. i have a file Start 1 2 3 4 End Start 1 2 3 3 4 4 End (6 Replies)
Discussion started by: bleach8578
6 Replies

4. 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... (3 Replies)
Discussion started by: tintin72
3 Replies

5. Shell Programming and Scripting

Print columns from each row

I have awk command to print column 8 awk '/select/ {print $8}' which will print column 8 But I need to print 3, 5 and 8 column in a row and each column should be de-limited by "\t" Hope anyone help me quickly. (2 Replies)
Discussion started by: elamurugu
2 Replies

6. Shell Programming and Scripting

help [[row and columns]]

i ask to do ,,program that convert the last row to be the first row ,,,and after that exchange the the columns ex,, 1 2 3 4 5 6 7 8 9 to be 7 8 9 4 5 6 1 2 3 and then to be 9 8 7 6 5 4 3 2 1 give mee the code .... (0 Replies)
Discussion started by: khaled1989kh
0 Replies

7. UNIX for Dummies Questions & Answers

help [[row and columns]]

i ask to do ,,program that convert the last row to be the first row ,,,and after that exchange the the columns ex,, 1 2 3 4 5 6 7 8 9 to be 7 8 9 4 5 6 1 2 3 and then to be 9 8 7 6 5 4 3 2 1 (0 Replies)
Discussion started by: khaled1989kh
0 Replies

8. UNIX for Dummies Questions & Answers

Dividing all columns by the nth row

Hi All! if I have a file like this: 8 10 12 14 16 18 0 2 6 2 4 6 8 10 12 16 18 10 6 8 12 16 18 0 2 2 6 2 2 2 2 2 2 2 2 2 10 12 16 4 8 16 4 16 0 8 10 14 16 0 4 8 12 14 And I want to divide all the lines by line 4 for example... (6 Replies)
Discussion started by: cosmologist
6 Replies

9. UNIX for Dummies Questions & Answers

Select 2 columns and transpose row by row

Hi, I have a tab-delimited file as follows: 1 1 2 2 3 3 4 4 a a b b c c d d 5 5 6 6 7 7 8 8 e e f f g g h h 9 9 10 10 11 11 12 12 i i j j k k l l 13 13 14 14 15 15 16 16 m m n n o o p p The output I need is: 1 1 a a 5 5 e e 9 9 i i 13... (5 Replies)
Discussion started by: mvaishnav
5 Replies

10. Shell Programming and Scripting

Transpose columns to row

Gents Using the attached file and using this code. awk '{print substr($0,4,2)}' input.txt | sort -k1n | awk '{a++}END{for(i in a) print i,a}' | sort -k1 > output i got the this output. 00 739 01 807 02 840 03 735 04 782 05 850 06 754 07 295 08 388 09 670 10 669 11 762 (8 Replies)
Discussion started by: jiam912
8 Replies

LEARN ABOUT PHP

db2_special_columns

DB2_SPECIAL_COLUMNS(3)							 1						    DB2_SPECIAL_COLUMNS(3)

db2_special_columns - Returns a result set listing the unique row identifier columns for a table

SYNOPSIS

       resource db2_special_columns (resource  $connection, string  $qualifier, string	$schema, string  $table_name, int  $scope)

DESCRIPTION

	Returns a result set listing the unique row identifier columns for a table.

PARAMETERS

	      o $connection
		- A valid connection to an IBM DB2, Cloudscape, or Apache Derby database.

	      o $qualifier
		- A qualifier for DB2 databases running on OS/390 or z/OS servers. For other databases, pass NULL or an empty string.

	      o $schema
		- The schema which contains the tables.

	      o $table_name
		- The name of the table.

	      o $scope
		-  Integer  value representing the minimum duration for which the unique row identifier is valid. This can be one of the following
		values:

	      +--------------+--------------------------------------+---+
	      |Integer value |					    |	|
	      | 	     |					    |	|
	      | 	     |		   SQL constant 	    |	|
	      | 	     |					    |	|
	      | 	     |		   Description		    |	|
	      | 	     |					    |	|
	      +--------------+--------------------------------------+---+
	      |      0	     |					    |	|
	      | 	     |					    |	|
	      | 	     |		 SQL_SCOPE_CURROW	    |	|
	      | 	     |					    |	|
	      | 	     | Row identifier is valid	only  while |	|
	      | 	     | the cursor is positioned on the row. |	|
	      | 	     |					    |	|
	      |      1	     |					    |	|
	      | 	     |					    |	|
	      | 	     |	      SQL_SCOPE_TRANSACTION	    |	|
	      | 	     |					    |	|
	      | 	     | Row  identifier	is  valid  for	the |	|
	      | 	     | duration of the transaction.	    |	|
	      | 	     |					    |	|
	      |      2	     |					    |	|
	      | 	     |					    |	|
	      | 	     |		SQL_SCOPE_SESSION	    |	|
	      | 	     |					    |	|
	      | 	     | Row  identifier	is  valid  for	the |	|
	      | 	     | duration of the connection.	    |	|
	      | 	     |					    |	|
	      +--------------+--------------------------------------+---+
RETURN VALUES

	Returns  a  statement resource with a result set containing rows with unique row identifier information for a table. The rows are composed
       of the following columns:

       +------------+---------------------------------------------------+
       |Column name |							|
       |	    |							|
       |	    |			 Description			|
       |	    |							|
       +------------+---------------------------------------------------+
       |   SCOPE    |							|
       |	    |							|
       |	    |							|
       |	    |							|
       |	    |	     box, tab (|); c | c | c |	.   T{	Integer |
       |	    |	     value					|
       |	    |							|
       |	    |			SQL constant			|
       |	    |							|
       |	    |			 Description			|
       |	    |							|
       +------------+---------------------------------------------------+
       |     0	    |							|
       |	    |							|
       |	    |		      SQL_SCOPE_CURROW			|
       |	    |							|
       |	    | Row  identifier is valid only while the cursor is |
       |	    | positioned on the row.				|
       |	    |							|
       |     1	    |							|
       |	    |							|
       |	    |		    SQL_SCOPE_TRANSACTION		|
       |	    |							|
       |	    | Row identifier is valid for the duration	of  the |
       |	    | transaction.					|
       |	    |							|
       |     2	    |							|
       |	    |							|
       |	    |		      SQL_SCOPE_SESSION 		|
       |	    |							|
       |	    | Row  identifier  is valid for the duration of the |
       |	    | connection.					|
       |	    |							|
       +------------+---------------------------------------------------+
       T} T{ COLUMN_NAME

       T} |T{ Name of the unique column.

       T} T{ DATA_TYPE

       T} |T{ SQL data type for the column.

       T} T{ TYPE_NAME

       T} |T{ Character string representation of the SQL data type for the column.

       T} T{ COLUMN_SIZE

       T} |T{ An integer value representing the size of the column.

       T} T{ BUFFER_LENGTH

       T} |T{
	Maximum number of bytes necessary to store data from this column.

       T} T{ DECIMAL_DIGITS

       T} |T{
	The scale of the column, or NULL where scale is not applicable.

       T} T{ NUM_PREC_RADIX

       T} |T{
	An integer value of either 10 (representing an exact numeric data type), 2 (representing an approximate numeric data type), or NULL  (rep-
       resenting a data type for which radix is not applicable).

       T} T{ PSEUDO_COLUMN

       T} |T{ Always returns 1.

       T}

SEE ALSO

       db2_column_privileges(3),  db2_columns(3),  db2_foreign_keys(3), db2_primary_keys(3), db2_procedure_columns(3), db2_procedures(3), db2_sta-
       tistics(3), db2_table_privileges(3), db2_tables(3).

PHP Documentation Group 												    DB2_SPECIAL_COLUMNS(3)
All times are GMT -4. The time now is 04:35 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy