Amazon QuickSight
User Guide

The AWS Documentation website is getting a new look!
Try it now and let us know what you think. Switch to the new look >>

You can return to the original look by selecting English in the language selector above.

replace

replace replaces part of a string with another string that you specify.

Syntax

replace(expression, substring, replacement)

Arguments

expression

The expression must be a string. It can be the name of a field that uses the string data type, a literal value like '12 Main Street', or a call to another function that outputs a string.

substring

The set of characters in expression that you want to replace. The substring can occur one or more times in expression.

replacement

The string you want to have substituted for substring.

Return Type

String

Example

The following example replaces the substring 'and' with 'or'.

replace('1 and 2 and 3', 'and', 'or')

The following string is returned.

1 or 2 or 3