How to merge specific rows from multiple CSV files in a single csv file in MATLAB (code)?
Show older comments
I have a main folder which has 8 subfolders. Each subfolder has multiple CSV files and I need to combine all csv files into a single csv file using MATLAB code. Can anyone guide me how to start?
Answers (1)
chrisw23
on 6 Sep 2022
0 votes
a possible start (find all csv files over subDirs)
import System.IO.*
filesFound = "";
searchOption = System.IO.SearchOption.AllDirectories;
searchDir = "C:\Temp\MainCsv";
pattern = "*.csv";
dirInfo = DirectoryInfo(searchDir);
dirInfo.EnumerateFiles(pattern, searchOption);
fsEnumerableIterator = Directory.EnumerateFiles(searchDir, pattern, searchOption);
enFilesFound = fsEnumerableIterator.GetEnumerator;
fCount = 0;
while enFilesFound.MoveNext
fCount = fCount + 1;
filesFound(fCount) = string(enFilesFound.Current);
end
for csvFile = filesFound
csvFile % open File here
end
Categories
Find more on MATLAB in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!