print first and last row Post: 302706433

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Print out a row of data

hi im completely new at unix so dont hate me for asking what is probably the easiest question ever. below is an extract of some data im processing. the first column is like a counter while the second is an ip address. i need to be able to output the ip address based on which has the largest...

2. Shell Programming and Scripting

only print a selected row

this works: cat file.txt| awk 'NR==45,NR==55' but how do I assign variables instead of numbers: this does not work: cat file.txt | awk 'NR==$start,NR==$end' there need variables instead of numbers Sorry for my English Thank you for answer

3. Shell Programming and Scripting

Print the row element till the next row element appear in a column

Hi all I have file with columns F3 pathway CPS F2 H2 H4 H5 H6 no pathway CMP H7 H8 H9 H10 My expected output is F3 pathway CPS F2 pathway CPS

4. UNIX for Dummies Questions & Answers

Print last row of numbers

I have a spreadsheet of extremely long rows of numbers. I want to print only the last column. Tried using printf but there seems to be too many rows. example: 3 100 34 7 23 0 8 ..... X 400 203 778 1 ..........Y 58 3 9 0 100 ..........Z I only want to print X, Y and...

5. UNIX for Dummies Questions & Answers

awk to print first row with forth column and last row with fifth column in each file

file with this content awk 'NR==1 {print $4} && NR==2 {print $5}' file The error is shown with syntax error; what can be done

6. Shell Programming and Scripting

Print various rows in one row

I have this in a file 11.22.33.44 yyyyyyuser With awk/sed, I need this to be output as follows alias server.domain.com='ssh yyyyyyuser@11.22.33.44'

7. Shell Programming and Scripting

Get row number from file1 and print that row of file2

Hi. How can we print those rows of file2 which are mentioned in file1. first character of file1 is a row number.. for eg file1 1:abc 3:ghi 6:pqr file2 a abc b def c ghi d jkl e mno f pqr ...

8. Shell Programming and Scripting

Read row number from 1 file and print that row of second file

Hi. How can I read row number from one file and print that corresponding record present at that row in another file. eg file1 1 3 5 7 9 file2 11111 22222 33333 44444 55555 66666 77777 88888 99999

9. Shell Programming and Scripting

Search row by row from one file to another file if match is found print few colums of file 2

this is the requirement list.txt table1 table2 table3 testfile.txt name#place#data#select * from table1 name2#place2#data2#select * from table 10 innerjoin table3 name2#place2#data2#select * from table 10 output name place table1 name2 place table3 i tried using awk

10. Shell Programming and Scripting

Print row on 4th column to all row

Dear All, I have input : SEG901 5173 9005 5740 SEG902 5227 5284 SEG903 5284 5346 SEG904 5346 9010 SEG905 5400 5456 SEG906 5456 5511 SEG907 5511 9011 SEG908 5572 9015 SEG909 5622 9020 SEG910 5678 5739 SEG911 5739 5796 SEG912 5796 9025 ...

LEARN ABOUT PHP

mysql_fetch_row

MYSQL_FETCH_ROW(3)							 1							MYSQL_FETCH_ROW(3)

mysql_fetch_row - Get a result row as an enumerated array

SYNOPSIS

       Warning

	      This  extension  is deprecated as of PHP 5.5.0, and will be removed in the future. Instead, the MySQLi or PDO_MySQL extension should
	      be used. See also MySQL: choosing an API guide and related FAQ for more information. Alternatives to this function include:

		     omysqli_fetch_row(3)

		     o PDOStatement::fetch

       array mysql_fetch_row (resource	$result)

DESCRIPTION

	Returns a numerical array that corresponds to the fetched row and moves the internal data pointer ahead.

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

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

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

       Example #1

	      Fetching one row with mysql_fetch_row(3)

	      <?php
	      $result = mysql_query("SELECT id,email FROM people WHERE id = '42'");
	      if (!$result) {
		  echo 'Could not run query: ' . mysql_error();
		  exit;
	      }
	      $row = mysql_fetch_row($result);

	      echo $row[0]; // 42
	      echo $row[1]; // the email value
	      ?>

       Note

	      This function sets NULL fields to the PHP NULL value.

       mysql_fetch_array(3), mysql_fetch_assoc(3), mysql_fetch_object(3), mysql_data_seek(3), mysql_fetch_lengths(3), mysql_result(3).

PHP Documentation Group 													MYSQL_FETCH_ROW(3)