replace()

Replaces a substring with the specified characters.

replace(string, searchStr, replaceStr)

This function replaces searchStr with replaceStr, then returns the modified string. If any of the parameters are null, then the function returns null. If searchStr is an empty string, the function returns null. This function is case-sensitive.

1replace("Watson, come quickly.", "quickly", "slowly") == "Watson, come slowly."
2replace("Watson, come quickly.", "o", "a") == "Watsan, came quickly."
3replace("Watson, come quickly.", "", "Mr.") == null

j

Overview

Quick Start

Examples

SAQL Reference

SAQL Basic Elements

SAQL Operators

SAQL Statements

SAQL Functions

Aggregate Functions

Date Functions

Time Zone Date Functions

Work with Custom Fiscal Year Data

String Functions

ascii()

chr()

ends_with()

index_of()

len()

lower()

ltrim()

mv_to_string()

number_to_string

replace()

rtrim()

starts_with()

string_to_number

substr()

trim()

upper()

Math Functions

Windowing Functions

coalesce

Query Performance

Previous Versions