Replace Pioneer Home All Examples Free Download

428.Text file splitter -- How to join multiple text/csv files in horizontal direction?

User: editor -- 2010-02-22 << 427 429 >>

Hits: 531

Type: Text file splitter

Search all Text file splitter examples

Description:

How to join multiple text/csv files in horizontal direction?

Input Sample:

=== file1 ===
111
222
333
444
...
=== file2 ===
aaa
bbb
ccc
ddd
...
=== file3 ===
AAA
BBB
CCC
DDD
...

Output Sample:

111 aaa AAA
222 bbb BBB
333 ccc CCC
444 ddd DDD
....

Answer:

Hint: You need to Download and install "Replace Pioneer" on windows platform to finish following steps.

If you want to join some files manually:
1. ctrl-o open file1
2. select "File->Load->Column Append File to Page" menu, select the delimter(default is tab), click 'Next' and select file2
3. repeat step2 for other files file3, file4, ...
4. ctrl-s save the result to a new file.

If you want to join many files automatically, please check session "Join many files horizontally(Column append)" of following link: http://www.mind-pioneer.com/services/Text_file_splitter.html

Similar Examples:

How to remove the last 3 lines of multiple text files all at once? (58%)
How to convert multiple text files from DOS format to UNIX format? (57%)
How to convert multiple text files from UNIX format to DOS format? (57%)
How to replace strings in multiple files with a global increasing ID? (56%)
How to replace adjacent multiple spaces in a text files into one tab? (54%)
How to split a csv file into multiple files according to value of column B? (53%)
How to convert multiple text files to html files with self-defined format? (53%)
How to convert multiple files from one encoding to another with online tool? (53%)

Check Demo of Text file splitter

Keywords:

horizontal hori join multiple column append repeat text file splitter splitter append file append automatically horizontal join of files horizontal file append join multiple files join files append files file append join file open multiple files