Reading content of a file using readtable return NaT for Time
3 visualizaciones (últimos 30 días)
Mostrar comentarios más antiguos
Life is Wonderful
el 20 de Ag. de 2019
Editada: Life is Wonderful
el 5 de Sept. de 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.
Respuesta aceptada
Walter Roberson
el 5 de Sept. de 2019
Editada: Andrei Bobrov
el 5 de Sept. de 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 comentarios
Más respuestas (1)
Andrei Bobrov
el 5 de Sept. de 2019
Editada: Andrei Bobrov
el 5 de Sept. de 2019
T = readtable('eventlog.txt','format',...
'%d %{yyyy-MM-dd HH:mm:SS}D %s %s %s','delimiter','|',...
'ReadVariableNames',false);
1 comentario
Life is Wonderful
el 5 de Sept. de 2019
Editada: Life is Wonderful
el 5 de Sept. de 2019
Ver también
Categorías
Más información sobre Data Type Conversion en Help Center y File Exchange.
Productos
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!