Splunk Search

Transforms to Remove HTML Tags

DBattisto
Communicator

Hello-

I'm importing data from a SQL database that includes HTML tags. Here is an example:

NoteText="This is my first sentence. This is <strong>bold test</strong></br> 
<p>Second Line</p>
<p> </p>
<p>new line</p>

I'm looking for a way to utilize transforms and props OR regex in the search to remove any HTML tags and just display the data as such. I've used these methods for removing XML tags, but those were symmetrical and structured, I'm not familiar with how to do it for random tags throughout.

Thanks!

0 Karma
1 Solution

richgalloway
SplunkTrust
SplunkTrust

You can do that at search time with rex. This regex is pretty basic and doesn't handle stray < characters, but may be suitable for your needs.

... | rex mode=sed "s/(\<[^>]+>)//g" | ...

You can use SEDCMD in props.conf to do the same thing.

---
If this reply helps you, an upvote would be appreciated.

View solution in original post

richgalloway
SplunkTrust
SplunkTrust

You can do that at search time with rex. This regex is pretty basic and doesn't handle stray < characters, but may be suitable for your needs.

... | rex mode=sed "s/(\<[^>]+>)//g" | ...

You can use SEDCMD in props.conf to do the same thing.

---
If this reply helps you, an upvote would be appreciated.

DBattisto
Communicator

Thanks, I figured this out shortly after posting that it'd be easiest for implementing it this way, and for a specific field:

index=index1
| rex mode=sed field=FieldName3 "s/(<.*?>)//g"
| table FieldName1, FieldName2, FieldName3

The only think to watch out for is if someone puts text between '<>', it'll be omitted from the text. Doesn't look like that'll impact this application here.

0 Karma
Get Updates on the Splunk Community!

Improve Your Security Posture

Watch NowImprove Your Security PostureCustomers are at the center of everything we do at Splunk and security ...

Maximize the Value from Microsoft Defender with Splunk

 Watch NowJoin Splunk and Sens Consulting for this Security Edition Tech TalkWho should attend:  Security ...

This Week's Community Digest - Splunk Community Happenings [6.27.22]

Get the latest news and updates from the Splunk Community here! News From Splunk Answers ✍️ Splunk Answers is ...