Parse info found between the third quotation marks: {"id"=>abcd, "value"=>"efgh"}

Options

Hello guys,


Can you help me extract the info found between the third quotation marks from this?

{"id"=>abcd, "value"=>"efgh"}

The id can have either 3 or 4 characters and the info in the last quotation marks can have a different number of characters as well. I need to extract efgh.

Do you have any ideas?


Thank you!

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!