Upload txt file with time units

1 次查看（过去 30 天）
Lizan
Lizan 2013-5-24
Hi, I have a text file like,
13:43:51 26.0503 0.0000060763786
13:43:51 26.0503 0.0000085937353
13:43:51 26.0503 0.0000073350570
13:43:51 26.0503 0.0000073350570
13:43:52 26.0503 0.0000084201246
13:43:52 26.0503 0.0000072482512
13:43:52 26.0503 0.0000076388760
13:43:52 26.0503 0.0000093315811
13:43:52 26.0503 0.0000073350570
I would like to upload the time difference from the beginning, such as
1 26.0503 0.0000060763786
1 26.0503 0.0000085937353
1 26.0503 0.0000073350570
1 26.0503 0.0000073350570
2 26.0503 0.0000084201246
etc.,..
That is have the time display in seconds only. Any idea how to do this.
When using x = load('data.txt');
I get
14.0000 24.9678 0.0008
14.0000 24.9678 0.0008
14.0000 24.9678 0.0008
14.0000 24.9678 0.0008
14.0000 24.9678 0.0008
14.0000 25.0020 0.0008
It seems to only take the first number.
Kind Regards,
That is I want to upload a vector of hh:mm:ss and then convert it to seconds.

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

回答（1 个）

Walter Roberson
Walter Roberson 2013-5-24
fid = fopen('data.txt','rt');
datacell = textscan(fid, '%s%f%f');
fclose(fid);
datatimes = datenum(datacell{1}, 'hh:mm:ss');
timeoffset = datatimes - datatimes(1);
offsetsecs = round(timeoffset * 24*60);
newdata = [offsetsecs(:), datacell{2}, datacell{3}];
newdata will now be the array.
  1 个评论
Lizan
Lizan 2013-6-10
编辑：Lizan 2013-6-10
I only obtain,
newdata =
0 24
It does not seem to obtain the whole array..?
datacell =
{1x1 cell} [24] [0x1 int32] if I use %d
datacell =
{1x1 cell} [24] [0x1 double] if I use %f
Example of data:
14:42:21 24,0671 0,0000530381039
14:42:21 24,0671 0,0000508679695
14:42:22 24,0671 0,0000521700495
14:42:22 24,0671 0,0000539061584
14:42:22 24,0671 0,0000520832436
14:42:22 24,0671 0,0000530815050
14:42:22 24,0671 0,0000516492181
14:42:22 24,0671 0,0000504339404
14:42:22 24,0671 0,0000506075521
14:42:23 24,0671 0,0000529078934
14:42:23 24,0671 0,0000518662309
14:42:23 24,0713 0,0000519964378
14:42:24 24,0713 0,0000506943579
14:42:24 24,0713 0,0000507377590
14:42:24 24,0713 0,0000515624123
14:42:24 24,0713 0,0000503471346
14:42:24 24,0713 0,0000496092907
14:42:24 24,0713 0,0000521266446
14:42:25 24,0713 0,0000527342853
14:42:25 24,0713 0,0000523436611
14:42:25 24,0713 0,0000513453960

请先登录，再进行评论。

类别

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

标签

产品

Community Treasure Hunt

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

Start Hunting!

Translated by