All Apps and Add-ons

How do I decode an HTML Encoded Character from a dbxquery?

BP9906
Builder

How do I decode this character in Splunk?

'

I tried | eval decode=urldecode(DESC) and no change.
It's obviously a single quote (apostrophe).

It's just a string field like this:

Splunk's Favorite Color
0 Karma

ddrillic
Ultra Champion

A similar question at alternatives to urldecode

The following table lists the ascii7 characters as HTML entities HTML Codes Table

alt text

The HTML numbers are the Unicode numbers, so a general function should be able to convert the HTML entity to a utf-8 character but I don't see such a function. Meanwhile you can use the way described in the thread -

alt text

0 Karma
Did you miss .conf21 Virtual?

Good news! The event's keynotes and many of its breakout sessions are now available online, and still totally FREE!