CSV Ingestion

nags — Fri, 11 Aug 2023 12:37:48 GMT

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

Re: CSV Ingestion

richgalloway — Fri, 11 Aug 2023 14:52:25 GMT

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.

topic CSV Ingestion in Splunk Search

CSV Ingestion

Re: CSV Ingestion