Skip to main content

How do I extract data from a dictionary data type?

  • August 18, 2022
  • 0 replies
  • 9 views

Forum|alt.badge.img+3

Example
I have a field with the following data:
{“blog”:“abc dot com”, “twitter”:“xyz dot com”, “facebook”:“pqr dot com”}

I want to use the “keys”, viz, blog, twitter and facebook to extract abc dot com, xyz dot com and pqr dot com respectively.

So if I have the key “blog” in a formula, I want to store the corresponding data ie “abc dot com”. Any ideas how to do this?