v.23.9New Feature

Add decodeHTMLComponent function

Official CH changelog text
Add function decodeHTMLComponent. #54097 (Bharat Nallan).
Introduces the decodeHTMLComponent function to ClickHouse for decoding HTML-encoded components.

Why it matters

The decodeHTMLComponent function solves the problem of handling and decoding HTML-encoded strings within ClickHouse queries, allowing users to easily convert HTML entities back to their original characters. This improves data processing and cleaning workflows where input data contains HTML-encoded content.

How to use it

Use the decodeHTMLComponent function in your SQL queries to decode HTML-encoded strings. For example:

SELECT decodeHTMLComponent('<>') AS decoded_string
FROM some_table

Related resources

PreviousNext