Splunk Search

splunk delimeter setup

splunk_gs
Explorer

i have a txt file that is seperated by semicolons ";" that i am sending via TCP. How do i set it up to where i can assign each seperation with a field? i tried doing it through the web manager but it wouldnt extract the fields.

This wouldn't work:
props.conf:
[xxx_fields]
DELIMS=";"
FIELDS = "x1", "x2", "x3", "x4", "x5", "x6", "x7", "x8", "x9"

Example would be:
Header
x1;x2;x3;x4;x5;x6;x7;x8;x9

Raw Fields
x;x;x;x;x;x;x;x;x

Basically i just want to be able to search by the header fields...please help

0 Karma

Ayn
Legend

The DELIMS/FIELDS settings should go in transforms.conf, not props.conf. In props.conf you put a stanza that defines which data this should apply to, for instance by specifying a sourcetype, source or similar, and also a REPORT directive that refers to the transform containing the DELIMS/FIELDS settings.

EDIT: An example:

Let's say the logs you want to apply this to have sourcetype "my_sourcetype". In props.conf, you would put:

[my_sourcetype]
REPORT-getfields = mysourcetype_fields

In transforms.conf, put:

[mysourcetype_fields]
DELIMS=";"
FIELDS = "x1", "x2", "x3", "x4", "x5", "x6", "x7", "x8", "x9"

Fields should now be extracted for events with the sourcetype "my_sourcetype".

0 Karma

Ayn
Legend

Updated my answer with an example.

0 Karma

splunk_gs
Explorer

can you give me an example please?

0 Karma
Got questions? Get answers!

Join the Splunk Community Slack to learn, troubleshoot, and make connections with fellow Splunk practitioners in real time!

Meet up IRL or virtually!

Join Splunk User Groups to connect and learn in-person by region or remotely by topic or industry.

Get Updates on the Splunk Community!

Recap | Agentic Operations Start with Context: Build the Right Data Foundation

Agentic Operations Start with Context: Build the Right Data Foundation   By Courtney Wright, Product Marketing ...

Recap | Assisted, Augmented or Agentic? Choose Your Splunk Starting Point

Assisted, Augmented or Agentic? Choose Your Splunk Starting Point   By Courtney Wright, Product Marketing ...

Session 2 | Beyond the Thread: Operationalizing AI with Confidence

Session 2   Beyond the Thread: Operationalizing AI with Confidence    The true power of the Cisco Data Fabric ...