Progress
Language Reference
REPLACE Function
Returns a string with specified substring replacements.
SYNTAX
source-string
Specifies the base string to make replacements in. The source-string parameter can be any expression that evaluates to a string. 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. 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. Each occurrence of from-string in source-string is replaced by to-string.
EXAMPLEThe following example uses the REPLACE function to replace the string “user” with an actual user ID, if available.
NOTES
- The REPLACE function replaces all occurrences of from-string within source-string. After replacing a substring, the REPLACE function resumes searching the string after the inserted text. Thus, the inserted text is not recursively searched (in whole or in part) for from-string.
- The search for occurrences of from-string within source-string is not case sensitive, unless one of the three values used in the function (source-string, to-string, or from-string) is a case-sensitive field or variable.
SEE ALSO
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |