Parse Everything to the Right of the String "Test"

Hi, I am trying to parse everything to the right of the string "Test" I have tried formula tool with Right([String], FindString(ReverseString([String]), "Test")) and text to columns and neither work. I am now trying regex and cannot get that to work either. Can anyone help with this? I have attached a workflow.

Thank you

RightOfString.yxmd

Regex

Parse

Help

Accepted answers

Try Test(.*)

RightOfString.yxmd

All comments

Try Test(.*)

RightOfString.yxmd

Hey @Link86, if you wanted to stick to string functions like your initial approach then you could use something like this. You just find the Index of 'Test' and then add 4 (as it's a 4 letter word), then take the remainder of the string:

RightOfString.yxmd

Thank you

Quick Links

Tags

This months top contributors

atcodedog05 19598

Qiu 15867

MarqueeCrew 13708

apathetichell 13703