We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

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

RegExMatch a date pattern with string

Ultralightbeam
8 - Asteroid

I have this string Arthur Morgan_#_18/01/2021 03:30 PM_#_Date Received_

I just want to get the date of the current string.

4 REPLIES 4
Xeu911
8 - Asteroid

Hi,

Something that works is: "(\d{2}/\d{2}/\d{4})" in a regex tool using the parse method.

Qiu
21 - Polaris
21 - Polaris

@Ultralightbeam 

Hope this is what you need.

0118-Ultralightbeam.PNG

messi007
15 - Aurora
15 - Aurora

@Ultralightbeam,

 

Please see bleow

 

messi007_0-1610959774696.png

_(\d{2}/\d{2}/\d{4})\s.*

 

Hope this hepls,

Regards,

sparksun
11 - Bolide

sparksun_0-1610959960142.png

Is this what you want? if it works for u,pls mark it as a solution.

 

Labels
Top Solution Authors