How to remove a string of text with Regex tool?

[TwanD]

Hi everyone,

I have been using 'Text to Column' tool and that has been working fine but I really want to get into using the 'Regex' tool because of its capabilities. Granted I'm a novice at this so a lot of trials and errors to get things to work but for the life of me I can't figure out how to write the expression properly to replace the field with a string of text I want.

Original text string:

Sum_STATUTORY.O1 Entity Name

And I want just this:

O1 Entity Name

I understand I can use the replace function in Regex tool to accomplish this but I just haven't been able to write out the expression to accomplish it. Any help would be greatly appreciated, thanks!

[TwanD]

Thank you, this works great too!