Selecting text right of a string when the string occurs twice in a cell

MattR79

I have an issue I am trying to resolve where I only want to keep the text right of a certain string in a cell however the particular string occurs twice in the cell in the Excel file.  I am currently using the below formula to try to get it to work but it is not working correctly.  I cannot use a find/replace in the parse tool because the string is not always the same.  Shown below is the input have along with the desired output.

Current Formula:  Right([Replaced ERR_TXT], FindString([Replaced ERR_TXT], '<Messages><Messages>'))

Input	Desired Output
<Messages> <Message> Desired Remaining Text <Messages> <Message>	Desired Remaining Text
Long sting of varying text which may change from row to row and definitely day to day <Messages> <Message> Desired Remaining Text <Messages> <Message>	Desired Remaining Text

TUSHAR050392

@MattR79 I will advise to use the regex tool and follow below steps -

Mention the column to parse

In regular expression mention this expression  .*>(.*)<.*><.*

Output method - Parse and you will get the string in a new column whatever you name it

Hope this helps