read multiple excel files with beginning part of file name being similar

3 Ansichten (letzte 30 Tage)
Ahisa
Ahisa am 6 Jul. 2021
Bearbeitet: Ahisa am 7 Jul. 2021
I have 4 excel files that all start with THA and there are 4 types(THA1, THA2, THA3 & THA4) the full file name for all 4 are like this: THA1_343fdf and I want to extract all four file names by filtering it with THA if possible. I can extract the data easily but struggling with extracting all 4 file names.
  13 Kommentare
dpb
dpb am 7 Jul. 2021
tData=readtable(fullfile(d(i).folder,"d(i)name"))
It's doing exactly what you told it to do -- it's looking for the literal string "d(i)name" as the file name, not the next file in the dir() struct d() array that you returned.
Look at the documentation for dir and the examples there and look at what the call returns in the variable d struct at the command line to understand what you're doing here.
The code is, as I wrote initially,
tData=readtable(fullfile(d(i).folder,d(i)name));
Remove the quotes; they don't belong...
Ahisa
Ahisa am 7 Jul. 2021
Bearbeitet: Ahisa am 7 Jul. 2021
never mind, this is how it should look, correct?
d=dir(fullfile('C:\Users\R101951\Desktop\RB\New folder','THA*.*'));
for i=1:numel(d)
tData=readtable(fullfile(d(i).folder,d(i).name));
end

Melden Sie sich an, um zu kommentieren.

Antworten (1)

Jonas
Jonas am 7 Jul. 2021
Bearbeitet: Jonas am 7 Jul. 2021
more something like that?
for type=1:4
basepath='C:\Users\R101951\Desktop\RB\New folder\';
currFile=dir([basepath 'THA' num2str(type) '*.xls']).name;
data=readtable(currFile,.....);
end
the ' * ' is a wildcard for the '_343fdf' part which I assumed is not the same for every file you are interested in
  1 Kommentar
Ahisa
Ahisa am 7 Jul. 2021
Error: Invalid expression. When calling a function or indexing a variable, use parentheses. Otherwise, check for
mismatched delimiters.
thanks for that, i tried yours b
ut got this error message

Melden Sie sich an, um zu kommentieren.

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by