AnsweredAssumed Answered

Calculation to return a word after a search string

Question asked by kbda on Nov 28, 2011
Latest reply on Nov 30, 2011 by kbda

Title

Calculation to return a word after a search string

Post

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!

Outcomes