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!
