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
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
I did try this answer before posting but doesn't appear to have worked.
Can you please provide your props.conf configuration with some sample data ?
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