Parsing Text from the Middle of a String

[jbh1128d1]

Hello,

I'm not great with regex and wondered if I could pull the following name and numbers out of the following string field and parse them into their own columns.:

bSpline(RBA, degree = 1, knots = c(45000, 80000))1

bSpline(age, degree = 1, knots = c(27, 32, 69))1

The phrase will always look the same "bSpline(variable...."  I will have to pull the variable behind the first open parenthesis out into a column and the numbers (which can change) behind the "c(" after knots into their own columns.  

Can regex do this? Does anyone have an example?

[MSalvage · Accepted solution]

@jbh1128d1,

Totally possible. Regex is a great skill to learn. Workflow attached.

Best,

MSalvage