Start a new topic

Regular expression to get text from a string

 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

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


1 person likes this
Login or Signup to post a comment