Extracting a substring that has an inconsistent starting position

[seahill]

I have a variable that contains alphanumeric strings of different lengths. While there's some variation among all of the entries, the word "submarine" is always present. The position of "submarine" can vary.

I want you extract "submarine" and everything that follows it. How do I do that given the variable position of "submarine"?

[Tom]

Use the INDEX() function.  Or possible FIND(), INDEXW() or FINDW().

want = substrn(index(have,'submarine'));

[ChrisNZ]

or use prxchange

NEWSTR = prxchange('s/(submarine.*)/\1/, 1, STR);