Timestamp not converting to a string

Question

saadatnk8 2015-10-22

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/250226-timestamp-not-converting-to-a-string

评论： dpb 2015-10-22

Timestamps.mat

I imported data from excel which has timestamps, i.e. just time for example '7:01 PM' as a matlab number. However, I'm using the datestr() function to convert the matlab date number to a string and I am getting the following error.

Subscript indices must either be real positive integers or logicals.
Error in formatdate (line 158)
            month = char(strrep(month(dtvector(:,2)), '.', '')); %remove period
Error in dateformverify (line 32)
S = char(formatdate([y,mo,d,h,minute,s],dateformstr,islocal));
Error in datestr (line 194)
S = dateformverify(dtnumber, dateformstr, islocal);

This is the code that I used

a = datestr(PM10data.Time);

However, if I use a specific value in the dataset, say a = datestr(PM10data.Time(391)) the code works. Please help me fix this.

I have attached the .mat file which has all the timestamps

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

dpb 2015-10-22

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/250226-timestamp-not-converting-to-a-string#answer_196922

在 MATLAB Online 中打开

Given the error and that load returned a double array, what follows was a logical next step--

>> load timestamps.mat
>> all(isfinite(Time))
ans =
   0
>> any(isnan(Time))
ans =
   1
>> sum(isnan(Time))
ans =
 434
>> Time(isnan(Time))=[];  % ok, so remove those and...
>> ts=datestr(Time);      % now completes as expected...
>>