Running out of ideas and hope that some of you more experienced people have a solution to what I need to do.
I have a function that retrieves temperature values and time from another app through an API. This part works as expected but I often retrieve several values in return in the field used to get the capture the values (I use "Insert from URL" and have set a field to hold the data I get back).
The result I get back often look like this:
and I only need to capture the last time and value. To make it even more difficult the "value" is not always the same size as it can be 5,4, or 2 characters long depending on the temperature value.
How can I get those two values out so I can save them into two other fields (time and temperature), please help