Textscan returns empty array

5 次查看(过去 30 天)
I have difficulty with parsing a file using text scan. The file is as follows:
Statistics;Object ID;Object Class;Area (µm²);Perimeter (µm);Mean (Radius) (µm);Mean (Gray Intensity Value);Mean (Color Intensity Value);Shape Factor;Center of Gravity X (µm);Center of Gravity Y (µm);Equivalent Circle Diameter (µm);Value (Z) (nm)
;1;2;8.77;24.45;0.62;112.42;;0.18;1912.41;313.47;3.34;15271210.00
;2;2;5.54;14.94;0.50;106.92;;0.31;1846.18;25.47;2.66;15271210.00
The code I write is :
[filename,folder]=uigetfile('*.txt');
%Open file
[fileID,errmsg] = fopen(filename);
data_cell = textscan(fileID,'%f%f%f%f%f%f%f%f%f%f%f%f%f', 'delimiter', ';','EmptyValue',-Inf,'HeaderLines',1);
fclose(fileID);
data_cell is always returned empty. Can someone help ?
Thanks
  2 个评论
Michal Dobai
Michal Dobai 2017-12-13
编辑:Michal Dobai 2017-12-13
I tested your program and it gives me 1x13 cell array of column vectors representing each column in input text file. So it works for me just fine.
Are you really opening file you mean to open? Because one mistake I can think of, could be opening file outside your current MATLAB folder. If this file has same name as some file in your current MATLAB folder, your code will open file from current folder instead (and you don't have to get any error message).
That's why you should use full path to open your file. Now you're doing this:
fopen(filename);
you should consider to change it to this:
fopen(fullfile(folder,filename));
Balkrishna Patankar
Balkrishna Patankar 2017-12-14
Thanks Michal for your help. The real problem as I figured out was in the encoding.
Changing the fopen to
[fileID,errmsg] = fopen(filename,'r','l','UTF16-LE');
solved the problem for me.

请先登录,再进行评论。

采纳的回答

Balkrishna Patankar
Balkrishna Patankar 2017-12-14
The problem was with the encoding of the file. Changing the fopen to
[fileID,errmsg] = fopen(filename,'r','l','UTF16-LE');
solved the problem for me.

更多回答(0 个)

Community Treasure Hunt

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

Start Hunting!

Translated by