How can I have an expression pull values out of a long string?

We have a data field in which the string has multiple substrings defined. Example:

"{"id":"JOHN1","firstName":"John","lastName":"Smith","email":"","fullName":"John Smith"}"

I'd like be able to pull out just the email address, for example. I can't use a MID expression since the values will vary in length. Is there some way to use the find function to maybe perform this logic: Find "email":" and return subsequent text until the next " ?




(2) Answers