How do I extract data from a dictionary data type?

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?

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.