Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

awk to find maximum and minimum from column and store in other column

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting awk to find maximum and minimum from column and store in other column
# 8  
Old 05-08-2018
To you last request: these fora are an excellent source of examples on how to apply awk (and other tools) to solve tricky, special problems.

In general: I think you need to learn to exercise due care when posting a request, like correctly collecting and formatting representative sample data, describing logical relations and context, and phrasing conditions. And, don't ignore questions to unclear specifications and / or data.
All that done, you won't need several other posts to hop around correcting / modifying sample data, and explaining (or even correcting) statements.

A very small adaption of my post#6 proposal will make the output
Code:
    a|b|c|d|g|h|i|j|k
    27AUFDDJD45474|032018|||IN546474DGDGD00|IN546474DGDGD00|1||1
    27AAAC8C1ZZ|042018|||IN27201800023182|IN27201800024289|1108||1108
    27AAAC87PP|042018|||IN272094674547|IN272094674547|1||1

when applied to the ORIGINAL data in post#1, before you modified it (which, BTW, is regarded impolite at least as it makes later references look silly...). You are wholeheartly invited to find and apply the adaption should the output come close to what you need.
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Programming

Find the minimum value of the column with respect to other column

Hi All, I would like get the minimum value in the certain column with respect to other column. For example, I have a text file like this. ATOM 1 QSS SPH S 0 -2.790 -1.180 -2.282 2.28 2.28 ATOM 1 QSS SPH S 1 -2.915 -1.024 -2.032 2.31 2.31 ATOM 1 ... (4 Replies)
Discussion started by: bala06
4 Replies

2. Shell Programming and Scripting

Get maximum per column from CSV file, based on date column

Hello everyone, I am using ksh on Solaris 10 and I'm gathering data in a CSV file that looks like this: 20170628-23:25:01,1,0,0,1,1,1,1,55,55,1 20170628-23:30:01,1,0,0,1,1,1,1,56,56,1 20170628-23:35:00,1,0,0,1,1,2,1,57,57,2 20170628-23:40:00,1,0,0,1,1,1,1,58,58,2... (6 Replies)
Discussion started by: ejianu
6 Replies

3. Shell Programming and Scripting

awk to select lines with maximum value of each record based on column value

Hello, I want to get the maximum value of each record separated by empty line based on the 3rd column of each row within each record? Input: A1 chr5D 634 7 82 707 A2 chr5D 637 6 82 713 A3 chr5D 637 5 82 713 A4 chr5D 626 1 82 704... (4 Replies)
Discussion started by: yifangt
4 Replies

4. Shell Programming and Scripting

Find minimum and maximum values based on column with associative array

Hello, I need to find out the minimum and maximum values based on specific column, and then print out the entire row with the max value. Infile.txt: scf6 290173 290416 . + X_047241 T_00113118-1 scf6 290491 290957 . + X_047241 T_00113118-2 scf6 290898 290957 . + X_047241 T_00113119-3 scf6... (2 Replies)
Discussion started by: yifangt
2 Replies

5. UNIX for Dummies Questions & Answers

Using awk to find and use the maximum value in column of data

Dear Unix Gurus, I have a text file with multiple columns, for example, see sample.txt below 0 1 301 1 4 250 2 6 140 3 2 610 7 1 180I want to find the maximum in, say, column 3, normalise all the values to this maximum value (to 4 decimal places) and spit everything into a new... (2 Replies)
Discussion started by: tintin72
2 Replies

6. Shell Programming and Scripting

Extract minimum/maximum using awk

From the below table I want to print highest value and lowest value using awk script. aaa 55 66 96 77 ggg 22 96 77 23 ddd 74 58 18 3 kkk 45 89 47 92 zzz 34 58 89 92 Thanks, Green edit by bakunin: it sure is not news to you that you should use CODE-tags, no? And that we do not want such... (3 Replies)
Discussion started by: gwgreen1
3 Replies

7. Homework & Coursework Questions

Find the Maximum value and average of a column

Use and complete the template provided. The entire template must be completed. If you don't, your post may be deleted! 1. The problem statement, all variables and given/known data: I am trying to complete a script which will allow me to find: a) reads a value from the keyboard. (ask the... (4 Replies)
Discussion started by: dstewie
4 Replies

8. UNIX for Dummies Questions & Answers

[Solved] Using awk to obtain minimum of each column (ignoring zeros)

Hi, I have a wide and long dataset which looks as follows: 0 3 4 2 3 0 2 2 ... 3 2 4 0 2 2 2 3 ... 0 3 4 2 0 4 4 4 ... 3 0 4 2 2 4 2 4 ... .... I would like to obtain the minimum of each column (ignoring zero values) so the output would look like: 3 2 4 2 2 2 2 2 I have the... (3 Replies)
Discussion started by: kasan0
3 Replies

9. Shell Programming and Scripting

for each different entry in column 1 extract maximum values from column 2 in unix/awk

Hello, I have 2 columns (1st column has multiple entries but the corresponding values in the column 2 may be the same or different.) however I want to extract unique values for each entry in column 1 by assigning the max value from column 2 SDF4 -0.211654 SDF4 0.978068 ... (1 Reply)
Discussion started by: Diya123
1 Replies

10. Shell Programming and Scripting

find expression with awk in only one column, and if it fits, print whole column

Hi. How do I find an expression with awk in only one column, and if it fits, then print that whole column. 1 apple oranges 2 bannanas pears 3 cats dogs 4 hesaid shesaid echo "which number:" read NUMBER (user inputs number 2 for this example) awk " /$NUMBER/ {field to search is field... (2 Replies)
Discussion started by: glev2005
2 Replies
Login or Register to Ask a Question

LEARN ABOUT CENTOS

column

COLUMN(1)							   User Commands							 COLUMN(1)

NAME

       column - columnate lists

SYNOPSIS

       column [options] file...

DESCRIPTION

       The column utility formats its input into multiple columns.  Rows are filled before columns.  Input is taken from file or, by default, from
       standard input.	Empty lines are ignored.

OPTIONS

       -c, --columns width
	      Output is formatted to a width specified as number of characters.

       -t, --table
	      Determine the number of columns the input contains and create a table.  Columns are delimited with whitespace, by default,  or  with
	      the characters supplied using the separator. Table output is useful for pretty-printing.

       -s, --separator separators
	      Specify possible table delimiters (default is whitespace).

       -o, --output-separator separators
	      Specify table output delimiter (default is two whitespaces).

       -x, --fillrows
	      Fill columns before filling rows.

       -h, --help
	      Print help and exit.

ENVIRONMENT

       The environment variable COLUMNS is used to determine the size of the screen if no other information is available.

EXAMPLES

       sed 's/#.*//' /etc/fstab | column -t

BUGS

       The util-linux version 2.23 changed -s option to be non-greedy, for example:

       $ printf "a:b:c
1::3
" | column  -t -s ':'

       old output:
       a  b  c
       1  3

       new output (since util-linux 2.23)
       a  b  c
       1     3

SEE ALSO

       colrm(1), ls(1), paste(1), sort(1)

HISTORY

       The column command appeared in 4.3BSD-Reno.

AVAILABILITY

       The column command is part of the util-linux package and is available from ftp://ftp.kernel.org/pub/linux/utils/util-linux/.

util-linux							   October 2010 							 COLUMN(1)