file reading problem with switch
2 views (last 30 days)
Show older comments
Hey guys, I am posting this here hopping someone can help. I run the code and the thing is that even though I select an csv file the function doesnt read it, and it goes straight to displaying the error message. Does anyone have an idea why this happens? Thanks a lot in advance!!
function a=diavaseto
[fn, pn] = uigetfile({'*.csv'; '*.ods'; '*.xlsx'}, 'Epilogh arxeioy dedomenwn');
fullpathname=fullfile(pn, fn);
extIndices= strfind('.',fn);
fext = fn(max(extIndices):length(fn));
switch lower(fext)
case '.csv'
a=readtable(fullpathname);
% A csv file
case '.ods'
a=xlsread(fullpathname);
% An ods file
case 'xlsx'
a=xlsread(fullpathname);
%An xlsx file
otherwise
error('Unexpected file extension: %s', fext);
end
1 Comment
Stephen23
on 4 Jan 2021
Note that some of your switch cases include the period character, but some do not.
Answers (1)
Cris LaPierre
on 4 Jan 2021
Edited: Cris LaPierre
on 4 Jan 2021
My suggestion is to use fileparts rather than trying to come up with your own way to extract the file extension.
If you want to use strfind, make sure you put the inputs in the correct order. You have them reversed. It should be
extIndices= strfind(fn,'.');
2 Comments
Stephen23
on 4 Jan 2021
[~,~,fExt] = fileparts(fullpathname);
% ^^^^^ use the correct variable name here
See Also
Products
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!