1 of 1

DIGITS

This page describes the DIGITS function in Lenses SQL.

DIGITS(expr)

Retains only the digits from a string expression.

Available in:

Processors

SQL Studio

Sample code:

USE `kafka`;
SELECT 
    DIGITS(product_sku), 
    product_sku 
FROM products-topic
LIMIT 1;

Output:

{
  "value": {
    "DIGITS": "5021",
    "product_sku": "TOY-502-WH-1"
  }
}

This page describes the DIGITS function in Lenses SQL.

DIGITS(expr)

Retains only the digits from a string expression.

Available in:

Processors

SQL Studio

Sample code:

USE `kafka`;
SELECT 
    DIGITS(product_sku), 
    product_sku 
FROM products-topic
LIMIT 1;

Output:

{
  "value": {
    "DIGITS": "5021",
    "product_sku": "TOY-502-WH-1"
  }
}