count the max by awk Post: 302262611

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Max column count in a file

I have to send a file to mainframe and before sending it, I have to execute the quote command to set the record length. Since the file is dynamic, I do not know what the maximum size of a line could be. Currently, I use the following function to get the Max Column Count. Since I use "sed" it...

2. Shell Programming and Scripting

Count time min/max/average for ping

I am redirecting my ping output to a file. The sample output is like this: 64 bytes from xx.xx.xx.167: icmp_seq=4490 ttl=116 3.75 ms 2011Jul12- 15 40 16 64 bytes from xx.xx.xx.167: icmp_seq=4491 ttl=116 5.29 ms 2011Jul12- 15 40 17 64 bytes from xx.xx.xx.167: icmp_seq=4492 ttl=116 4.88 ms...

3. Shell Programming and Scripting

Join and awk max column

Hi Friends, I have a file1 with 3400 records that are tab separated and I have a file2 with 6220 records. I want to merge both these files. I tried using join file1 and file2 after sorting. But, the records should be (3400*6220 = 21148000). Instead, I get only around 11133567. Is there anything...

4. Shell Programming and Scripting

How to find the average,min,max ,total count?

Hi , Below is my sample data,I have this 8 column(A,B,C,D,E,F,G,H) in csv file. A , B ,C ,D ,E ,F,G ,H 4141,127337,24,15,20,69,72.0,-3 4141,128864,24,15,20,65,66.0,-1 4141,910053,24,15,4,4,5.0,-1 4141,910383,24,15,22,3,4.0,-1 4141,496969,24,15,14,6,-24.0,-18...

5. Shell Programming and Scripting

awk - count character count of fields

Hello All, I got a requirement when I was working with a file. Say the file has unloads of data from a table in the form 1|121|asda|434|thesi|2012|05|24| 1|343|unit|09|best|2012|11|5| I was put into a scenario where I need the field count in all the lines in that file. It was simply...

6. Shell Programming and Scripting

awk to find the max

Experts, Here is my question. I have got file like below # cat file XYZb,24,26,6 XYZc,24,26,6 XYZe,24,25,5 XYZf,23,29,5 XYZi,16,25,5 XYZj,24,26,7 XYZn,17,23,4 XYZz,23,29,5 Now, I want to print the line's Column1 whose Column 3 is the max of all. My code is awk -F',' 'BEGIN {max...

7. Shell Programming and Scripting

[Solved] Using awk to calculate max value

I have a file of sites and each site has a variable number of flow values with a date for each value. I want to determine the max value of flow for each site and output the site number, max value, and date of max value.The format structure (simplified) is the following: Record Site Number ...

8. UNIX for Beginners Questions & Answers

How to count average and max respon time?

sorry i will revise first

9. UNIX for Beginners Questions & Answers

How to count respon time max min avg for nginx logs?

Hi All, need your help, i want count respon time max and average my nginx logs, based on hourly or minutes per api... my nginx.log sample : 10.1.1.1 - - "POST /v2/api/find/outlet/ HTTP/1.1" 200 2667 "-" "okhttp/3.12.0" "118.215.153.47" 0.178 0.178 . 10.1.1.1 - - "POST...

LEARN ABOUT DEBIAN

tcrtest

TCRTEST(1)							   Tokyo Tyrant 							TCRTEST(1)

NAME

       tcrtest - test cases of the remote database API

DESCRIPTION

       The command `tcrtest' is a utility for facility test and performance test.  This command is used in the following format.  `host' specifies
       the host name of the server.  `rnum' specifies the number of iterations.

	      tcrtest write [-port num] [-cnum num] [-tout num] [-nr] [-rnd] host rnum
		     Store records with keys of 8 bytes.  They change as `00000001', `00000002'...
	      tcrtest read [-port num] [-cnum num] [-tout num] [-mul num] [-rnd] host
		     Retrieve all records of the database above.
	      tcrtest remove [-port num] [-cnum num] [-tout num] [-rnd] host
		     Remove all records of the database above.
	      tcrtest rcat [-port num] [-cnum num] [-tout num] [-shl num] [-dai|-dad] [-ext name] [-xlr|-xlg] host rnum
		     Store records with partway duplicated keys using concatenate mode.
	      tcrtest misc [-port num] [-cnum num] [-tout num] host rnum
		     Perform miscellaneous test of various operations.
	      tcrtest wicked [-port num] [-cnum num] [-tout num] host rnum
		     Perform updating operations of list and map selected at random.
	      tcrtest table [-port num] [-cnum num] [-tout num] [-exp num] host rnum
		     Perform miscellaneous test of the table extension.

       Options feature the following.

	      -port num : specify the port number.
	      -cnum num : specify the number of connections.
	      -tout num : specify the timeout of each session in seconds.
	      -nr : use the function `tcrdbputnr' instead of `tcrdbput'.
	      -rnd : select keys at random.
	      -mul num : specify the number of records for the mget command.
	      -shl num : use `tcrdbputshl' and specify the width.
	      -dai : use `tcrdbaddint' instead of `tcrdbputcat'.
	      -dad : use `tcrdbadddouble' instead of `tcrdbputcat'.
	      -ext name : call a script language extension function.
	      -xlr : perform record locking.
	      -xlg : perform global locking.
	      -exp num : specify the lifetime of expiration test.

       If the port number is not more than 0, UNIX domain socket is used and the path of the socket file is specified by the host parameter.  This
       command returns 0 on success, another on failure.

SEE ALSO

       ttserver(1), ttultest(1), ttulmgr(1), tcrmttest(1), tcrmgr(1), ttutil(3), tcrdb(3)

Man Page							    2010-01-20								TCRTEST(1)