Alteryx Designer Desktop Discussions

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

Date Extract

KamenRider
11 - Bolide

Hi,

 

Can someone help me get the date 05.20.24?

 

05.20.24 Porres Beerend Holiday Luck Exp Date Report

 

Thanks,

Kamen

 

2 REPLIES 2
alexnajm
17 - Castor
17 - Castor

RegEx_Replace([Field], "(\d\d\.\d\d\.\d\d).+", "$1")

JBLove
10 - Fireball

@KamenRider  - 

 

You can use a regex tool with the Parse output method selected.  The following expression will retrieve the date value(05.20.24) from the string: "05.20.24 Porres Beerend Holiday Luck Exp Date Report"

 

(\d+\.\d+.\d+)\s.+

 

If you're not familiar with regex, the parenthesis creates a marked grouping, and for these purposes that represents the new field extracting the date format out.

 

\d+ represents 1 or more digits

\. represents a single "."

\s represents a single whitespace

.+ represents 1 or more any character

 

Labels