Arranging JSON-formatted txt file
6 views (last 30 days)
Show older comments
Hi,
I have JSON-formatted txt file from which I need to extract data and process it for further evaluation. This file contains values for 6 parameters and displays as 1x28272 table. How do I make these 6 parameters as seperate columns?
Any help would be great/
Thanks and Regards,
Divya
This is how my data looks :
{"phase":["328.17418282485926","98.13568811161387","267.3230213793066...........,"],"rssi":["....."],"halfrow":["......"],"tag":["........"],"time":["......"],"frequency":["....."]}
2 Comments
Accepted Answer
Askic V
on 21 Nov 2022
Maybe something like this:
raw = '{"phase":["328.17418282485926","98.13568811161387","267.3230213793066...........,"],"rssi":["....."],"halfrow":["......"],"tag":["........"],"time":["......"],"frequency":["....."]}';
data = jsondecode(raw); % Using the jsondecode function to parse JSON from string
data.phase
data.rssi
3 Comments
Askic V
on 21 Nov 2022
I would start with this (found on another thread)
fileName = 'tagdata_new_0_height_0_03_08_22_12.txt'; % filename in JSON extension
fid = fopen(fileName); % Opening the file
raw = fread(fid,inf); % Reading the contents
str = char(raw'); % Transformation
fclose(fid); % Closing the file
data = jsondecode(str); % Using the jsondecode function to parse JSON from string
fields = fieldnames(data);
phase = str2double(data.(fields{1}));
More Answers (0)
See Also
Categories
Find more on JSON Format in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!