Alteryx Designer Desktop Discussions

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

Need some help with a RegEx pattern (example below)

AkisM
10 - Fireball

My data looks like this:

 

Column1

 

, m. 05/31/2022
, m. 01/12/2021
, m. 09/12/2022

 

I need a regex command that splits this into 2 capture groups:  1. ", m. "

                                                                                                     2. "09/12/2022"

 

I tried this expression ([,\s m.])(\d{2}\/\d{2}\/\d{4}) but it gives me only the date from the 2nd capture group. Nothing captured from the first group. Any ideas?

 

 

2 REPLIES 2
AkisM
10 - Fireball

Nevermind, got it. It should be (\,\s\w\.\s)(\d{2}\/\d{2}\/\d{4})

MichalM
Alteryx
Alteryx

In this case you could also use the below

 

(.+)(\d{2}\/\d{2}\/\d{4})
Labels