Reading data from Character data

Hi,

I need to read a csv file from a directory. Name of the file is an output of a code which is written on a charecter or string data.

How can I write a code which reads the name of the file from character data and then find the file in the direcotory and load it.

let's say the charecter data name is 'MyFile' and name of the file that I need to read from the directory is 'File No.3'. The direcotry is a folder in one of my laptop drives. basically my code should be something like belwo but this is not working:

Data=readtable("G:\operations\'MyFile'");

Thanks for any assistance

Answer 1

[Walter Roberson]

projectdir = 'G:\operations';
MyFile = 'File No.3';

filename = fullfile(projectdir, MyFile);
Data = readtable(filename);

[Reza Tavakoli]

Thanks Walter. I think I need to rephrase my question. the file name is unknown. What we know is the file name is written on 'MyFile' charecter type.

My code should read the file name from 'MyFile' and then find it in the directory and load it.

[Walter Roberson]

What we know is the file name is written on 'MyFile' charecter type.

I do not know what you mean by that, unless you mean that the variable named MyFile contains the file name. And if that is what you mean, then that is what my sample code already takes care of.

Do I need to show more clearly that MyFile does not have to be a fixed constant?

projectdir = 'G:\operations';

MyFile = sprintf('File No.%d', randi(9));    %file name can be computed

filename = fullfile(projectdir, MyFile);
if ~exist(filename)
   error('Oh, darn, file "%s" does not exist', filename);
end

Oh, darn, file "G:\operations/File No.5" does not exist

Data = readtable(filename);

[Reza Tavakoli]

cheers Walter, I did a minor change to what you wrote and it is working now