How to separate date and time

[rmartinez4]

Hi it possible to show how to separate the date and time.

Last Seen Date
2022-08-17 13:15:46GMT
2022-08-17 14:50:01GMT
2022-08-17 06:30:06GMT

Last Seen Date - Zscaler      Time
2022-08-17                          13:15:46GMT
2022-08-17                          14:50:01GMT
2022-08-17                          06:30:06GMT

[rmartinez4]

Hi Phil,

By any chance can you assist me separating this Date time 24 Jun 2022 02:51AM GMT-0400. I don't required the GMT-0400 information. 

Thank You

[DavidSkaife · Accepted solution]

Hi @rmartinez4 

One way of doing it using Regex Tool, with this expression and parsing as the output:

(\d+\s[[:alpha:]]+\s\d{4})\s(\d{2}\:\d{2}\u{2})