How to access .csv files in a .tar.gz file?

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

Thanks for your feedback. I've checked these links out but couldn't help to solve my problem. Thanks though!

Sign in to comment.

Answers (1)

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.

Categories

Asked:

on 8 Jul 2020

Commented:

on 17 Jul 2020

Community Treasure Hunt

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

Start Hunting!