datastore multiple delimiter (space, tab)
5 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
Hello,
I have the following data on my 1st column, MM/dd/YYYY HH:mm:ss.SSSSS. How do I seperate the two?
When using
ds=datastore('data.txt');
it'll group MM/dd/YYYY HH:mm:ss.SSSSS into Var1.
Var1
___________________________
'MM/dd/YYYY HH:mm:ss.SSSSS'
I tried
ds=datastore('data.txt',...
'Delimiter',{' ','/t'});
it'll seperate MM/dd/YYYY to Var1 and all colums after that as Var2.
Var1 Var2
___________ ____________________________________
'MM/dd/YYYY' 'HH:mm:ss.SSSSS DATA DATA DATA ...'
4 commentaires
Guillaume
le 21 Oct 2019
_Can you attach (with the paperclip icon) an example file? This is so we get the actual characters in your file. The text you've pasted does not have tab characters (just 4 spaces instead of tabs). This example is loaded by datastore by default exactly as you want.
Réponse acceptée
Guillaume
le 22 Oct 2019
I should have spotted that straightaway, the way to specify control characters is with a backslash \, not a forward slash /.
ds=datastore('data.txt', 'Delimiter',{' ','\t'}); %\t not /t
will load your file fine. You may need to override the datetime format detected by datastore depending on whether your dates are encoded as 'MM/dd/uuuu' or 'dd/MM/uuuu'
Plus de réponses (0)
Voir également
Catégories
En savoir plus sur Datastore 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!