How to hide text before a certain "text"?

[perryc]

e.g. in a text field, it contains "Hello this part is not needed. Notice: this is an important message"
I would like the text field now only to show "Notice: this is an important message" and hide everything before the word Notice.


Thank you for your help.

[pbaldy]

You can use the Mid() and InStr() functions:

?mid("Hello this part is not needed. Notice: this is an important message",instr(1,"Hello this part is not needed. Notice: this is an important message","Notice"))
Notice: this is an important message

[perryc]

That works! Ty for quick response.

[pbaldy]

Happy to help!