REPLACE

This page describes the REPLACE function in Lenses SQL.

REPLACE (sourceExpr, targetExpr, replaceExpr)

Returns a new string in which all occurrences of a specified String in the current string are replaced with another specified String.

Available in:

Processors	SQL Studio
✓	✓

Sample code:

# REPLACE IS WITH ISSUE

USE `kafka`;
SELECT 
    REPLACE(status, 'unverified', 'verify urgent') 
FROM users-topic
LIMIT 100;

# Expected keyword FROM

Output:

// Some code