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
20 - Arcturus
20 - Arcturus

@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