translate

Translates a character string.

Available in:

Apps (win) Apps (char) Reportwriter RPC Standalone PL
X X X X X

Syntax

string translate(data,from,to)
string           data,from,to

Description

Replaces all characters in data as specified. If the number of characters in to is a multiple of the number of characters in from, for each character in from, that multiple of characters from to replaces that single character. If to is empty, all characters found in from are deleted.
data specifies the string to translate.
from specifies the characters to replace.
to specifies new characters to use.

Example

Replace all digits with asterisk (*).
field = translate(SAL,"0123456789","**********");
Replace all nulls with a record separator. Multi-line Oracle error messages are dlimited by NULL. Some TRIMpl functions, e.g. tokenize, do not accept NULL as a separator.
buf = translate(db_msg(),chr(0),chr(30));
Replace all single quotes with two single quotes (useful for SQL INSERT commands).
exec_sql(translate(sqlstmt,"'","''"));
Delete all commas from character representation of numerics.
buf = translate(line,",","");
Validate that a string contains only uppercase letters.
if (translate(line,"ABCDEFGHIJKLMNOPQRSTUVWXYZ","") != "")
  error("Line may only contain letters");