1 of 1

DELETEWHITESPACE

This page describes the DELETEWHITESPACE function in Lenses SQL.

DELETEWHITESPACE(expr)

Removes all whitespace from an expression of type string.

Available in:

Processors

SQL Studio

Sample code:

USE `kafka`;
SELECT 
    DELETEWHITESPACE(product_name), 
    product_name 
FROM products-topic
LIMIT 1;

Output:

{
  "value": {
    "DELETEWHITESPACE": "SoftShirt",
    "product_name": "Soft Shirt"
  }
}

This page describes the DELETEWHITESPACE function in Lenses SQL.

DELETEWHITESPACE(expr)

Removes all whitespace from an expression of type string.

Available in:

Processors

SQL Studio

Sample code:

USE `kafka`;
SELECT 
    DELETEWHITESPACE(product_name), 
    product_name 
FROM products-topic
LIMIT 1;

Output:

{
  "value": {
    "DELETEWHITESPACE": "SoftShirt",
    "product_name": "Soft Shirt"
  }
}