How get values from ch
14 Ansichten (letzte 30 Tage)
Ältere Kommentare anzeigen
JM_Cortes
am 10 Jun. 2019
Bearbeitet: Bob Thompson
am 10 Jun. 2019
Hello i got this ch in workspace and i want to get the values "price" from it for plot them, how can i put in a cell?
I got this.
[{"date": "1560160129", "tid": 90322567, "price": "7727.41", "type": 0, "amount": "0.00783400"}, {"date": "1560160115", "tid": 90322553, "price": "7725.96", "type": 0, "amount": "0.08018985"}]
Thank you
Regards
2 Kommentare
Bob Thompson
am 10 Jun. 2019
Bearbeitet: Bob Thompson
am 10 Jun. 2019
If I am interpretting what you have posted correctly you have two cells, each which contain five strings, and you want to extract the numeric value following 'price'? How are you importing the data, does it need to be in strings?
With what you have now I would suggest using a combination of regexp, str2num, and possibly strfind.
EDIT** I just realized that all of the links were incorrect. They have been fixed.
Akzeptierte Antwort
Bob Thompson
am 10 Jun. 2019
As far as I can tell the easiest way to do what you're asking would be something like the following:
price = str2num(regexp(string,'"price": "(\d*.\d*)"','tokens'));
You may have some issues with cells being too deep, but you can pull the price information further out if needed.
2 Kommentare
Bob Thompson
am 10 Jun. 2019
So, this is what I was saying by having extra depth to the array (each cell you see contains a 1x1 cell with the actual string). Personally, I find it very frustrating to deal with, but regexp is too useful for working with strings to ignore. Luckily, in this case the solution is fairly simple.
ps = regexp(string,'"price": "(\d*.\d*)"','tokens');
ps = [ps{:}];
price = str2double(ps);
Weitere Antworten (1)
Siehe auch
Kategorien
Mehr zu String finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!