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