REPLACE function

Returns a string with specified substring replacements. The data type of the returned value matches the data type of the expression passed to the function.

Syntax

REPLACE ( source-string , from-string , to-string )
source-string
Specifies the base string to make replacements in. The source-string parameter can be any expression that evaluates to a string or a LONGCHAR. The REPLACE function does not change the value of source-string itself; the function returns the string with replacements.
from-string
Specifies the substring to replace. The from-string parameter can be any expression that evaluates to a string or a LONGCHAR. Each occurrence of from-string within source-string is replaced.
to-string
Specifies the replacement substring. The to-string parameter can be any expression that evaluates to a string or a LONGCHAR. Each occurrence of from-string in source-string is replaced by to-string.

Example

The following example uses the REPLACE function to replace the string "user" with an actual user ID, if available:

r-repl.p

DEFINE VARIABLE greeting AS CHARACTER NO-UNDO FORMAT "x(40)"
  INITIAL "Starting user's session . . . ".

IF USERID("DICTDB") < > "" THEN 
  greeting = REPLACE(greeting, "user", USERID("DICTDB")).
DISPLAY greeting WITH NO-LABELS.

Notes

See also

OVERLAY statement, SUBSTITUTE function, SUBSTRING function