SAP TRANSLATE FUNCTIONS documentation, setup help and example usage

ARTICLE

translate - Translate Function

Syntax
... translate( val = text from = from to = to ) ...

Effect
This function returns the character string from text with each character that occurs in from replaced by the character that occurs in the same place in to as in from . If to is shorter than
from , the surplus characters from from are removed from the character string. If from is an empty string, the content of
text is returned unchanged.
from and to are
character-like expression positions . If they have a fixed length, trailing blanks are ignored.
The return code has the type string .

Example
The return value of the following function call is "Horray!" .
result = translate( val = `---Hur-rah!---` from = `uh-` to = `oy` ).

Documentation extract taken from SAP system, � Copyright SAP AG. All rights reserved