RegEx Separate Date and time

Question

Hi Team,

How do I parse this field ( V-String) with RegEx

TimeStamp: 2019-03-25 15:02:58-04:00

My Output should be

Date: 2019-03-25

Time: 15:02:58-04:00

Currenlty I am using ([\d]+)([\d]+)

which is returning 201 in Date coloumn and 9 in Time coloumn.

Thanks,

Rana

MarqueeCrew · Accepted Answer

Don't. That's how. If you copy the field to a new time field, you can get just the time. If you then change the type in a select, you can have just a date.

Keep it simple.

https://help.alteryx.com/current/Reference/DataFieldType.htm?Highlight=Data%20types

Cheers,

Mark

rkapoor · Accepted Answer

Hi there

Have a look at playing with these options:

- DateTime Parse tool

- Text to Columns (Crude way to split to the 2 columns you want)

- Use the DateTimeParse function within the Formula tool to parse the date out?

cmcclellan · Accepted Answer

I've never felt comfortable with regex, so my first attempt was this:

Using this code:

(\d\d\d\d-\d\d-\d\d) (\d\d:\d\d:\d\d-\d\d:\d\d)

Then I tried a formula (just to NOT use regex)

But I was hoping there was an easier way, so I did this:

([0-9\-]+) ([0-9\:\-]+)

Which feels like the best answer to me :)