Important Community update: The process for changing your account details was updated on June 25th. Learn how this impacts your Community experience and the actions we suggest you take to secure your account here.

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