Added file
Reading content of a file using readtable return NaT for Time
3 views (last 30 days)
Show older comments
Life is Wonderful
on 20 Aug 2019
Edited: Life is Wonderful
on 5 Sep 2019
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.
Accepted Answer
Walter Roberson
on 5 Sep 2019
Edited: Andrei Bobrov
on 5 Sep 2019
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 Comments
More Answers (1)
Andrei Bobrov
on 5 Sep 2019
Edited: Andrei Bobrov
on 5 Sep 2019
T = readtable('eventlog.txt','format',...
'%d %{yyyy-MM-dd HH:mm:SS}D %s %s %s','delimiter','|',...
'ReadVariableNames',false);
1 Comment
See Also
Categories
Find more on Data Type Conversion in Help Center and File Exchange
Products
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!