Parse Everything to the Right of the String "Test"

[Link86]

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

[Felipe_Ribeir0 · Accepted solution]

Hi @Link86 

Try Test(.*)

[DataNath]

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:

[Link86]

Thank you