Replace Pioneer Home   All Examples   Free Download

 New request --free  RSS: Replace Pioneer Examples

537.Advanced search and replace -- How to join hundreds of columns in different files into one csv file?

User: editor -- 2010-06-16          << 536  538 >>
Hits: 3429
Type: Advanced search and replace   
Search all Advanced search and replace examples
Description:
How to join hundreds of columns in different files into one csv file?
Input Sample:
file1: 
a1 
a2 
a3 
.. 
file2: 
b1 
b2 
b3 
... 
file3: 
c1 
c2 
c3 
... 
file4: 
...
Output Sample:
output.csv 
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. ctrl-h open "Replace" dialog 
(1) set the write mode ">" to ">>> Column Append" between the "Out page" and "Output File" entry. 
(2) click "Settings" page: 
set "Word Delimiter-Output Delimiter to "Other", and enter a comma "," at the following entry. 
2. click "Batch ..." to open "Batch Runner" window 
(1) drag all files of file1.txt, file2.txt, ... from "Windows File Browser" to the "Batch Runner" window 
(2) check "set output filename" option, and change the following entry to "output.txt" 
(3) click "Batch Replace", all files will be joined together to output.txt, with comma as separater.

Screenshot 1:  Replace_Settings_Window


Similar Examples:
How to merge two or more csv files with different columns into one file? (63%)
How to put a list of names in different rows into one line? (62%)
How to merge many files into one file? (60%)
How to extract tables from many html files into one csv file? (59%)
How to join every 3 lines into 3 columns of csv file? (57%)
How to join every n lines into 1 line in a text file? (57%)
How to rename different file name suffix to the same? (56%)
How to replace certain column from different files?  (56%)

Check Demo of Advanced search and replace
Keywords:
mode  column append  together  pages  write  separate  append  ppen  delimiter  columns  join hundreds csv files  join csv files columns  join files columns  different columns  join filename  filename from csv  join csv  file and replace all in files with csv