Replace Pioneer Home   All Examples   Free Download

 New request --free  RSS: Replace Pioneer Examples

1195.Text merge -- How to merge different CSV with partially different columns into one?

User: Vitalie -- 2014-04-18          << 1194  1196 >>
Hits: 1494
Type: Text merge   
Search all Text merge examples
Description:
Hello, your Program is very good, but I can`t find a solution for me.
I work with databases and often need to join different CSV into one.
Need to have as result the sync between the columns.
Input Sample:
FILE1.csv
Code,Description,Tax,Price
1,Table,10,150

FILE2.csv
Description,Price,Tax
Book,20

FILE3.csv
Description,ExtPrice
Banana,7
Output Sample:
Code,Description,Tax,Price,ExtPrice
1,Table,10,150
,Book,,20
,Banana,,,7
Answer:
Hint: You need to Download and install "Replace Pioneer" on windows platform to finish following steps.
1. make sure the editor page p0 is the active window(default)
2. ctrl-h open 'replace' window
* set 'replace unit' to 'Line'
* set 'replace with pattern' to:

* click 'advanced' tab, set 'run following for each matched unit' to:

3. click 'Batch...' button
4. drag multiple csv files to 'Batch Runner' window
5. set 'set output filename' entry to:
6. click 'batch replace', done.

Screenshot 1:  Replace_Window


Screenshot 2:  Replace_Advanced_Window


Similar Examples:
How to merge two or more csv files with different columns into one file? (67%)
How to extract different part from adjacent lines? (59%)
How to replace different lines with different rule? (59%)
How to merge files in all folders into one folder? (58%)
How to add in different sentences after the different lines? (56%)
How to replace one content of same files with different contents ? (54%)
How to remove paragraphs with different 4th column and last column in second line? (53%)
How to merge two text file base on the value of first column and do sort? (53%)

Check Demo of Text merge
Keywords:
editor  database  good  different columns  grep  text merge  merge  merg  mer  csv files  batch find split for  merge csv files with different columns  merge csv files into one different columns  merge csv files different columns  merge csv with different columns  split csv columns into multiple files  editor replace between  merge csv different columns