Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

Alteryx Designer Desktop Discussions

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

Regex expression for parsing integars, decimels, and strings

cdahl001
7 - Meteor

Howdy do! 

 

Need some help with a Regex expression. I'm taking a column of data that is supposed to contain a number and then a string, and separating them into two columns respectively. The thing is, not every value contains the number at the beginning, and some values have spaces between the number and the string. Some even have decimal numbers at the beginning, which will need to be parsed and kept as a decimal in the output. How do I account for all these whatifs?

 

Alteryx Regex size desc 2.JPGAlteryx Regex size desc 1.JPG

 

1 REPLY 1
Greg_Murray
12 - Quasar

@cdahl001 

 

you can add optional capturing groups with '?'. 

Greg_Murray_0-1607354796743.png

 

Hope that helps,

Greg

 

Labels