Archive

Trying to change date

maheshsat
Explorer

index=_internal | eval Mahesh=replace(date, "^(\d{1,2})/(\d{1,2})/", "\2/\1/")

My date 03-16-2018 I need 16-03-2018

Tags (1)
0 Karma
1 Solution

elliotproebstel
Champion

I notice that your sample dates have dashes, while your attempted regex uses slashes. How about this:

index=_internal
| eval Mahesh=replace(date, "^(\d{1,2})-(\d{1,2})-", "\2/-1-")

View solution in original post

0 Karma

maheshsat
Explorer

Thanks It did work but small correction, below correct syntex.

index=_internal | eval Mahesh=replace(Date, "^(\d{1,2})-(\d{1,2})-"," \2-\1-")

0 Karma

elliotproebstel
Champion

I notice that your sample dates have dashes, while your attempted regex uses slashes. How about this:

index=_internal
| eval Mahesh=replace(date, "^(\d{1,2})-(\d{1,2})-", "\2/-1-")

View solution in original post

0 Karma
Take the 2021 Splunk Career Survey

Help us learn about how Splunk has
impacted your career by taking the 2021 Splunk Career Survey.

Earn $50 in Amazon cash!