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
Get Updates on the Splunk Community!

More Ways To Control Your Costs With Archived Metrics | Register for Tech Talk

Tuesday, May 14, 2024  |  11AM PT / 2PM ET Register to Attend Join us for this Tech Talk and learn how to ...

.conf24 | Personalize your .conf experience with Learning Paths!

Personalize your .conf24 Experience Learning paths allow you to level up your skill sets and dive deeper ...

Threat Hunting Unlocked: How to Uplevel Your Threat Hunting With the PEAK Framework ...

WATCH NOWAs AI starts tackling low level alerts, it's more critical than ever to uplevel your threat hunting ...