Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Print min and max value from two column
Top Forums Shell Programming and Scripting Print min and max value from two column Post 302715597 by RudiC on Monday 15th of October 2012 06:25:56 AM
Old 10-15-2012
Try
Code:
awk     '$1 != tmp1     {
                         if (NR>1) printf "%s),\n", tmp2;
                         printf "%s = (%s -", $1, $2
                        }
         {tmp1=$1; tmp2=$2}
         END {printf "%s),\n", tmp2 }
        ' file

This User Gave Thanks to RudiC For This Post:
aksin
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

min and max value of process id

We are running a AIX 5.2 OS. Would anyone happen to know what the max value for a process id could be? Thanks jerardfjay :) (0 Replies)
Discussion started by: jerardfjay
0 Replies

2. Shell Programming and Scripting

get min, max and average value

hi! i have a file like the attachement. I'd like to get for each line the min, max and average values. (there is 255 values for each line) how can i get that ? i try this, is it right? BEGIN {FS = ","; OFS = ";";max=0;min=0;moy=0;total=0;freq=890} $0 !~ /Trace1:/ { ... (1 Reply)
Discussion started by: riderman
1 Replies

3. UNIX for Dummies Questions & Answers

loop? print max column in each line for 800 files and merge

Hello, I have 800 or so files with 3 columns each and >10000 lines each. For each file and each line I would like to print the maximum column number for each line. Then I would like to 'paste' each of these files together (column-wise) so that the file with expression in label '_1' is the... (6 Replies)
Discussion started by: peanuts48
6 Replies

4. Shell Programming and Scripting

Data stream between min and max

Hi, I have a text file containing numbers. There are up to 6 numbers per row and I need to read them, check if they are 0 and if they are not zero check if they are within a given interval (min,max). If they exceed the max or min they should be set to max or min respectively, if they are in the... (4 Replies)
Discussion started by: f_o_555
4 Replies

5. Shell Programming and Scripting

to find min and max value for each column!

Hello Experts, I have got a txt files which has multiple columns, I want to get the max, min and diff (max-min) for each column in the same txt file. Example: cat file.txt a 1 4 b 2 5 c 3 6 I want ouput like: cat file.txt a 1 4 b 2 5 c 3 6 Max 3 6 Min 1 4 Diff 2 2 awk 'min=="" ||... (4 Replies)
Discussion started by: dixits
4 Replies

6. UNIX for Dummies Questions & Answers

[Solved] Print a line using a max and a min values of different columns

Hi guys, I already search on the forum but i can't solve this on my own. I have a lot of files like this: And i need to print the line with the maximum value in last column but if the value is the same (2 in this exemple for the 3 last lines) i need get the line with the minimum value in... (4 Replies)
Discussion started by: MetaBolic0
4 Replies

7. Shell Programming and Scripting

Get the min avg and max with awk

aaa: 3 ms aaa: 2 ms aaa: 5 ms aaa: 10 ms .......... to get the 3 2 5 10 ...'s min avg and max something like min: 2 ms avg: 5 ms max: 10 ms (2 Replies)
Discussion started by: yanglei_fage
2 Replies

8. Shell Programming and Scripting

Get min and max value in column

Gents, I have a big file file like this. 5100010002 5100010004 5100010006 5100010008 5100010010 5100010012 5102010002 5102010004 5102010006 5102010008 5102010010 5102010012 The file is sorted and I would like to find the min and max value, taking in the consideration key1... (3 Replies)
Discussion started by: jiam912
3 Replies

9. Shell Programming and Scripting

Print root number between min and max ranges

Hi to all, Please help on the following problem, I'm not where to begin, if awk or shell script. I have pairs of ranges of numbers and I need to find the root or roots of ranges based on min Range and Max ranges Example #1: If min range is 120000 and max ranges 124999, it means that are... (5 Replies)
Discussion started by: Ophiuchus
5 Replies

10. UNIX for Beginners Questions & Answers

Print a row with the max number in a column

Hello, I have this table: chr1_16857_17742 - chr1 17369 17436 "ENST00000619216.1"; "MIR6859-1"; - 67 chr1_16857_17742 - chr1 14404 29570 "ENST00000488147.1"; "WASH7P"; - 885 chr1_16857_18061 - chr1 ... (5 Replies)
Discussion started by: coppuca
5 Replies

LEARN ABOUT OPENSOLARIS

mlib_matrixtranspose_s16

mlib_MatrixTranspose_U8(3MLIB)				    mediaLib Library Functions				    mlib_MatrixTranspose_U8(3MLIB)

NAME

       mlib_MatrixTranspose_U8,    mlib_MatrixTranspose_U8C,	mlib_MatrixTranspose_S8,    mlib_MatrixTranspose_S8C,	 mlib_MatrixTranspose_S16,
       mlib_MatrixTranspose_S16C, mlib_MatrixTranspose_S32, mlib_MatrixTranspose_S32C - matrix transpose, in place

SYNOPSIS

       cc [ flag... ] file... -lmlib [ library... ]
       #include <mlib.h>

       mlib_status mlib_MatrixTranspose_U8(mlib_u8 *xz, mlib_s32 mn);

       mlib_status mlib_MatrixTranspose_U8C(mlib_u8 *xz, mlib_s32 mn);

       mlib_status mlib_MatrixTranspose_S8(mlib_s8 *xz, mlib_s32 mn);

       mlib_status mlib_MatrixTranspose_S8C(mlib_s8 *xz, mlib_s32 mn);

       mlib_status mlib_MatrixTranspose_S16(mlib_s16 *xz, mlib_s32 mn);

       mlib_status mlib_MatrixTranspose_S16C(mlib_s16 *xz, mlib_s32 mn);

       mlib_status mlib_MatrixTranspose_S32(mlib_s32 *xz, mlib_s32 mn);

       mlib_status mlib_MatrixTranspose_S32C(mlib_s32 *xz, mlib_s32 mn);

DESCRIPTION

       Each of these functions performs an in-place transpose of a square matrix.

       For real data, the following pseudo code applies:

	 for (i = 1; i < mn; i++) {
	     for (j = 0; j < i; i++) {
		 tmp	      = xz[i*mn + j];
		 xz[i*mn + j] = xz[j*mn + i];
		 xz[j*mn + i] = tmp;
	     }
	 }

       For complex data, the following pseudo code applies:

	 for (i = 1; i < mn; i++) {
	     for (j = 0; j < i; i++) {
		 tmp0		      = xz[2*(i*mn + j)];
		 tmp1		      = xz[2*(i*mn + j) + 1];
		 xz[2*(i*mn + j)]     = xz[2*(j*mn + i)];
		 xz[2*(i*mn + j) + 1] = xz[2*(j*mn + i) + 1];
		 xz[2*(j*mn + i)]     = tmp0;
		 xz[2*(j*mn + i) + 1] = tmp1;
	     }
	 }

PARAMETERS

       Each of the functions takes the following arguments:

       xz    Pointer to the source and destination matrix.

       mn    Number of rows and columns in the matrix.

RETURN VALUES

       Each of the functions returns MLIB_SUCCESS if successful. Otherwise it returns MLIB_FAILURE.

ATTRIBUTES

       See attributes(5) for descriptions of the following attributes:

       +-----------------------------+-----------------------------+
       |      ATTRIBUTE TYPE	     |	    ATTRIBUTE VALUE	   |
       +-----------------------------+-----------------------------+
       |Interface Stability	     |Committed 		   |
       +-----------------------------+-----------------------------+
       |MT-Level		     |MT-Safe			   |
       +-----------------------------+-----------------------------+

SEE ALSO

       mlib_MatrixTranspose_U8(3MLIB), attributes(5)

SunOS 5.11							    2 Mar 2007					    mlib_MatrixTranspose_U8(3MLIB)
All times are GMT -4. The time now is 07:14 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy