MATLAB Answers

how to read mixed date and data

21 ビュー (過去 30 日間)
DwiNY
DwiNY 2021 年 9 月 24 日 22:27
コメント済み: DwiNY 2021 年 9 月 27 日 20:31
How to read this data file:
2020/11/15 07:30:55 27.50 124
2020/11/15 07:40:55 27.63 114
2020/11/15 07:50:55 27.71 95

採用された回答

Jeremy Hughes
Jeremy Hughes 2021 年 9 月 27 日 19:14
I made some corrections in the comments above, but this is how I would do this more robustly using partial detection with detectImportOptions.
filename = "example.txt";
opts = detectImportOptions(filename,"Delimiter","\t");
opts = setvaropts(opts,1,"Type","datetime","InputFormat","uuuu/MM/dd HH:mm:ss");
T = readtable(filename,opts)
T = 3×3 table
Var1 Var2 Var3 ___________________ _____ ____ 2020/11/15 07:30:55 27.5 124 2020/11/15 07:40:55 27.63 114 2020/11/15 07:50:55 27.71 95
  2 件のコメント
DwiNY
DwiNY 2021 年 9 月 27 日 20:31
Jeremy,
If you could make more a general, i.e. input file with XX number of lines of header would be appreciate.
Thank you

サインインしてコメントする。

その他の回答 (1 件)

the cyclist
the cyclist 2021 年 9 月 24 日 22:46
I would try the readtable function.
You can specify the input formating if needed.
  4 件のコメント
Jeremy Hughes
Jeremy Hughes 2021 年 9 月 27 日 19:09
If you're using format, there are issues with your format in both cases: mm cannot be both months and minutes, you want MM.
Also, you probably want the second part as duration if you're parsing these as separate fields.
try this: formatSpec = '%{yyyy/MM/dd}D{hh:mm:ss}T%f%f'
But I like your first approach better:
delimiter = '\t'; %no space
formatSpec = '%{yyyy/MM/dd HH:mm:ss}D%f%f'

サインインしてコメントする。

製品


リリース

R2020b

Community Treasure Hunt

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

Start Hunting!

Translated by