Removing semicolons from data

10 views (last 30 days)
Anton
Anton on 18 Jan 2023
Commented: Anton on 18 Jan 2023
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
Anton
Anton on 18 Jan 2023
That is a really easy fix. Thank you!
Anton
Anton on 18 Jan 2023
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)

Categories

Find more on Argument Definitions in Help Center and File Exchange

Products


Release

R2022b

Community Treasure Hunt

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

Start Hunting!