Splunk Search

Date format

efelder0
Communicator

I am having an issue with outputting a Date/Time stamp. Here is the scenario:

  • Indexing a CSV file containing a field "Current_Date"
  • In my output file, I am concatenating that "Current_Date" field with the Splunk _indextime into a field called "CreateTimeStamp"
  • However, this is my output --> Current_Date value is '1', _indextime = "15:40". Need it to look like "10/14/2012 15:40"

Snippet from prop.conf:
SHOULD_LINEMERGE = false

BREAK_ONLY_BEFORE = \d{1,3}.\d{1,3}.\d{1,3}.\d{1,3}

TIME_PREFIX = ^([^,]+,){9}
TIME_FORMAT = %m/%d/%Y %H:%M

LINE_BREAKER = ([\r\n]+)[A-Z0-9-]+,

REPORT-csvepo3 = csvepo3
TRANSFORMS-removeheader4 = removeheader4

Snippet from transforms.conf:

[removeheader4]
REGEX = ^System_Name,Last_Comm,Last_Comm_Diff
DEST_KEY = queue
FORMAT = nullQueue

Any suggestions?

Tags (1)
0 Karma
1 Solution

efelder0
Communicator

further modifications to the transforms.conf fixed the issue.

View solution in original post

0 Karma

efelder0
Communicator

further modifications to the transforms.conf fixed the issue.

0 Karma
Get Updates on the Splunk Community!

[Puzzles] Solve, Learn, Repeat: Character substitutions with Regular Expressions

This challenge was first posted on Slack #puzzles channelFor BORE at .conf23, we had a puzzle question which ...

Shape the Future of Splunk: Join the Product Research Lab!

Join the Splunk Product Research Lab and connect with us in the Slack channel #product-research-lab to get ...

Auto-Injector for Everything Else: Making OpenTelemetry Truly Universal

You might have seen Splunk’s recent announcement about donating the OpenTelemetry Injector to the ...