A
A
arsenaljek2021-08-31 06:09:16
Google Sheets
arsenaljek, 2021-08-31 06:09:16

How to remove extra in a cell?

Whether prompt it is possible somehow under the formula, to delete superfluous values ​​in a cell?
I have such data. I get them via api. The order of the line is always changing.
That is, it can be so
{reserved=0.0, present=9.0, coming=0.0}
or so
{present=9.0, coming=0.0, reserved=0.0}
. I need to leave only present = Value in this cell. The meaning is naturally always different. The other two, coming and reserved, always have 0.0.
Ideally, in general, output only the digit which is equal to present. But there are no ideas at all, except how to solve it at the json generation stage

spoiler

Larger
612d9c8a93266563355461.jpeg

Answer the question

In order to leave comments, you need to log in

1 answer(s)
G
Grigory Boev, 2021-08-31
@arsenaljek

=REGEXREPLACE(
   REGEXEXTRACT(
      A1
      ;"present=(\d+[,.]?\d?)"
   )
   ;"\."
   ;","
)

where A1 is the data link

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question