MATLAB Answers

Merge files with the same prefix.

5 views (last 30 days)
Ivan Mich
Ivan Mich on 24 Jun 2020
Commented: Rik on 24 Jun 2020
I have multiple .txt files. From these files have the same three letters in their name. I want to create a new file that will contain the data of all the files that have the first three letters in their name (e.g. "ABC****P.txt, ABC****T.txt, BCA****P.txt, BCA****T.txt". I want to megre in one file the first two .txt and one file the last two .txt files)
could you help me please?

  0 Comments

Sign in to comment.

Accepted Answer

Stephen Cobeldick
Stephen Cobeldick on 24 Jun 2020
Edited: Stephen Cobeldick on 24 Jun 2020
This should get you started (untested, but gives an outline of how you could do this):
D = 'path to the folder where the files are saved';
S = dir(fullfile(D,'*.txt'));
C = {S.name};
T = regexp(C,'^.{3}','once','match');
U = unique(upper(T));
for k1 = 1:numel(U)
X = find(strncmpi(C,U{k1},3));
N = numel(X);
A = cell(1,N);
for k2 = 1:N
F = fullfile(D,C{X(k2)});
A{k2} = ...whatever file importing that suits your file format.
end
M = vertcat(A{:});
F = sprintf('%s merged.txt',U{k1});
... save matrix M with filename F using whatever file exporting that suits your data
end

  9 Comments

Show 6 older comments
Rik
Rik on 24 Jun 2020
How do you want to merge them? Do files with the same starting letters have the same date? Should the header be repeated? What does 'merging' mean for your specific data format?
Ivan Mich
Ivan Mich on 24 Jun 2020
I would like to merge them horizontally (I mean I want to have 4 columns, which the firts two are from the one file and the last two are from the second file). I do not want to have the headers.
Rik
Rik on 24 Jun 2020
Have you read the documentation for every function you didn't understand in the answer?
Let me give you a short-cut: read the documentation for sprintf.

Sign in to comment.

More Answers (0)


Translated by