How to access .csv files in a .tar.gz file?
10 views (last 30 days)
Show older comments
Greeting!
I have a bunch of *.tar.gz files, say 100 (example1-example 100). In each of them I have more than 1000 .csv file that I would like to extract data from these .csv files.
I am using following code to access the .csv files.
url = 'C:\Users\....\Test\example1.tar.gz';
files = gunzip(url, 'example1')
what I get is
files = 1*1 cell array
{'example1\example1.tar'}
However it doesn't make any "example1.tar" in the "C:\Users\....\Test\" folder. Then I'm using the following line to get the . cvs files
filenames = untar('example1/example.tar','example1')
and I get
filenames = 1*953 cell array
{example1\example_1\} {example1\example_1\config1\} {example1\example_1\config1\imag.csv} {example1\example_1\config1\real.csv}.....
{example1\example_1\config50\} {example1\example_1\config50\imag.csv} {example1\example_1\config50\real.csv} ......
I would like to have access the data on imag.csv and real.csv for all configs. How should I do that?
Should I use something like
load(fullfile('..', 'example1', 'example_1', 'config1', 'imag.csv'))
Thank you for any help you can provide, I'm really stuck on this.
2 Comments
Walter Roberson
on 16 Jul 2020
I do not know if the following will work for .gz but you could try it: https://www.mathworks.com/matlabcentral/fileexchange/77257-zipfile
Answers (1)
Aditya Patil
on 16 Jul 2020
You can call a function recursively on the folder, and process the files which match your requirement. See https://www.mathworks.com/matlabcentral/answers/92761-how-can-i-recursively-process-files-in-subdirectories-using-matlab for detailed explanation.
See Also
Categories
Find more on Get Started with 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!