Free Trial

Alteryx Designer Desktop Discussions

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

Parsing Text from the Middle of a String

jbh1128d1
10 - 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?

1 REPLY 1
MSalvage
11 - Bolide

@jbh1128d1,

 

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

 

Best,

MSalvage

Labels
Top Solution Authors