|User: shanfeng -- 2013-12-29 << 1164 1166 >>|
|Type: Advanced search and replace|
|Search all Advanced search and replace examples|
|How to replace words with speicial words?If the fifth column is 0,then replace the '9999' in th forth column with '0'.|
|a b c 9999 0 |
a b c 20 1
c d f 9999 0
|a b c 0 0 |
a b c 20 1
c d f 0 0
|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 'Word'
* set 'replace scope' to 'Line'
* set 'unit number filter' to:
* set 'replace with pattern' to the replacement text:
* set 'If' to:
3. click 'replace', done.
4. ctrl-s save to file.
Screenshot 1: Replace_Window
|How to copy the 2nd column to 4th column if 4th column is empty? (71%)|
How to delete the 4th column from text files with 8 columns? (70%)
How to extract the 7th column from text files with 8 columns? (67%)
How to replace the certain column with specified words? (61%)
How to multiply the first column with the rest of columns in one file? (60%)
How to merge other columns one by one into the first column? (59%)
How to replace the second column in a tab seperated file? (57%)
How to exchange column 2 and column 3 in multiple csv files? (57%)
Check Demo of Advanced search and replace
|5th 4th replacement next unit number filter number filter replace scope scope filter unit number text replacement search next scope filter words with number if then replace number column text pattern filter filter number|