Getting Data In

How do I remove field data before indexing?

Path Finder

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 - *******


field name in work_Notes

Note: I tried the null

In Props.conf

TRANSFORMS-null= tasknull


FIELDS = work_Notes
DEST_KEY = queue
FORMAT = nullQueue

Thanks in advance.

0 Karma

Splunk Employee
Splunk Employee

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!

0 Karma

Ultra Champion

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.

0 Karma

Super Champion

You can replace the other portion of the events with blank during index time, so only the necessary information gets logged.

0 Karma
Get Updates on the Splunk Community!

Splunk APM & RUM | Upcoming Planned Maintenance

There will be planned maintenance of Splunk APM’s and Splunk RUM’s streaming infrastructure in the coming ...

Part 2: Diving Deeper With AIOps

Getting the Most Out of Event Correlation and Alert Storm Detection in Splunk IT Service Intelligence   Watch ...

User Groups | Upcoming Events!

If by chance you weren't already aware, the Splunk Community is host to numerous User Groups, organized ...