help [[row and columns]]

10 More Discussions You Might Find Interesting

1. 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

2. 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...

3. 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...

4. 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

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.

6. 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...

7. 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

8. 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

9. 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.................

10. UNIX for Dummies Questions & Answers

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

LEARN ABOUT PHP

msql_fetch_row

MSQL_FETCH_ROW(3)														 MSQL_FETCH_ROW(3)

msql_fetch_row - Get row as enumerated array

SYNOPSIS

       array msql_fetch_row (resource  $result)

DESCRIPTION

       msql_fetch_row(3)  fetches one row of data from the result associated with the specified query identifier. The row is returned as an array.
       Each result column is stored in an array offset, starting at offset 0.

	Subsequent call to msql_fetch_row(3) would return the next row in the result set, or FALSE if there are no more rows.

PARAMETERS

	      o $
		result -The result resource that is being evaluated. This result comes from a call to msql_query(3).

RETURN VALUES

	Returns an array that corresponds to the fetched row, or FALSE if there are no more rows.

EXAMPLES

       Example #1

	      msql_fetch_row(3) example

	      <?php
	      $con = msql_connect();
	      if (!$con) {
		  die('Server connection problem: ' . msql_error());
	      }

	      if (!msql_select_db('test', $con)) {
		  die('Database connection problem: ' . msql_error());
	      }

	      $result = msql_query('SELECT id, name FROM people', $con);
	      if (!$result) {
		  die('Query execution problem: ' . msql_error());
	      }

	      while ($row = msql_fetch_row($result)) {
		  echo $row[0] . ': ' . $row[1] . "
";
	      }

	      msql_free_result($result);
	      ?>

CHANGELOG

       +--------+---------------------------------------------------+
       |Version |						    |
       |	|						    |
       |	|		     Description		    |
       |	|						    |
       +--------+---------------------------------------------------+
       | 5.0.4	|						    |
       |	|						    |
       |	|  A bug was fixed when retrieving data  from  col- |
       |	| umns	containing  NULL  values. Such columns were |
       |	| not placed into the resulting array.		    |
       |	|						    |
       +--------+---------------------------------------------------+
SEE ALSO

       msql_fetch_array(3), msql_fetch_object(3), msql_data_seek(3), msql_result(3).

PHP Documentation Group 													 MSQL_FETCH_ROW(3)

Shell Programming and Scripting

help [[row and columns]]

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Transpose columns to row

Discussion started by: jiam912

2. UNIX for Dummies Questions & Answers

Select 2 columns and transpose row by row

Discussion started by: mvaishnav

3. UNIX for Dummies Questions & Answers

Dividing all columns by the nth row

Discussion started by: cosmologist

4. UNIX for Dummies Questions & Answers

help [[row and columns]]

Discussion started by: khaled1989kh

5. Shell Programming and Scripting

Print columns from each row

Discussion started by: elamurugu

6. UNIX for Dummies Questions & Answers

convert matrix to row and columns

Discussion started by: tintin72

7. Shell Programming and Scripting

Row to Columns question

Discussion started by: bleach8578

8. Shell Programming and Scripting

3 Columns to Row question

Discussion started by: elbombillo

9. Shell Programming and Scripting

how to change row into columns

Discussion started by: aaha_naga

10. UNIX for Dummies Questions & Answers

Row to Columns

Discussion started by: vskr72

LEARN ABOUT PHP

msql_fetch_row