Contents | Index | < Browse | Browse >

---

usage: TRANSLATE(string[,output][,input][,pad])

-constructs a translation table for character substitution in a string
-translates to uppercase if only string is given
-if given, characters in the input table are converted to the corresponding
characters in the output table
-characters beyond the end of the output table are replaced with blanks or
the specified pad character
-the result string is alway the same length as the original string
-input and output tables may be any length
-example: translate('abcde','123','cbade','+') ===> 321++