Replace Pioneer Home   All Examples   Free Download

 New request --free  RSS: Replace Pioneer Examples

1090.Advanced search and replace -- How to merge two columns of a CSV file?

User: Fiona -- 2013-06-23          << 1089  1091 >>
Hits: 1943
Type: Advanced search and replace   
Search all Advanced search and replace examples
Description:
A CSV file has 3 columns, a, b and c. How to merge two columns into one in this CSV file, the main separator between columns is ";" with piping as separator between the columns b and c
Input Sample:
column a;column b;column c
Output Sample:
column a;column b|c
Answer:
Hint: You need to Download and install "Replace Pioneer" on windows platform to finish following steps.
1. ctrl-o open csv file
2. ctrl-h open 'replace' dialogue
* set 'replace unit' to 'Chars'
* set 'replace scope' to 'Line'
* set 'unit number filter' to: 
* set 'search for pattern' to 
* set 'replace with pattern' to 
3. click 'replace', done.

For multiple files, click "batch..." button in step 3, and drag multiple csv files to "batch runner" window, and click "batch replace", done.

Screenshot 1:  Replace_Window


Similar Examples:
How to delete last column in a csv file? (70%)
How to join every 3 lines into 3 columns of csv file? (62%)
How to merge the data of second column base on value of first column? (60%)
How to reverse the order of the first column in text file? (59%)
How to merge more columns into one column in multiple csv files? (59%)
How to merge adjacent lines having same value in column one in CSV files? (59%)
How to delete the second column in multiple text files? (58%)
How to extract all odd columns 1,3,5,... from a text file? (58%)

Check Demo of Advanced search and replace
Keywords:
how to merge two columns  merge two column  merge two  merge  merg  mer  csv files  two  unit number filter  columns  batch csv filter merge file  merge csv files into one with multiple columns  merge multiple columns in csv file  csv merge columns batch  merge two columns files batch  merge two csv files  batch file to merge columns  merge csv files columns