Added file
Reading content of a file using readtable return NaT for Time
3 ビュー (過去 30 日間)
古いコメントを表示
Life is Wonderful
2019 年 8 月 20 日
編集済み: Life is Wonderful
2019 年 9 月 5 日
Please find the attached file. I want to use readtable to parse the file using readtable function.
I want Date and message content separatly done.
採用された回答
Walter Roberson
2019 年 9 月 5 日
編集済み: Andrei Bobrov
2019 年 9 月 5 日
filename = 'eventlog.txt';
opt = detectImportOptions(filename);
opt = setvartype(opt, 5, 'char');
datatable = readtable(filename, opt);
datatable{:,2} is now the datetime entry, and datatable(:,[3 4 5]) are the fields.
As the fields are delimited, it is not completely clear whether you wanted everything to the end of the line as a single character vector complete with '|' inside, or if you wanted the fields broken out. The above breaks them out.
string(datatable{:,3}) + " | " + string(datatable{:,4}) + " | " + string(datatable{:,5})
would put the fields back together, except with an extra trailing " | " on the lines that had only 4 fields originally.
2 件のコメント
その他の回答 (1 件)
Andrei Bobrov
2019 年 9 月 5 日
編集済み: Andrei Bobrov
2019 年 9 月 5 日
T = readtable('eventlog.txt','format',...
'%d %{yyyy-MM-dd HH:mm:SS}D %s %s %s','delimiter','|',...
'ReadVariableNames',false);
参考
カテゴリ
Help Center および File Exchange で Data Type Conversion についてさらに検索
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!