topic Re: How to extract fields from CSV in Getting Data In

How to extract fields from CSV

Naga — Thu, 30 Sep 2021 12:04:26 GMT

I have a CSV file for ingestion like this. This needs to be monitored via inputs. I dont want to use INDEXED_EXTRACTION= CSV here. Without this I am able to get the feed in successfully. But not able to extract the fields I wanted

File sample

"NAME","AGE","GENDER"

"John","32","MALE"

"ROSE","23","FEMALE"

#props

[mysourcetype]
FIELD_DELIMITER = ,
FIELD_NAMES="NAME","AGE","GENDER"

HEADER_FIELD_LINE_NUMBER=1
HEADER_FIELD_DELIMITER = ,
FIELD_QUOTE = "
HEADER_FIELD_QUOTE = "
DATETIME_CONFIG = CURRENT
SHOULD_LINEMERGE=false
NO_BINARY_CHECK=true

No luck. Any ideas?

Re: How to extract fields from CSV

isoutamo — Thu, 30 Sep 2021 12:30:10 GMT

You should drop FIELD_NAMES as you have already those names in your CSV file and pointed those with HEADER_FIELD_LINE_NUMBER

Re: How to extract fields from CSV

Naga — Thu, 30 Sep 2021 15:18:18 GMT

Thank you @isoutamo . I tried the same Removed FIELD_NAMES And tried as well. But no luck 😞

Re: How to extract fields from CSV

somesoni2 — Thu, 30 Sep 2021 15:27:52 GMT

If you're trying to do search time field extraction for CSV fields, give solution from this post a try:

https://community.splunk.com/t5/Getting-Data-In/splunk-field-extraction-csv/m-p/29894