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!

Upcoming Webinar: Unmasking Insider Threats with Slunk Enterprise Security’s UEBA

Join us on Wed, Dec 10. at 10AM PST / 1PM EST for a live webinar and demo with Splunk experts! Discover how ...

.conf25 technical session recap of Observability for Gen AI: Monitoring LLM ...

If you’re unfamiliar, .conf is Splunk’s premier event where the Splunk community, customers, partners, and ...

A Season of Skills: New Splunk Courses to Light Up Your Learning Journey

There’s something special about this time of year—maybe it’s the glow of the holidays, maybe it’s the ...