MATLAB Answers

changing the format of a cell matrix

27 views (last 30 days)
ektor
ektor on 29 Jan 2019
Answered: Walter Roberson on 29 Jan 2019
Dear all,
I have this cell matrix 'data', where as you can see below the element for example 8:00:06 is the hour-minute-second.
data(1:3,:)
ans =
3×1 cell array
{'01 8:00:06 29.0000 1000'}
{'01 8:00:06 29.1000 200'}
{'01 8:02:08 29.0700 1000'}
Now I want to convert the above matrix to the folowing format
01 8 00 06 29.000 1000
01 8 00 06 29.1000 200
01 8 02 08 29.0700 1000
Is there any way to do that in matlab? Can I have a sample code?
Many thanks

  0 Comments

Sign in to comment.

Accepted Answer

Walter Roberson
Walter Roberson on 29 Jan 2019
cell2mat(cellfun(@(S) sscanf(S, '%f %f:%f:%f %f %f').',data,'uniform', 0))

  0 Comments

Sign in to comment.

More Answers (0)

Tags

Community Treasure Hunt

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

Start Hunting!

Translated by