How to read all text files in a folder with unknown number of files?
4 次查看(过去 30 天)
显示 更早的评论
I have an unknown number of text files that need to be read and put into tables, and then all of those tables need to be combined to 1 table and plotted in a GUI created in Matlab's GUIDE. I have attached two such text files.
I previously found out that in order to collect the data from each of these files, I would have to run the following code.
Day1 = 'SI010218.log';
opts = detectImportOptions(Day1);
opts = setvartype(opts,1,'datetime');
opts = setvaropts(opts,1,'InputFormat','dd.MM.uuuu HH:mm:ss');
table1 = readtable(Day1,opts);
Which would save that text file's data into a table named table1. I think I should add this to the
_OpeningFcn(
in the GUIDE.
Thing is, how do I let the code scan through an entire folder and read all the tables in it, and combine it all into one table?
0 个评论
采纳的回答
Benjamin Kraus
2018-7-26
编辑:Benjamin Kraus
2018-7-27
You can use the dir command to generate a list of files that match a specific pattern. Once you've done that, can you loop over the list of files and run the code block you pasted, except with the Day1 variable replaced by the file name. Then you need to concatenate the tables.
It might look something like this:
f = dir('*.log');
alldatatable = [];
for ii = 1:numel(f)
DayFile = f(ii).name;
opts = detectImportOptions(DayFile);
opts = setvartype(opts,1,'datetime');
opts = setvaropts(opts,1,'InputFormat','dd.MM.uuuu HH:mm:ss');
table1 = readtable(DayFile,opts);
if isempty(alldatatable)
alldatatable = table1;
else
alldatatable = [alldatatable; table1];
end
end
You may need to modify how the tables are joined, and you can probably consolidate some of the other code (such as detectImportOptions) if the files are all the same format, but this is the general approach to consider.
2 个评论
更多回答(0 个)
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Environment and Settings 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!