Regular expression to get text from a string :

How can we help you today?

Start a new topic

started a topic 7 months ago

I have a field that comes in with the following values:

{"annual_fund_gift_preference"=>"Diversity, Equity, and Inclusion"}

{"annual_fund_gift_preference"=>"Environment/Sustainability"}

{}

{"annual_fund_gift_preference"=>"Athletics"}

{"annual_fund_gift_preference"=>"Arts"}

IF {} then blank

otherwise I want to extract the word or phrase in the last set of quotes, i.e., Diversity, Equity, and Inclusion or Athletics

Any help is appreciated.

Thank you!

1 Comment

said 7 months ago

Never mind. I was able to use a basic dictionary.