Dashboards & Visualizations

How to filter XML in Heavy Forwarder

nagaraju_chitta
Path Finder

Hi Everyone,
Apologies for my post here since I am unable to post a new one question adding in this.
I have tough time to filter the data from my incoming xml in Heavy Forwarder and sending to Indexer.
considering content is my xml tag which need to be removed from the xml data in between the content tags

Below is the REGEx I am using in transforms.conf file

transforms.conf

[remove-content]
REGEX = s/(?s).*(?=<\/content>)<\/content>//
DEST_KEY = queue
FORMAT = nullQueue

Props.conf

[test_transform]
pulldown_type = 1
TRANSFORMS-null = remove-content
DATETIME_CONFIG = 
NO_BINARY_CHECK = true
category = Custom
disabled = false

still unable to achieve the results expected xml to index..googled so many posts and implemented ...but no luck

Tags (2)
0 Karma

somesoni2
Revered Legend

I'm guessing you're trying to strip some content of of your events, not all event. So, you should be using SEDCMD of props.conf, as the transforms that you're trying will remove the whole event

[test_transform]
 pulldown_type = 1
 SEDCMD-remove_content = s/(?s).*(?=<\/content>)<\/content>//
 DATETIME_CONFIG = 
 NO_BINARY_CHECK = true
 category = Custom
 disabled = false
0 Karma

lguinn2
Legend

You can't do a substitution within the REGEX; that is not allowed. Also, you can send entire events to the nullQueue, but not parts of events.

[remove-content]
REGEX=(.*?\<content\>).*?(\</content\>.*)
DEST_KEY=_raw
FORMAT = $1$2

Above, the REGEX captures everything up to and including the <content> tag. The it also captures everything from the </content> tag to the end of the event. It re-writes the raw event, using only the captured pieces of the original event and omitting the characters in between the tags.

0 Karma
Get Updates on the Splunk Community!

New in Observability Cloud - Explicit Bucket Histograms

Splunk introduces native support for histograms as a metric data type within Observability Cloud with Explicit ...

Updated Team Landing Page in Splunk Observability

We’re making some changes to the team landing page in Splunk Observability, based on your feedback. The ...

New! Splunk Observability Search Enhancements for Splunk APM Services/Traces and ...

Regardless of where you are in Splunk Observability, you can search for relevant APM targets including service ...