How to find the following pattern in my Char variable in the workspace?

Dear All,

I am reading a webpage through data = webread(url); which giving me a Char variable in the workspace called data.

I want ot get all "Strings" inside that char variable that start and end with "SomeText I dont Care":{"raw": SomeSTuff I dont Care }

E.g.: "costOfRevenue":{"raw":4751000000,"fmt":"4,75B","longFmt":"4.751.000.000"},"totalOtherIncomeExpenseNet":{"raw":-213000000,"fmt":"-213M","longFmt":"-213.000.000"}, and so on.............

How can i do this in Matlab?

As you can see it is a webpage so it containes other stuff that i dont care about

Best Regards

[Cris LaPierre]

I'm not sure I understand what your pattern is. From your example, what should the result be? Everything inside double quotes?

[Obay]

hallo Cris,

Thanks for your comment, my answer should be:

"costOfRevenue":{"raw":4751000000,"fmt":"4,75B","longFmt":"4.751.000.000"}

so i need to get a cell array if possible in which each cell will contain one "raw" statament as the above example

Best Regards

[Cris LaPierre]

Ok, so what you shared was actually the resutl. We are pretty good, but without knowing the starting point, i don't know how we are supposed to propose a solution. Please share the raw data you are working with. You can attach it using the paperclip icon.

[Obay]

Hallo Cris,

Thanks for your support, here is the code

if true
  Url = 'https://finance.yahoo.com/quote/TSLA/financials?p=TSLA';
Data = webread(Url);
end

And here is ur rawdata I hope now it is clear

Best regard

[Obay]

Hallo Cris,

any update here? I even attached the RawData as a .mat file

please assist in this

Best Regards

[Bob Thompson]

Have you tried using regexp? I would imagine that would allow you to parse out exactly what you want from the website. Something like the following:

raw = regexp(Data,'("costOfRevenue":{"raw".*})','tokens');

I don't expect that to work perfectly the first attempt, I haven't tested it, but it should get you going somewhere.

[Obay]

Yes i have been trying with the regexp function but still not sure how to use it and that is why i am asking here.

Using your suggestion don not answer my question exactly as my question was:

i don't want to give any text value at the start which means in need something like:

raw = regexp(Data,'("*":{"raw".*})','tokens');% so the Text at the start is not impotant as i need all the values of those texts
% this is not giving me the data i need as also it is not stoping at the expected point in need it to stop at } or ,

Answer 1

[Stephen23]

Assuming no nested curly braces:

str = '"costOfRevenue":{"raw":4751000000,"fmt":"4,75B","longFmt":"4.751.000.000"},"totalOtherIncomeExpenseNet":{"raw":-213000000,"fmt":"-213M","longFmt":"-213.000.000"}, and so on.............';
rgx = '"\w+":\{"raw":[^}]+\}';
out = regexp(str,rgx,'match');
out{:}

ans = '"costOfRevenue":{"raw":4751000000,"fmt":"4,75B","longFmt":"4.751.000.000"}'

ans = '"totalOtherIncomeExpenseNet":{"raw":-213000000,"fmt":"-213M","longFmt":"-213.000.000"}'

[Obay]

Dear Stephan,

Thanks alot that is what i was looking for :)

sorry that i don't really get thos reguler expristion stuff but it is just what i was looking for :)