Modify a date field value using SED

[jason_hotchkiss]

I have a weird date/time value:  20240307105530.358753-360

I would like to make it more user friendly  2024/03/07 10:50:30 and drop the rest.
%Y/%m/%d %H:%M:%S

I know you can use sed for this, however, I am not familiar with sed syntax:

For example:
| rex mode=sed field=_raw "s//g"

Any sed guru's out there?

[marnall · Accepted solution]

You can indeed do this with sed and rex:


| rex mode=sed field=<yourfield> "s/(\d{4})(\d{2})(\d{2})(\d{2})(\d{2})(\d{2}).*/\1\/\2\/\3 \4:\5:\6/"

Every captured group in the first part of the sed can be referenced with a backslash+groupnumber. E.g: "\1" for group 1, "\2" for group 2. Everything not captured can be discarded. Forward slashes need to be escaped.

[jason_hotchkiss]

Thank you @marnall.  You are the master!

[marnall]

Glad to help 🙂