how to read data from multiple files and save in single file

i have 5000 text files each file having(1*50). i need to read those all files from top to bottom order and want to save them in single text file.which should contain all data from those 5000 files(5000*50).

Answer 1

[Jan]

This concatenates the files directly without a conversion to doubles and back again:

pathName = 'C:\Temp';
fileList = dir(fullfile(pathName, '*.txt'));
out      = fopen(fullfile(pathName, 'Joined.txt'), 'w');
for k = 1:numel(fileList)
  s = fileread(fullfile(pathName, fileList(k).name));
  fwrite(out, s, 'char');
end
fclose(out);

Perhaps it is needed to care about a trailing line break:

if s(end) =~ char(10) && s(end-1:end) ~= char([13, 10])
  fwrite(out, char(10), 'char');  % Or char([13,10]) ?
end

[sandy]

since the output of above is a string. but output of the file have to delimited,because input text files contains names and numbers.whether it can b done with dlmwrite function ?

[sandy]

thanks...its working...if i need excel output file. why cant we use xlswrite to save output from second row,is it possible to modify in above using xlswrite?

[julio martinez]

How could concatenate the files skipping the header row?

[Angana Borah]

Thank you so much. can anyone please tell me how I can understand each line in the code? what 'w'w does and what is the purpose of the for loop logic?

Answer 2

[David Sanchez]

my_files = dir('*.txt');
N_files = numel( my_files );
A = zeros( numel(my_files),50 ); % initialize matrix to hold data
for k = 1:N_files
    file2read = my_files(k).name;
    fid = fopen(file2read);
    A(k,:) = fscanf(fid, '%g', [1 inf]); % data from file
    fclose(fid);
end
% write data to new file
fid = fopen('new_file.txt', 'w');
fprintf(fid, '%g %g\n', A);
fclose(fid);

[Jan]

The conversion from text to numbers and back again requires a lot of time.

Answer 3

[KRUNAL]

I am trying to do the same as sandy wants to. I am trying to read excel files from two different folders and output it to an excel file present in third folder. Can anyone suggest how can it be done?

P.S : I am reading only a column of data from the two files and not the entire file

Answer 4

[hemant vyas]

sir can we read and write in a video file simultaneously if I am recording video by webcam a saving it in .m file than in the same code i want to process it in matlab2013a