Convert from csv to mat format
4 ビュー (過去 30 日間)
古いコメントを表示
I have 28 csv like this
![](https://www.mathworks.com/matlabcentral/answers/uploaded_files/160116/image.png)
I try to convert these in matlab format so I have used this code:
% return the list of csv files
d=dir('*.csv');
% Use textscan or textread or importdata
for i=1:length(d)
m{i}=textread(d(i).name,'','headerlines',2); % put into cell array
end
but it gives an error
Error using dataread
Trouble reading number from file (row 1, field 1) ==> fwa2500;30332392675;2016-10-14;18:26:57;-45,02
Error in textread (line 175)
[varargout{1:nlhs}]=dataread('file',varargin{:}); %#ok<REMFF1>
I have tried to use also
[ID,PHOTOID,DATA,ORA,LAT,LONG] = textread('1_Adam.csv','%s%d%d%d%d%d');
but it gives the error:
Error using dataread Trouble reading number from file (row 1, field 1) ==> fwa2500;30332392675;2016-10-14;18:26:57;-45,02
Error in textread (line 175)
[varargout{1:nlhs}]=dataread('file',varargin{:}); %#ok<REMFF1>
I have also used 'tableread' but it gives error
![](https://www.mathworks.com/matlabcentral/answers/uploaded_files/160117/image.png)
Finally I have tried this code
filename = '1_Adam.csv';
delimiterIn = ';';
A = importdata(filename,delimiterIn);
it import data but they are organize in this way
![](https://www.mathworks.com/matlabcentral/answers/uploaded_files/160118/image.png)
and it's not the format I want: I want that data are divided in 6 column by the delimiter ;
Can you help me?
0 件のコメント
回答 (1 件)
参考
カテゴリ
Help Center および File Exchange で String Parsing についてさらに検索
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!