Replace Pioneer Home   All Examples   Free Download

 New request --free  RSS: Replace Pioneer Examples

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

User: shanfeng -- 2015-02-04          << 1278  1280 >>
Hits: 1729
Type: Advanced search and replace   
Search all Advanced search and replace examples
How to replace the space with its nearest different words in the same column?
Input Sample:
1 2 2 3 
3 2 1 1 
4 2 3 1
Output Sample:
1 2 2 3 
2 2 2 3 
3 2 1 1 
4 2 3 1
Hint: You need to Download and install "Replace Pioneer" on windows platform to finish following steps.
1. ctrl-o open file 
2. ctrl-h open 'replace' dialoguereplace with pattern' 
* set 'replace unit' to 'Line 
* set 'replace with pattern' 
* click 'advanced' tab, set 'run following for each matched unit' to: 
3. click 'replace', done.

Screenshot 1:  Replace_Window

Screenshot 2:  Replace_Advanced_Window

Similar Examples:
How to replace the words with its nearest different words in the same column?
How to replace specific words with its previous words in the same column? (72%)
How to replace a words with the previous word in the same column? (71%)
How to replace the all word "test" with the first word in same line? (67%)
How to replace different words conditionally? (60%)
How to replace the same words in text files with different strings? (60%)
How to calculate the average of the numbers in the same column? (59%)
How to calculate the sum of the numbers in the same column? (59%)

Check Demo of Advanced search and replace
different words  same column  same  space  different  join  run following for each matched unit  tab  words  matched unit  replace space with tab  replace tab with space  replace same with different  replace different to same  column join  join column  join file column  replace column with different file