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 ...'

[Guillaume]

Can you attach an example file? We'd only need the first few lines.

[tkd]

Here is my dataset.

01/01/2001 00:14:35.96512    -0.01606    -0.02094    -0.10457
01/01/2001 00:14:35.97512    -0.01797    -0.01054    -0.05232

[Guillaume]

_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]

attached dataset.

Answer 1

[Guillaume]

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'

[tkd]

Thank you!