MATLAB: Jump datetime in graphs and tables

datetimegraphjump datetable

Dear all. How can I jump date on my graphs and tables?

For example: three to three,

Date        x1        x2
02/2010     3.24      4.36
05/2010     6.09      1.78
...
08/2018     value     value

Thanks!

Best Answer

You mean generate a series of some time difference (like three months above)???

dat=datetime(2010,2:3:9*12,1).';
dat.Format='MM/yyyy';
>> dat(1:5)
ans = 
  5×1 datetime array
   02/2010
   05/2010
   08/2010
   11/2010
   02/2011
>>

Related Solutions

MATLAB: Combining Date and Time variables (class – datetime) into 1 DateTime (class – double) array

I haven’t used the new datetime functions much, and I don’t have your array. This works on the example you gave:

Date = datetime('06.07.2010','InputFormat','dd.MM.yyyy');
Time = datetime('22:31','InputFormat','HH:mm');
CnvtDT = @(Date,Time) datetime([Date.Year  Date.Month  Date.Day  Time.Hour  Time.Minute 0], 'Format', 'dd.MM.yyyy HH:mm');
DateTime2 = CnvtDT(Date,Time)          % Check Output

The output is also a ‘datetime’ structure.

MATLAB: Reading data after a string

Here is one way, assuming that the block of data is the last content that you have in the file. If not, I can update the answer. As Walter is pointing out, we have to read the file from the beginning (here we read the full content) and match pattern(s). This solution does that using a a regular expression, which is quite concise, but you could implement a more basic loop which scans each line.

 content = fileread( 'myFile.txt' ) ;
 blocks  = regexp( content, 'Link Results.*?Full.*?\-\s(.*)', 'tokens' ) ;
 block   = blocks{1}{1} ;
 data    = textscan( block, '%s %s %f %f %f %f' ) ;

After running this, you get..

 >> data
 data = 
    {3x1 cell}    {3x1 cell}    [3x1 double]    [3x1 double]    [3x1 double]    [3x1 double]
 >> data{1}
 ans = 
    'SEP-29-2010'
    'SEP-29-2010'
    'SEP-29-2010'
 >> data{2}
 ans = 
    '00:15:00'
    '00:30:00'
    '00:45:00'
 >> data{3}
 ans =
     0
     0
     0

etc. Then you can post-process this cell array to get e.g. a cell array of time stamps, and a numeric array of data..

 timeStamps = arrayfun( @(r) [data{1}{r}, ' ', data{2}{r}], ...
                        1:numel(data{1}), 'UniformOutput', false ).' ;
 dataNum    = [data{3:end}] ;

which leads to:

 >> timeStamps
 timeStamps = 
    'SEP-29-2010 00:15:00'
    'SEP-29-2010 00:30:00'
    'SEP-29-2010 00:45:00'
 >> dataNum
 dataNum =
     0     0     0     0
     0     0     0     0
     0     0     0     0

Best Answer

Related Solutions

MATLAB: Combining Date and Time variables (class – datetime) into 1 DateTime (class – double) array

MATLAB: Reading data after a string

Related Question