How do I replace null values at index time rather than search time?

[jackreeves]

How do I replace null values at index time rather than search time?

Tried adding this to props.conf file but it didn't make a difference.
SEDCMD-replaceblanks = s/,,/,Null,/g

I know I can do a fillnull values function within a search but would rather do this at the point of indexing
Could someone give me some advice?

Many thanks

[adonio]

hello there,

checkout this answer by @somesoni2

https://answers.splunk.com/answers/434015/is-it-possible-to-replace-null-fields-at-index-tim.html

hope it helps

[jackreeves]

I did try this answer before posting but doesn't appear to have worked.

[harsmarvania57]

Can you please provide your props.conf configuration with some sample data ?

[jackreeves]

Here is the props.conf example:

[example]
DATETIME_CONFIG =
INDEXED_EXTRACTIONS = csv
KV_MODE = none
NO_BINARY_CHECK = true
SHOULD_LINEMERGE = false
TIMESTAMP_FIELDS = "Date Closed"
TIME_FORMAT = %d/%m/%Y
category = Structured
pulldown_type = 1
disabled = false
HEADER_FIELD_LINE_NUMBER = 1
SEDCMD-replaceblanks = s/,,/,Null,/g