Transforms to Remove HTML Tags

[DBattisto]

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!

[richgalloway · Accepted solution]

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.

[DBattisto]

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.