Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask 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