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

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. 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.

EXAMPLE

To replace every occurrence of the text “PSC” with “Progress Software Corp.” in a character field named Comment, create a field containing this expression:

REPLACE(Comment,"PSC","Progress Software Corp.") 


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095