datastore multiple delimiter (space, tab)
显示 更早的评论
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 个评论
Guillaume
2019-10-21
Can you attach an example file? We'd only need the first few lines.
tkd
2019-10-21
Guillaume
2019-10-21
_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.
tkd
2019-10-21
采纳的回答
Guillaume
2019-10-22
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'
更多回答（0 个）
类别
在 帮助中心 和 File Exchange 中查找有关 Spreadsheets 的更多信息
产品
Translated by 
