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

Extract Date in string using regex

RichardAlt
8 - Asteroid

Hi Guys,

 

How can I extract the date from a string using regex?

This is my sample text,

AXSI,CADB,DBSI,EFT 31/03/20
CHQ,CSH 31/03/20
NETS,CA 31/03/20
REF UL 31/03/20  TR

I want something like this,

AXSI,CADB,DBSI,EFT31/03/20
CHQ,CSH 31/03/20
NETS,CA 31/03/20
REF UL TR31/03/20
2 REPLIES 2
LordNeilLord
15 - Aurora

Hey @RichardAlt 

 

You can use the regex tool in Parse mode with the pattern (\d{2}/\d{2}/\d{2})

DavidP
17 - Castor
17 - Castor

This is how I would do it

 

DavidP_0-1595578533103.png

 

Labels