User: Verotiana -- 2014-07-02 << 1210 1212 >> |
Hits: 2784 |
Type: Advanced search and replace |
Search all Advanced search and replace examples |
Description: |
1. How to find the maximum number out of the 4th column? 2. How to find the minimum number out of the 4th column? |
Input Sample: |
Node 1 received 15 packets Node 2 received 56 packets Node 3 received 23 packets Node 4 received 80 packets Node 5 received 5 packets Node 6 received 71 packets |
Output Sample: |
1. 80 2. 5 |
Answer: |
Hint: You need to Download and install "Replace Pioneer" on windows platform to finish following steps. |
1. ctrl-o open text file 2. ctrl-h open 'replace' dialogue * set 'replace with pattern' to: 3. click 'replace', done. Note: function transpose will exchange column and row, so we just need to find out max/min of the 4th line of the transposed text. |
Screenshot 1: Replace_Window |
Similar Examples: |
How to add some number to the specific column in csv file? (61%) How to find numbers in specified location and sort them? (59%) How to decorate each of marching number with specified format? (58%) How to filter out the duplicate number after the specified keywords? (58%) How to calculate the sum of the numbers in the same column? (57%) How to count the number of specified part in each line? (56%) How to batch sort csv files by the order of value in the specified column? (55%) How to find missing numbers from a list of numbers? (54%) |
Check Demo of Advanced search and replace |
Keywords: |
exchange column find max minimum exchange 4th transpose maximum trans max find lines max split text file exchange line row find out the max replace column exchange exchange row column exchange lines find and replace maximum line exchange |