Data Functions

Converts Data to Different Formats. Decodes & Encodes Data into BASE64, Binary, Hex, Dec, Oct
  • BASE64

    Encodes data with MIME base64

    BASE64("This is an encoded string")
    Try this example
    data (string)
    The data to encode.
  • BASE64_DECODE

    Decodes data encoded with MIME base64

    BASE64_DECODE("VGhpcyBpcyBhbiBlbmNvZGVkIHN0cmluZw==")
    Try this example
    data (string)
    The encoded data.
  • BASE64_ENCODE

    Encodes data with MIME base64

    BASE64_ENCODE("This is an encoded string")
    Try this example
    data (string)
    The data to encode.
  • BINDEC

    Binary to decimal.

    BINDEC("110011")
    Try this example
    binary_string (string)
    The binary string to convert. The parameter must be a string. Using other data types will produce unexpected results.
  • DECBIN

    Decimal to binary

    number (number)
    Decimal value to convert
  • DECHEX

    Decimal to hexadecimal

    number (number)
    The decimal value to convert.
  • DECOCT

    Decimal to octal

    DECOCT(264)
    Try this example
    number (number)
    Decimal value to convert
  • FILTER_VAR

    Validates a variable with a specified filter

    FILTER_VAR("[email protected]","validate_email")
    Try this example
    variable (any)
    Value to filte
    filter (string)
    The ID of the filter to apply. Allowed: "boolean", "validate_domain", "validate_email", "float", "int", "validate_ip", "validate_mac_address", "validate_url"
  • HEXDEC

    Hexadecimal to decimal

    HEXDEC("See")
    Try this example
    hex_string (string)
    The hexadecimal string to convert
  • MD5

    Calculate the md5 hash of a string

    MD5("apple")
    Try this example
    str (string)
    The string.
  • NORM_INV

    Returns the value of the inverse normal distribution function for a specified value, mean, and standard deviation.

    NORM_INV(0.75,1,4)
    Try this example
    x (number)
    The input to the normal distribution function.
    mean (number)
    The mean (mu) of the normal distribution function.
  • OCTDEC

    Octal to decimal

    OCTDEC("77")
    Try this example
    octal_string (string)
    The octal string to convert
  • STRCMP

    Binary safe string comparison

    STRCMP("Hello","hello")
    Try this example
    str1 (string)
    The first string.
    str2 (string)
    The second string.