Arranging JSON-formatted txt file

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":["....."]}

[KSSV]

Explore functions like table2struct, table2cell.

Or attach your data along with the code you tried.

[Divya]

This is what I tried :

RFID_data = readtable('tagdata_new_0_height_0_03_08_22_12');

Answer 1

[Askic V]

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

ans = 3×1 cell array
    {'328.17418282485926'           }
    {'98.13568811161387'            }
    {'267.3230213793066...........,'}

data.rssi

ans = 1×1 cell array
    {'.....'}

[Divya]

How do I use the above when I have more data?

I have attached my data file

Thanks,

Divya

[Askic V]

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}));

[Divya]

This works perfectly!

Thanks,

Divya