how to extract the big content of a cell array?

2 次查看（过去 30 天）

Valeria Leto 2021-8-5

1
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/893302-how-to-extract-the-big-content-of-a-cell-array

评论： Stephen23 2021-8-10

Hi! I have a 2859x1 cell array. In each cell there is a content like this:

1617026479572040798,,0,,0,0,'',25.0,,,[],0,"[76, 74, 71, 78, 76, 77, 73, 76, 73, 76, 79, 154, 158, 164, 166, 149, 134, 137, 131, 124, 123, 121, 114, 121, 117, 109, 120, 117, 115, 106, 104, 110, 111, 116, 116, 114, 109, 115, 114, 110, 106, 113, 109, 114, 114, 113, 118, 107, 110, 109,.....

I would like to save the numbers it into a double array. How could I do that? Thanks

11 个评论
显示 9更早的评论隐藏 9更早的评论

Peter Perkins 2021-8-9

在 MATLAB Online 中打开

The problem is that once you type 1617026479572040798, you are already done for:

>> sprintf("%.20f",1617026479572040798)

ans =

"1617026479572040704.00000000000000000000"

If it's wrapped in uint64, things are OK,

>> uint64(1617026479572040798)
ans =
  uint64
   1617026479572040798

but then the question is how to get that into a datetime with as much precision as possible. The solution is epochtime:

>> datetime(uint64(1617026479572040798), 'convertfrom', 'epochtime','TicksPerSecond',1e9,'Epoch','1-Jan-1970','Format','dd-MMM-uuuu HH:mm:ss.SSSSSSSSS')
ans = 
  datetime
   29-Mar-2021 14:01:19.572040798