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 problem

MostafaBouzari
8 - Asteroid

Hello guys,

I'm trying to get the information from a string like this 

 

 

Nutella 01_2017
Nutella01_2017

 

 

using Regex tool and output mode Parse with this Regular Expression 

 

 

([\0-9\_]*)|([A-Za-z]*)

 

and also This one 

(\d+\_\d+)|([A-Za-z]+)

 but i can't get the good resualt  

How can i achieve this?

(The Space between nutella and the date was deleted by a Cleansing tool which can get ignored)

3 REPLIES 3
MarqueeCrew
20 - Arcturus
20 - Arcturus

@MostafaBouzari ,

 

Please try using a formula like:

(\l+)\s*(\d.*)

It will find letters followed by 0 or more spaces followed by a digit followed by anything.

 

capture.png

 

Cheers,

 

Mark

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
MostafaBouzari
8 - Asteroid

thank's for your help I use this Website  to check if my regex works and there is a Language selection option which language should i use (e.g : PHP,Python,Java Script)?

 

Or if you have a better website or tool to share with us please let us know 

 

Regards

MarqueeCrew
20 - Arcturus
20 - Arcturus

i do like regex101.com.  there is also regexr.com.  i do like playing with regex simply using the formula tool too.

 

cheers,

 

Mark

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
Labels