Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more 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
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