Extracting text from long string after certain word
Posted on 2013-01-01
I am trying to only display certain text from a field with a long string.
If field is:
"Some Investor With a Long Title Acct#:123456789"
I want to create a formula field that looks for the "Acct#:" and returns all string data from the word "Acct#:" all the way to the end of the string. i.e. "Acct#: 123456789". The "Acct#:" will always be at the end but the account number will vary in length, so a Right() function will not suffice. I tried playing around with the Instr() function but did not get very far with it.