counts for every 1000 interval

8 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Counts not matching in file

I can not figure out why there are 56,548 unique entries in test.bed. However, perl and awk see only 56,543 and that # is what my analysis see's as well. What happened to the 5 missing? Thank you :). The file is attached as well. cmccabe@DTV-A5211QLM:~/Desktop/NGS/bed/bedtools$wc -l...

2. UNIX for Dummies Questions & Answers

Get counts from List

This is very easy , but I`m struggling .. please help modify my script, I want to count the number of h and n , from the second column group by the first. The second column is binary, can only have h and n. a h a h a n a n a h b h b h b h b h b h c n c h c h c h c h

3. Shell Programming and Scripting

compare the interval of 2 numbers of input2with interval of several numbers of input1

Help plz Does any one have any idea how to compare interval ranges of 2 files. finding 1-4 (1,2,3,4) of input2 in input1 of same key "a" values (5-10, 30-40, 45-60, 80-90, 100-120 ). Obviously 1-4 is not one of the range with in input1 a. so it should give out of range. finding 30-33(31,32,33)...

4. UNIX for Dummies Questions & Answers

counts

To start I have a table that has ticketholders. Each ticket holder has a unique number and each ticket holder is associated to a so called household number. You can have multiple guests w/i a household. I would like to create 3 flags (form a, for a household that has 1-4 gst) form b 5-8 gsts...

5. Solaris

file size counts??

Hello experts, I do - $ ls -lhtr logs2007* Is it possible that i can get the results of- totals size in MB/KB for ALL "logs2007*" note: in the same directory I have "logs2006*" & "logs2007*" files.

6. Shell Programming and Scripting

to grep and print their counts

suppose u have a file ACFCFACCACARCSHFARCVJVASTVAJFTVAJVGHBAJ another file A C F R then output shud be A= 9 C=7 F=3 R=2 Thanks

7. UNIX for Advanced & Expert Users

Group by columns and get the counts

Hi Gurus, I have a file 1|usa|hh 2|usa|ll 3|usa|vg 4|usa|vg 5|usa|vg 6|usa|vg 7|usa|ll 8|uk|nn 9|uk|bb 10|uk|bb 11|kuwait|mm 12|kuwait|jkj 13|kuwait|mm 14|dubai|hh I want to group by last two columns and get the last two recs and count.

8. UNIX for Dummies Questions & Answers

counts

How can i do a simple record count in my shell script? i just want to count the number of records i receive from a specific file.

LEARN ABOUT PHP

ifx_affected_rows

IFX_AFFECTED_ROWS(3)							 1						      IFX_AFFECTED_ROWS(3)

ifx_affected_rows - Get number of rows affected by a query

SYNOPSIS

       int ifx_affected_rows (resource	$result_id)

DESCRIPTION

	Returns the number of rows affected by a query associated with $result_id.

	For  inserts, updates and deletes the number is the real number (sqlerrd[2]) of affected rows. For selects it is an estimate (sqlerrd[0]).
       Don't rely on it. The database server can never return the actual number of rows that will be returned by a SELECT because it has not  even
       begun fetching them at this stage (just after the "PREPARE" when the optimizer has determined the query plan).

	Useful after ifx_prepare(3) to limit queries to reasonable result sets.

PARAMETERS

	      o $result_id
		- A valid result id returned by ifx_query(3) or ifx_prepare(3).

RETURN VALUES

	Returns the number of rows as an integer.

EXAMPLES

       Example #1

	      Informix affected rows

	      <?php
	      $rid = ifx_prepare("select * from emp
				   where name like " . $name, $connid);
	      if (! $rid) {
		  /* ... error ... */
	      }
	      $rowcount = ifx_affected_rows($rid);
	      if ($rowcount > 1000) {
		  printf ("Too many rows in result set (%d)
<br />", $rowcount);
		  die ("Please restrict your query<br />
");
	      }
	      ?>

SEE ALSO

       ifx_num_rows(3).

PHP Documentation Group 												      IFX_AFFECTED_ROWS(3)

Shell Programming and Scripting