Added file
Reading content of a file using readtable return NaT for Time
3 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
Life is Wonderful
le 20 Août 2019
Modifié(e) : Life is Wonderful
le 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.
Réponse acceptée
Walter Roberson
le 5 Sep 2019
Modifié(e) : Andrei Bobrov
le 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 commentaires
Plus de réponses (1)
Andrei Bobrov
le 5 Sep 2019
Modifié(e) : Andrei Bobrov
le 5 Sep 2019
T = readtable('eventlog.txt','format',...
'%d %{yyyy-MM-dd HH:mm:SS}D %s %s %s','delimiter','|',...
'ReadVariableNames',false);
1 commentaire
Voir également
Catégories
En savoir plus sur Data Type Conversion dans Help Center et File Exchange
Produits
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!