Removing semicolons from data

I have a dataset from a fitbit that gives e.g. steps per minute. The steps are data I can create an array from but the timedata is between semicolons which seems to give problems. Below is a picture of how the data is presented. And here is the code I used to retrieve it:
str = fileread('12h.json'); % dedicated for reading files as text 
data = jsondecode(str); % Using the jsondecode function to parse JSON from string to a Matlab struct.
step_data = data(1).data.data.activities_steps_intraday;
step_data = struct2cell(step_data);
time = cell2mat(step_data(1,:));
step = cell2mat(step_data(2,:));
How do I create an array for time from this data?
Here is how the data is converted at this moment:

 Accepted Answer

Matt J
Matt J on 18 Jan 2023
Edited: Matt J on 18 Jan 2023
str = fileread('12h.json'); % dedicated for reading files as text 
data = jsondecode(str); % Using the jsondecode function to parse JSON from string to a Matlab struct.
step_data = data(1).data.data.activities_steps_intraday;
step_data = struct2cell(step_data);
time=datetime(step_data(1,:),'Format','HH:mm:ss')

2 Comments

That is a really easy fix. Thank you!
One extra question: Is there a way to add the date to these timestamps? Because there is no defined date in the timestamps, so it automatically displays the date of today.

Sign in to comment.

More Answers (0)

Products

Release

R2022b

Asked:

on 18 Jan 2023

Commented:

on 18 Jan 2023

Community Treasure Hunt

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

Start Hunting!