ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. Learn more here
Start Free Trial

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
Top Solution Authors