Replace Pioneer Home   All Examples   Free Download

 New request --free  RSS: Replace Pioneer Examples

899.Text merge -- How to merge more columns into one column in multiple csv files?

User: editor -- 2011-12-26          << 898  900 >>
Hits: 2571
Type: Text merge   
Search all Text merge examples
Description:
How to merge two or more columns into one column in multiple csv files? How can I merge column B and column C of multiple csv files?
Input Sample:
A1,B1,C1,D1
A2,B2,C2,D2
A3,B3,C3,D3
Output Sample:
A1,B1-C1,D1
A2,B2-C2,D2
A3,B3-C3,D3
Answer:
Hint: You need to Download and install "Replace Pioneer" on windows platform to finish following steps.
1. open "Tools->Batch Runner" window
2. drag multiple csv files from Windows File Browser to "Batch Runner" window
3. click "Fast Replace" button.
4. click "Add" to add new
* set "search" to:

* set "replace" to:

5. check option of "regular exp" and uncheck option of "cross line"
6. click "Start", done.

Screenshot 1:  Fast_Replace_Window


Similar Examples:
How to exchange column 2 and column 3 in multiple csv files? (79%)
How to add filename as a new column for multiple csv/txt files? (68%)
How to delete the second column in multiple text files? (67%)
How to set column N according to content of column A in csv file? (65%)
How to remove/delete first column for multiple files? (65%)
How to replace a word only one time in multiple text files? (63%)
How to extract and remove common lines from multiple files? (62%)
How to delete last column in a csv file? (61%)

Check Demo of Text merge
Keywords:
merge two  123  merge column  text merge  merge  merg  mer  csv files  two  columns  merge two csv files  merge two csv files column  merge csv files columns  merge csv columns  merge csv files  csv merge  merge csv  merge into multiple files