Replace Pioneer Home   All Examples   Free Download

 New request --free  RSS: Replace Pioneer Examples

1165.Advanced search and replace -- How to replace the 4th column if the 5th column is 0?

User: shanfeng -- 2013-12-29          << 1164  1166 >>
Hits: 1093
Type: Advanced search and replace   
Search all Advanced search and replace examples
Description:
How to replace words with speicial words?If the fifth column is 0,then replace the '9999' in th forth column with '0'.
Input Sample:
a b c 9999 0
a b c 20   1
c d f 9999 0
Output Sample:
a b c 0 0
a b c 20   1
c d f 0 0
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 '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


Similar Examples:
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 replace the second column in a tab seperated file? (57%)
How to exchange column 2 and column 3 in multiple csv files? (57%)
How to remove duplicate column in each line? (56%)

Check Demo of Advanced search and replace
Keywords:
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