Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
The Expert Exam is now live online! Read about the specifics and what it took to bring it to life in the blog by our very own Elizabeth Bonnell!

Regex timestamps

Highlighted
8 - Asteroid

I have a regex expression that parses text for a timestamp in the form of dd/mm/yyyy hh:mm:ss AM/PM.  The expression is as follows:

(\d{1,2}/\d{2}/\d{4}\s\d{1,2}:\d{1,2}:\d{1,2}\s.m)

This works great and I want to get all Time stamps in the string however when there is multiple timestamps, it also returns all the text in between the stamps.  Can anyone help me with this? I want to get the timestamps only.  Example, here is what I currently get from the above expression

9/30/2020 10:36:00 AM This can be any amount of text 9/24/2020 9:10:49 AM

 This is what I am trying to get, 

9/30/2020 10:36:00 AM
9/24/2020 9:10:49 AM

 

Highlighted
16 - Nebula
16 - Nebula

If you use the Regex tool in tokenise mode, it would allow you break out all the timestamps to rows.

 

I'd tweak expression to:

\d{1,2}/\d{1,2}/\d{4} \d{1,2}:\d{1,2}:\d{1,2} [AP]M

 

 Attached example

Labels