Progress
Report Builder
User’s Guide
REPLACE
Replaces each occurrence of a character substring with another and returns the full character string. You identify the substring by its contents, not by specifying the start position and length.
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.
EXAMPLETo replace every occurrence of the text “PSC” with “Progress Software Corp.” in a character field named Comment, create a field containing this expression:
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |