Progress
Language Reference


SUBSTITUTE Function

Interfaces
OS
SpeedScript
All
All
Yes

This function returns a character string that is made up of a base string plus the substitution of arguments in the string. It allows you to use a single string in place of concatenated strings. It is designed to simplify the task of translating an application from one language to another. This function is similar to the sprintf function of the C programming language.

SYNTAX

SUBSTITUTE ( base-string [ , arg ] ... ) 

base-string

A character string optionally containing substitution parameters of the form &n, where n is an integer between 1 and 9, inclusive.

arg

A constant, field name, variable, or expression that results in a character string value. These argument values replace substitution parameters in base-string.

EXAMPLES

These statements display the same message.

MESSAGE SUBSTITUTE("There were &1 records in &2 tables", 
  rec-count, table-count). 

MESSAGE "There were" rec-count "records in" 
  table-count "tables". 

You can alter the position of the substitution parameters, as in this statement.

SUBSTITUTE("&2 comes before &1", "Friday", "Monday"). 

NOTES

SEE ALSO

REPLACE Function


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