In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

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