Replace Pioneer Home   All Examples   Free Download

 New request --free  RSS: Replace Pioneer Examples

1349.Advanced search and replace -- How to copy the 2nd column to 4th column if 4th column is empty?

User: Dilip -- 2016-03-01          << 1348  1350 >>
Hits: 2543
Type: Advanced search and replace   
Search all Advanced search and replace examples
Description:
In a tab  separated txt or CSV, copy contents of 2nd column to 4th column if  
only if 4th column is empty
Input Sample:
1 Dex somentry  
2 Fill somntry entry
Output Sample:
1 Dex somentry Dex  
2 Fill somntry entry
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' dialgoue 
* set 'replace unit' to 'Line' 
* set 'replace with pattern' to: 
 
3. click 'replace', done

Screenshot 1:  Replace_Window


Similar Examples:
How to replace the 4th column if the 5th column is 0? (69%)
How to copy column A to column D if column D is blank(absent) in a csv file? (66%)
How to delete the 4th column from text files with 8 columns? (57%)
How to extract the 7th column from text files with 8 columns? (53%)
How to remove paragraphs with different 4th column and last column in second line? (52%)
How to exchange column 2 and column 3 in multiple csv files? (52%)
How to multiply the first column with the rest of columns in one file? (51%)
How to batch append the columns of file A and B if third  columns are identical? (50%)

Check Demo of Advanced search and replace
Keywords:
empty  4th  contents  2nd  separate  copy  csv  content  para  tab  copy column  search and copy and replace file  copy text  only search text  copy file  copy a file  file copy  match column