Replace Pioneer Home   All Examples   Free Download

 New request --free  RSS: Replace Pioneer Examples

1211.Advanced search and replace -- How to find maximum and minimum number out of specified column?

User: Verotiana -- 2014-07-02          << 1210  1212 >>
Hits: 981
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