Splunk Search

CSV Ingestion

nags
Engager

I have CSV File with delimiter "|" like sample below for new ingestion. I wanted to use standard sourcetype csv. But standard:csv is having "," as delimiter. Can we add more than one delimiter in FIELD_DELIMITER attribute? If so how can do that. Or for the below one do we need to define other sourcetype with separate individual delimiter

I tried this FIELD_DELIMITER=",||" but not working

name|age|class

john|9|first

bob|10|second

Could you please help 

Labels (1)
0 Karma
1 Solution

richgalloway
SplunkTrust
SplunkTrust

You're trying to use the standard CSV sourcetype with a non-standard CSV file.  That's not likely to work.

The FIELD_DELIMITER setting takes a single character as its value.  In this case, the value should be "|".  IIRC, this setting applies only if INDEXED_EXTRACTIONS is set.  Using INDEXED_EXTRACTIONS = PSV should handle file without the need for FIELD_DELIMITER.

---
If this reply helps you, Karma would be appreciated.

View solution in original post

0 Karma

richgalloway
SplunkTrust
SplunkTrust

You're trying to use the standard CSV sourcetype with a non-standard CSV file.  That's not likely to work.

The FIELD_DELIMITER setting takes a single character as its value.  In this case, the value should be "|".  IIRC, this setting applies only if INDEXED_EXTRACTIONS is set.  Using INDEXED_EXTRACTIONS = PSV should handle file without the need for FIELD_DELIMITER.

---
If this reply helps you, Karma would be appreciated.
0 Karma
Get Updates on the Splunk Community!

Enterprise Security Content Update (ESCU) | New Releases

In December, the Splunk Threat Research Team had 1 release of new security content via the Enterprise Security ...

Why am I not seeing the finding in Splunk Enterprise Security Analyst Queue?

(This is the first of a series of 2 blogs). Splunk Enterprise Security is a fantastic tool that offers robust ...

Index This | What are the 12 Days of Splunk-mas?

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