Home>
a # num b c d
0 131 3442 43465436
1000 331 42674 0.974549
2000 42424 59879 1358400
3000 242428 46846 54054540
・
・
・
・
・
There is a text file like the one above.
Of these, I want to find the maximum value in the third column from the left, and the number in the first column from the left in the same row.
In this case, I want to get the number 2000, because I want to move a file like aaa_2000.sh.
cat file.txt | awk '{if (m<$3) m = $3} END {print m}'
c
Now such an answer is returned.
How can I rewrite it? Also, how can I copy a file that contains the numbers in column a when I know the maximum value from a location?
Please tell me. Thank you.
-
Answer # 1
-
Answer # 2
cat file.txt | awk 'NR>1 {if (m<$3) {m = $3;a = $1;}} END {print a } '
It was made with. Thank you very much.
Related articles
- [excel] i want to get the maximum value of a character string
- python - i want to pull the value of a hard-coded model from another model
- i want to transfer a value from another book using vba identifier
- python - to get the maximum value of an array whose elements are of type dict
- swift - i get an error when i pass a value to another view controller
- ruby on rails - how to set the maximum value + 1 in a specific column when generating a model with rails
- javascript - i want to know why you cannot pass the value of an argument to another function
- javascript - how to change value of another key with specific value in associative array
- about finding the maximum value using the java extended for statement
- i want to reference a value from another book with vba and replace a specific string
- python - i want to extract the maximum value each time in a list that counts consecutive values
- vba i want to enter in the cell of another book depending on the value of the cell of a specific book
- c - you get the wrong maximum value from an array element
- c - program that outputs the maximum value from the four
- linux - scripts running on my mac don't work on another mac
- python how can i find the maximum value from a set of numbers without using max? as an example, please use (60, 30, 40)
- find exact value in csv file using linux command
- group by - [sql] i want to extract the rows with the maximum value collectively for each specific column
- javascript - i want to get the value of and pass it by return to another function
- vba - fetch the row with the maximum value among multiple conditions
Related questions
- i want to get the work log including the execution command on linux
- i don't understand how linux/etc/crontab works
- linux - log file is not created due to periodic execution
- linux 32bit application cannot be installed
- linux - git clone connection times out
- linux - about the behavior of log rotation
- linux - i want to keep files for one week with log rotate settings
- linux - log rotate does not work
- linux - remove ubuntu from dual boot → don't boot
- linux - i want to execute commands in text in parallel
cat file.txt | awk '{if (m<$3) {m = $3;a = $1;}} END {print a}'
What about?