MATLAB: How to concatenate horizontally multiple text files in a folder to have all data in one txt file

concatenate txt files

Have 25 files in a folder each having around 1,000,000 rows. And want to have one text file having all the data i.e. 25,000,000 rows.

Best Answer

The old fashion DOS command copy could do the task. You can also call it in MATLAB using system(). The trick is the "+" symbol.

system('copy test1.txt+test2.txt+test3.txt test.txt')

As long as there is a carriage return at the end of each text file, the concatenate looks right.

Related Solutions

MATLAB: I want to delete all the headerlines and delimiters from the data in the below attached text file

The best solution is probably to read your entire file as text, then remove the header lines, then parse them with textscan.

MATLAB: Exporting data from for loop into text file

"gives me all the data in a row:" This script produces two columns

%%



BOLD = reshape( (1:6), [],1 );
x = (1:size(BOLD,1))./1.16E6;
y = BOLD;
xy = [x(:),y(:)];
%%
dlmwrite('d:\tmp\YourOutputFile.txt', xy, 'delimiter', ',');
%%
type('d:\tmp\YourOutputFile.txt')

outputs

8.6207e-07,1
1.7241e-06,2
2.5862e-06,3
3.4483e-06,4
4.3103e-06,5
5.1724e-06,6

"all the data sets in separate files" You need a new filename for each iteration of the loop

In response to comment:

"the data from the for loop into a text file"

To append new data to an existing file use

dlmwrite(filename,M,'-append')

See dlmwrite, (Not recommended) Write matrix to ASCII-delimited file. (If the file doesn't exist a new file is created.)

"all the data sets in separate files", "have a new filename for each iteration?"

My way

%%
for jj = 1 : 3
    name = sprintf( 'YourOutputFile_%04d.txt', jj );
    ffs  = fullfile( 'd:\tmp', name );
    dlmwrite( ffs, xy, 'delimiter',',' );
end

outputs

name =
    'YourOutputFile_0001.txt'
name =
    'YourOutputFile_0002.txt'
name =
    'YourOutputFile_0003.txt'

and there are others

Best Answer

Related Solutions

MATLAB: I want to delete all the headerlines and delimiters from the data in the below attached text file

MATLAB: Exporting data from for loop into text file

Related Question