Remove Last Characters

[fjlorenzo]

Hi,

I have the below set of values. How can I remove the "on ROLENAME" and "on TEAMNAME" from each cell.

WAM Control - Role - Autosys-JobManager-Team on ROLENAME

WAM Control - Team - Web Dev Corp Finance on TEAMNAME

Thank you for your help.

Regards,

Florence

[fjlorenzo]

Thank you for this info.

[ataitt]

This solution worked best for me. I just wanted to add details about the regex expression used in the regex tool in alteryx. You can see the descriptions of most of the expressions used but there is one I could not figure out through Alteryx - (.+) - it can be helpful to understand what each expression is doing so you can easily build your own when needed.

The parenthesis () is a capturing group

The period "." captures one or more of any character (except for a newline)

The "+" indicates that it should capture as much as possible while still allowing the overall pattern to match

Hope this helps! regex is awesome!