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.

RegEx expression parse returns a column with empty cells

Roche
8 - Asteroid

 

Hi everyone, 

 

The regex formula that I use to DownloadData1 is not working and I am not sure why.  Can someone show me where I go wrong? 

Roche_1-1649083860053.png

 

Thank you, 

 

Rouche

9 REPLIES 9
binuacs
20 - Arcturus

@Roche would it be possible to provide some sample data and expected result?

jacob_kahn
12 - Quasar

Ya @Roche  - someone will be so willing to help you here; I've seen people respond in minutes. Just got to share a few more details - what is your desired output?

Roche
8 - Asteroid

Hi @jacob_kahn I need the date and also the name "Posting date".

jacob_kahn
12 - Quasar

@Roche Someone might have a better idea but try this syntax - (\d+[/]\d+[/]\d+)

 

 

jacob_kahn
12 - Quasar

A cool thing to note in the RegEx tool is you don't always need to specify the entire text. Just have to isolate the specific pattern you are looking for...I think 💭 🤔 

Roche
8 - Asteroid

Hi @binuacs, yes I can share a sample with you.  Thank you

binuacs
20 - Arcturus

@Roche 

binuacs_0-1649085417285.png

 

Roche
8 - Asteroid

Thank you, that works. Can I adjust this to also output the name "Posting date"?

binuacs
20 - Arcturus

@Roche 

binuacs_0-1649085909212.png

 

 

Labels