Skip to main content

​
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 the csvescape options are output from the sample CSV document.
Running this code displays the following output for the first row under the CSV headers.

​
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, or base64. The default is utf-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, or base64. The default is utf-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, or base64. The default is utf-8.

​
sqlescape()

Converts the attribute value to an SQL-escaped, single-line string.
  • dbtype: The database type to encode. The allowed values are SQL or SQLite. The default is SQL.

​
urldecode()

Converts the attribute value to a URL-decoded string.

​
urlencode()

Converts the attribute value to a URL-encoded string.

​
xmldecode()

Converts the attribute value to a XML-decoded string.

​
xmlencode()

Converts the attribute value to a XML-encoded string.