Splunk Enterprise

Removing header from CSV file

krish5vuda
Engager
  • I have a CSV file placed in a UF and the CSV data is as follows

'"Name" "userid" "use location" "userdesignation"'

Raj raj-123 Argentina Consultant 

Now  I have written props and transforms as below but still the header is being ingested 

 

Props:

[Sourcetype]

Should_linemerge=false 

Line_Breaker=([\r\n]+)

NO_BINARY_CHECK=true 

CHARSET= UTF-8 

INDEXED_EXTRACTIONS=CSV 

category=structured 

description=Comma-separated value format. Set header and other settings in "Delimited Settings"

disabled=false

TRUNCATE=99999

DATETIME_CONFIG=CURRENT

KV_MODE=none 

HEADER_FIELD_LINE_NUMBER=1 

TRANSFORMS-set=setnull 

 

 

Transforms.conf 

[setnull]

REGEX=(^"NAME".*$) |(^\'\"NAME\".$)

DEST_KEY=queue 

FORMAT=nullQueue 

Please let me know what changes has to be made so that header is not being ingested 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Labels (1)
0 Karma

isoutamo
SplunkTrust
SplunkTrust

Have you try this on UF? In UF you cannot use transforms.con and actually you shouldn’t need it as you told that headers are in first row in file. And remember to restart UF after put props.conf there. 

0 Karma

krish5vuda
Engager

This conf are  in indexer and not in UF

0 Karma

isoutamo
SplunkTrust
SplunkTrust

He is instructions where those files should be in different cases https://wiki.splunk.com/Community:HowIndexingWorks and https://www.aplura.com/assets/pdf/where_to_put_props.pdf. 

0 Karma
Get Updates on the Splunk Community!

How to Monitor Google Kubernetes Engine (GKE)

We’ve looked at how to integrate Kubernetes environments with Splunk Observability Cloud, but what about ...

Index This | How can you make 45 using only 4?

October 2024 Edition Hayyy Splunk Education Enthusiasts and the Eternally Curious!  We’re back with this ...

Splunk Education Goes to Washington | Splunk GovSummit 2024

If you’re in the Washington, D.C. area, this is your opportunity to take your career and Splunk skills to the ...