Splunk Search

How does Splunk handle data with comma separated fields containing zero values

Starlette
Contributor

For example

DATA test1, test2, test3

so just add the DELIMS = "," in transforms and REPORT-test entry in props.conf

REPORT-test name1,name2,name3 I expect the KV's extracted :

name1=test1 name2=test2 name3=test3

BUT what if the data looks like :

test1, "" , test3

can i expect :

name1=test1 name3=test3

OR

name1=test1 name2=test3

(not what i wanted of course)

Tags (2)
0 Karma

Lowell
Super Champion

You should have no problem with missing values like this with the default delimiter-based extractions.

BTW. I'm not sure if you intended to provide your literal props.conf entry or not. But what you have shown will not work as is.

I assuming that you have the following:

transforms.conf:

[test]
DELIMS = ","
FIELDS = "name1", "name2", "name3"

props.conf

[my_source_type]
REPORT-test = test

gkanapathy
Splunk Employee
Splunk Employee

it will treat CSVs correctly.

0 Karma
Get Updates on the Splunk Community!

Routing logs with Splunk OTel Collector for Kubernetes

The Splunk Distribution of the OpenTelemetry (OTel) Collector is a product that provides a way to ingest ...

Welcome to the Splunk Community!

(view in My Videos) We're so glad you're here! The Splunk Community is place to connect, learn, give back, and ...

Tech Talk | Elevating Digital Service Excellence: The Synergy of Splunk RUM & APM

Elevating Digital Service Excellence: The Synergy of Real User Monitoring and Application Performance ...