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: 2334
Type: Advanced search and replace   
Search all Advanced search and replace examples
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
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
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