Calculation to return a word after a search string
This should be simple but I can't seem to figure it out: I want to make a calculation which returns the word which follows a specific text. For example my text field called "email" contains (amongst other things) firstname = Katherine, and I want to be able to make a calculation which will return "Katherine" after I specify that I want the word after the text string "firstname =" I think this should probably be achievable with the "position" text function, combined with a RightWord function, but I can't make it work.
I'd appreciate any help, tips... Thanks!