Replace Pioneer Home   All Examples   Free Download

 New request --free  RSS: Replace Pioneer Examples

1097.Advanced search and replace -- How to replace the words with its nearest different words in the same column?

User: shan feng -- 2013-07-08          << 1096  1098 >>
Hits: 1213
Type: Advanced search and replace   
Search all Advanced search and replace examples
Description:
How to replace the words with its nearest different words in the same column?
Input Sample:
1 2 3 4 5 6 
a 1 2 5 6 7 
a 2 3 5 6 7
a 3 4 5 6 6
Output Sample:
1 2 3 4 5 6 
1 1 2 5 6 7 
1 2 3 5 6 7
1 3 4 5 6 6
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 unit' to 'Line'
* set 'replace with pattern' to:

* click 'advanced' tab, set 'run following for each matched unit' to:

3. click 'replace', done.

Note: you can change 'a' to other strings as required.

Screenshot 1:  Replace_Window


Screenshot 2:  Replace_Advanced_Window


Similar Examples:
How to replace the space with its nearest different words in the same column? (92%)
How to replace a words with the previous word in the same column? (77%)
How to replace specific words with its previous words in the same column? (76%)
How to replace the all word "test" with the first word in same line? (69%)
How to replace the same words in text files with different strings? (61%)
How to replace a word with a list of words repeatly in a text file? (60%)
How to calculate the sum of the numbers in the same column? (58%)
How to replace a list of words with one single word? (57%)

Check Demo of Advanced search and replace
Keywords:
near  nearest  asp  different words  same column  define  fine  strings  else  same  replace same with different  replace different to same  replace strings  if else  replace with different  replace different  if eq  advanced change replace