AnsweredAssumed Answered

Find values in a field with several values

Question asked by tbuur on Jan 25, 2019
Latest reply on Jan 26, 2019 by tbuur

Hi

 

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

Outcomes