How to open .CSV file ?
3 ビュー (過去 30 日間)
古いコメントを表示
I want to open CSV file. (please find the attachment)
in the CSV file, I have date and time in the different column but I want to combine in one column. I have read with following code but I getting an error.
fbc = fopen('ABCD.CSV');
BC = textscan(fbc, '"%.f-%3.s-%.f", "%.f:%.f", %.f,%.f,%.f,%.f,%.f,%.f,%.f,%.f,%.f,%.f,%.f,%.f,%.f,%.f,%.f,%.f,%.f,%.f,%.f,%.f,%.f,%.f,%.f,%.f,%.f,%.f,%.f,%.f,%.f,%.f,%.f,%.f,%.f,%.f,%.f,%.f,%.f,%.f,%.f,%.f,%.f,%.f,%.f,%.f,%.f,%.f,%.f,%.f,%.f,%.f');
fclose(fbc);
0 件のコメント
回答 (2 件)
Walter Roberson
2018 年 6 月 15 日
fmt = ['%{dd-MMM-yy}D%{HH:mm}D', repmat('%f', 1, 50)];
fbc = fopen('ABCD.CSV', 'r', 'n', 'UTF8');
BC = textscan(fbc, fmt, 'Delimiter', ',', 'CollectOutput', 1);
fclose(fbc);
dt = BC{1}+(BC{2}-dateshift(BC{2},'start','day'));
dt.Format = 'default';
numbers = BC{3};
0 件のコメント
参考
カテゴリ
Help Center および File Exchange で Text Files についてさらに検索
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!