community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

Parsing Text from the Middle of a String

Fireball

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?

Bolide

@jbh1128d1,

 

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

 

Best,

MSalvage

Labels