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

Parsing with RegEx

dholder15
7 - Meteor

Hi, 

I'm trying to use RegEx to separate the following B185661B Chips Ahoy Valley Tees. I would like it to be one column has the B185661B and the other column has the Chips Ahoy Valley Tees. Please let me know if this is possible. The excel file is attached. 

5 REPLIES 5
messi007
15 - Aurora
15 - Aurora

@dholder15,

 

Please see below :

 

messi007_0-1683810411826.png

 

Attached the workflow, hope this helps!

Regards,

DataNath
17 - Castor

@dholder15 is there a reason this needs to be done with RegEx i.e. is there a certain pattern you're looking for? From your example it looks like you may just be splitting a product name from a code that's the first word? If so, you can just use a simple solution like so:

 

DataNath_0-1683810514732.png

 

Splitting the field in 2 based on the first space (\s delimiter).

RobertOdera
13 - Pulsar

Hi, @dholder15 

 

Here's another way for your use case - to expand your options beyond Regex😎

 

I hope you find it helpful - Cheers!

 

RobertOdera_0-1683811981518.png

 

dholder15
7 - Meteor

Thank you so much! That helped out tremendously

RobertOdera
13 - Pulsar

You're most welcome @dholder15!

Labels