Replace Pioneer Home   All Examples   Free Download

 New request --free  RSS: Replace Pioneer Examples

118.Advanced search and replace -- How to find all elements appearing in second column and not appearing in first column?

User: editor -- 2008-05-16          << 117  119 >>
Hits: 413
Type: Advanced search and replace   
Search all Advanced search and replace examples
Description:
How to find all elements appearing in second column ant not appearing in first column?
Input Sample:
1 4
2 5
3 6
4 7
5 8
Output Sample:
6
7
8
Answer:
Hint: You need to Download and install "Replace Pioneer" on windows platform to finish following steps.
1. ctrl-o open source file
2. ctrl-h open 'Replace' dialog:
in 'Replace' page:
* set 'Replace Unit' to 'Line'
* set 'Search for pattern':

in 'Advanced' page:
* set 'run following at the begin...':

* set 'run following at each...':

* set 'insert end text':

3. click 'Replace', ok!
Download Script:  scripts/118.rst.zip

Screenshot 1:  Replace_Window


Screenshot 2:  Replace_Advanced_Window


Similar Examples:
How to summrize the number of second column grouping by the first column? (63%)
How to merge the data of second column base on value of first column? (63%)
How to append the second columns of file A and B if first columns are identical? (56%)
How to delete the second column in multiple text files? (53%)
How to delete the 4th column from text files with 8 columns? (53%)
How to delete all text after the second comma in each line? (53%)
How to merge other columns' data base on the value of the first column? (52%)
How to extract the second column from a database text file? (48%)

Check Demo of Advanced search and replace
Keywords:
appearing  insert end text  insert end  second  find  values  insert  value  get  first  insert column  find and replace  find replace  find and  search and replace first  replace the first  replace first  the first