Replace Pioneer Home All Examples Free Download

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: 3307

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 replace different words conditionally? (59%)
How to calculate the sum of the numbers in the same column? (58%)

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