Your Airkit journey starts here
Search

REPLACE

Replace part of a string with a replacement string.

Declaration

REPLACE(base_string, replacement, start, end) -> replaced_string

Parameters

base_string
string -Base string to start with.
replacement
string -string to insert at the insertion point.
start
string -If type is string it is the search string to replace with replacement in the base string. If a number it is the start position (0 based) in the base string to replace.
end
number -This schema species that end is required when start is a number.

Return Values

replaced_string
string -This is the resulting string from taking the base and replacing the search string with the replacement string or from start to end indexes. Replaces only the first index.

← Previous: Reference Tables

Next: Query Expression Syntax →