How do I extract data from a dictionary data type?

Topic Labels: Formulas
512 0
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

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?

0 Replies 0