Alteryx Designer Desktop Discussions

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

Extract Date in string using regex

RichardAlt
Asteroide

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 RESPOSTAS 2
LordNeilLord
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

 

Enquetes
We’re dying to get your help in determining what the new profile picture frame should be this Halloween. Cast your vote and help us haunt the Community with the best spooky character.
Don’t ghost us—pick your favorite now!
Rótulos