base64decode()
Converts the attribute value to a base 64 decoded string.base64encode()
Converts the attribute value to a Base64-encoded string.csvescape()
Returns CSV data from the column that matches a value with each element output as individual results.Example
In the following example, both the csv function and thecsvescape options are output from the sample CSV document.
jsonescape()
Converts the attribute value to a JSON-escaped, single-line string.md5hash([converttobase64])
Computes the MD5 hash of the attribute value.- encodetobase64: The optional boolean value that specifies whether to convert the result into a Base64-encoded string. The default is
true. - inputencoding: The optional string that specifies the input encoding. The allowed values are
utf-8,hex, orbase64. The default isutf-8.
sha1hash([converttobase64])
Computes the SHA-1 hash of the attribute value.- encodetobase64: The optional boolean value that specifies whether to convert the result into a Base64-encoded string. The default is
true. - inputencoding: The optional string that specifies the input encoding. The allowed values are
utf-8,hex, orbase64. The default isutf-8.
sha2hash([converttobase64])
Computes the SHA-2 hash of the attribute value.- encodetobase64: The optional boolean value that specifies whether to convert the result into a Base64-encoded string. The default is
true. - inputencoding: The optional string that specifies the input encoding. The allowed values are
utf-8,hex, orbase64. The default isutf-8.
sqlescape()
Converts the attribute value to an SQL-escaped, single-line string.- dbtype: The database type to encode. The allowed values are
SQLorSQLite. The default isSQL.