Hi I am reading periodically some data from a server I get a JSON file. Then I parse this file in an array (about 2000 elements) of clusters. I need to perform some simple operations (like average, derivatives as a function of time..) on the data contained in this cluster. No problem until here..... but the data may change in time and mixes up my array. How can I handle this ? For exemple : I read a file at t0 and get an array with the elements : stringA, valueA; stringC, valueC Sometimes, the server adds an element in the json file, and I get stringA, valueA; stringB, valueB; stringC, valueC Now when I perform the average the second element in the array is not C anymore... How do I handle this ? Thanks for ideas

If I understand your question correctly, you have entries in the form <Identifier>,<Value>,[<Identifier>, <Value>] where I mean to say each line consists of at least 1, but maybe more, pairs of <Identifier>, <Value> strings. You (probably) need to process these data in two passes (you can probably do it in one, but it will be much trickier). First, parse each line (checking that there are an even number of entries, in the form <Identifier>, <Value> and accumulate a list of Identifiers that you find. For example, your first entry has Identifiers StringA and StringC, while the second adds StringB. Once you've parsed the entire list, you'll have a list of all the possible Identifiers. Now start the second Pass. Depending on what processing you need to do, you read a line, extract the <Values> according to their <Identifier> and process it however you need. For example, if simply counting how many of each type of <Value> you have, you can create an Array indexed by <Identifier> and increment entry <Identifier> for every entry having an <Identifier> record. If you need the "Mean Value", you'll need to also accumulate the sum of all the Values, dividing by the number of <Values> (which you've also been accumulating) when you finish the list. Bob Schor

LabVIEW

array of clusters that change

Solved!

That's called JSONpath notation. The extended help that JSONtext comes with has a page on it.

Message 11 of 11

(222 Views)

LabVIEW

array of clusters that change

Re: array of clusters that change