Reading content of a file using readtable return NaT for Time
2 visualizzazioni (ultimi 30 giorni)
Mostra commenti meno recenti
Life is Wonderful
il 20 Ago 2019
Modificato: Life is Wonderful
il 5 Set 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.
Risposta accettata
Walter Roberson
il 5 Set 2019
Modificato: Andrei Bobrov
il 5 Set 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 Commenti
Più risposte (1)
Andrei Bobrov
il 5 Set 2019
Modificato: Andrei Bobrov
il 5 Set 2019
T = readtable('eventlog.txt','format',...
'%d %{yyyy-MM-dd HH:mm:SS}D %s %s %s','delimiter','|',...
'ReadVariableNames',false);
1 Commento
Vedere anche
Categorie
Scopri di più su Data Type Conversion in Help Center e File Exchange
Prodotti
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!