file reading problem with switch

1 view (last 30 days)
Vasiliki Thomopoulou
Vasiliki Thomopoulou on 4 Jan 2021
Commented: Stephen23 on 4 Jan 2021
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
Stephen23 on 4 Jan 2021
Note that some of your switch cases include the period character, but some do not.

Sign in to comment.

Answers (1)

Cris LaPierre
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
Vasiliki Thomopoulou
Vasiliki Thomopoulou on 4 Jan 2021
I tried but this is the error that comes up when I try to use the fileparts function.
[filepath,name,ext] = fileparts(fullpathname);
Undefined function or variable 'fExt'.
Error in fileparts (line 2)
switch lower(fExt)
Stephen23
Stephen23 on 4 Jan 2021
[~,~,fExt] = fileparts(fullpathname);
% ^^^^^ use the correct variable name here

Sign in to comment.

Categories

Find more on Programming in Help Center and File Exchange

Products

Community Treasure Hunt

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

Start Hunting!