Category:

Miscellaneous

Replaces all occurrences of a substring in a string with another substring.

Syntax

string_replace(
  Str String,
  SubStr String,
  NewSubStr String
): String

Parameters

Str is the source string.

SubStr is the substring to replace.

NewSubStr is the string that will be inserted instead of the found substring.

Return value

Type: String. Returns the resulting string.

Examples of using

string_replace(dataset_field_val(1, 'Address'), 'str.', '')