Translates characters within a string as specified. Enrichment translates the first character in input to output, then the second, then the third, and so on.
Syntax
TRANSLATE(string,input,output)
Arguments
| Argument |
Description |
Default |
| string |
The string to translate. |
None |
| input |
One or more characters within string to translate. |
None |
| output |
One or more characters to translate input to. If input and output are not equal in size, conversion ends at the end of the shortest string. |
None |
Results
| Result |
Description |
| Return |
string with input translated to output. |
| %%RC |
One of the following: |
| |
1 |
Size of input and/or output is 0. |
| |
0 |
No error. |
| %%RM |
A null string (''). |
| %%RV |
Always set to 0. |
Examples
| Function Call |
Return |
%%RC |
TRANSLATE('password','s','*') |
'pa**word' |
0 |
TRANSLATE('1234567890','13579','**+**') |
'*2*4+6*8*0' |
0 |
TRANSLATE('aabbccdd','bacd','bbaaccdd') |
'bbbbaaaa' |
0 |