This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
This should do the trick, using the following expression and the Parse method in the RegEx tool:
Basically it looks for: any characters | space | (any characters) | space | dash | space | (any characters) | 2 right parentheses, and then returns whatever is inside the two bolded parentheses sections above as your two parsed columns.
If you're looking for a way to play around with different expressions, regex101.com is pretty good - the color coding & explanations help you see what each expression is doing/looking for. Hope that helps!
I believe it will be I\(pmax\(0, (.+)\)\) with the REGEX tool set to Tokenize and Split to one column. And, no Regex tool is friendly to regex-rookies. The backslashes are there to escape the parentheses (make them not perform their regex function but act as characters) and the (.+) should select any number of characters that occupies that space and the Tokenize should place them in their own column.