CSV Ingestion

[nags]

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 

[richgalloway · Accepted solution]

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.