CSV file not extracting properly when there is empty value for a field

satvika — Wed, 16 Dec 2020 15:33:56 GMT

Hi there,

I have a CSV file with the following header and values in it. There are some empty values for a field too. The line which has an empty field value isn't extracting correctly.

Ex: Field1 Field2 Field3 Field4 Field5 Field6 Field7 Field8

abc 123 gfdj 8583 djhcsh jdcjhd dcu jxnchsdi

dabc 1423 ggfdj 98583 kjdcjhd nchsdi sjdkvv

In the example the line 1 is extracting properly, but the line 2 where the field6 is empty isn't extracting properly.

Any help is appreciated. Thanks

My props.conf

[sourcetype]
INDEXED_EXTRACTIONS = CSV
FIELD_DELIMITER=,
HEADER_FIELD_LINE_NUMBER = 1
SHOULD_LINEMERGE = false

Re: CSV file not extracting properly when there is empty value for a field

richgalloway — Wed, 16 Dec 2020 18:02:56 GMT

Can you share the raw form of the CSV (with commas rather than spaces)?

How is line 2 not extracting properly? What are you getting compared to what you expect to get?

topic CSV file not extracting properly when there is empty value for a field in Getting Data In

CSV file not extracting properly when there is empty value for a field

Re: CSV file not extracting properly when there is empty value for a field