topic Re: How do I remove field data before indexing? in Getting Data In

How do I remove field data before indexing?

SathyaNarayanan — Tue, 29 Sep 2020 21:24:56 GMT

Hi Team,

I need to remove a field data before the data gets indexed to Splunk.

The field that needs to be removed is in between the log and it has several lines.

sample data:

dv_u_business_duration_in_seconds="",closed_by="",sys_created_by="",sys_domain_path="/",dv_business_duration="",dv_work_notes="2018-08-05 09:46:09 - *******

active="true",dv_made_sla="true",additional_assignee_list="",delivery_task=""

field name in work_Notes

Note: I tried the null

In Props.conf

[sourcetype:test_task]
TRANSFORMS-null= tasknull

transforms.conf

[tasknull]
FIELDS = work_Notes
DEST_KEY = queue
FORMAT = nullQueue

Thanks in advance.

Re: How do I remove field data before indexing?

493669 — Sun, 30 Sep 2018 11:57:41 GMT

You can replace the other portion of the events with blank during index time, so only the necessary information gets logged.
http://docs.splunk.com/Documentation/Splunk/6.2.4/Data/Anonymizedatausingconfigurationfiles#Anonymize_data_through_a_sed_script

Re: How do I remove field data before indexing?

ddrillic — Sun, 30 Sep 2018 20:46:50 GMT

These name value pairs are extracted at search time, not index time.

Btw, props.conf might have been -

[<sourcetype name>]
TRANSFORMS = tasknull

Suppressing the name value pairs extraction at search time can be done via the explanations at Disable Automatic Field Extraction or How to avoid extracting fields from quoted values?

Unfortunately, it requires disabling the extractions by KV_MODE=none in props.conf in the search heads and creating your own extractions.

Re: How do I remove field data before indexing?

mstjohn_splunk — Mon, 01 Oct 2018 19:26:50 GMT

hi @SathyaNarayanan

Did the answer below solve your problem? If so, please resolve this post by approving it!
If your problem is still not solved, keep us updated so that someone else can help ya. Thanks for posting!