Time cell (or char) inside a double array

1 次查看（过去 30 天）
Engineer
Engineer 2014-1-20
评论： Till Rahlf 2014-1-20
Hello, I have a 45x1 cell array, that I can convert to 45x8 char... the single cell is showing time, for example '09:45:46' ..
now, I would like to put this column as the first column of a double precision data array D.
I tried several things I was reading around, but I haven't found anything that could give me the right time as I see it here.
Some tips? Thanks
  2 个评论
Engineer
Engineer 2014-1-20
编辑：Engineer 2014-1-20
I get the time using getabstime function from a timeseries object...in output is a (for exapmle) 45x1 cell containing each one the time in string 09:45:43. I'd like to have the time expressed in the first column in a double precision array as it is shown above. Now, I solved the problem doing datenum(getabstime(ow86), as usual, but I'd like to have time express as above, in order to read "easily" the data

请先登录，再进行评论。

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

采纳的回答

Till Rahlf
Till Rahlf 2014-1-20
编辑：Till Rahlf 2014-1-20
which matlab release do you use?
dateCells = {'09:45:46','09:45:49'}
dateString = strjoin(dateCells, sprintf('\n'))
result = textscan(dateString, '%d:%d:%d') % for integer results
result = textscan(dateString, '%f:%f:%f') % for double results
  2 个评论
Engineer
Engineer 2014-1-20
Thanks..I have earlier version of Matlab, but I found strjoin in File exchange http://www.mathworks.com/matlabcentral/fileexchange/31862-strjoin.
However, I'd like to have the cell showing the time 09:45:43 (1,1), 09:45:44 (2,1), 09:45:45 (3,1) etc. , as first column of an array that is made by double precision data in the other 4 columns...
Reading around, maybe this is not possible(?!)...I switched for the usual datenum, even if I'm not very satisfied by that!
Amit
Amit 2014-1-20
Okay the problem is the 09:45:43 is not double precision. So you cannot express it as double precision. The closest I can say you can do it 094543 which is a number.

请先登录，再进行评论。

更多回答（1 个）

Till Rahlf
Till Rahlf 2014-1-20
What is exactly the result you expect?
Can you give an example for the cell array "dateCells "?
dateCells = {'09:45:43','09:45:44','09:45:45'}
expectedResult = ???
  2 个评论
Engineer
Engineer 2014-1-20
I would like to show/print the time in the format HH:MM:SS instead of the datenum number in this double array. Probably, as said before, this is not possible because the time is not a number
Till Rahlf
Till Rahlf 2014-1-20
Yes, it is right. The character ":" can not be represented by a double number.
Alternatively you can have numbers like Amit wrote:
result = [
094543 ...
094544 ...
094545 ...
]
Or in stead of one double time column, you could have 3, like
result = [ 09 45 43 ...
09 45 44 ...
09 45 45 ...
]
Is that solution applicable?

请先登录，再进行评论。

类别

在 Help Center 和 File Exchange 中查找有关 Data Type Conversion 的更多信息

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by