Application: gvSIG desktop

{

    "name": "CONCAT",

    "group": "String",

    "template": "CONCAT({{string1}}, string2)",

    "description": [

      "Combines strings.",

      "NULL parameters are ignored, and do not cause the result to become NULL",

      "This method returns a string.\n",

      "Example:\n",

      "CONCAT(NAME, '!')"

    ],

    "returnType": "String"

}

{

    "name": "CHAR",

    "group": "String",

    "template": "CHAR({{int}})",

    "args": [

        "value whose character is to be returned"

    ],

    "description": [

      "Returns the character that represents the ASCII value.",

      "This method returns a string.\n",

      "Example:\n",

      "CHAR(65)"

    ],

    "alias": [

      "CHR"

    ],

    "returnType": "String"

}

{

    "name": "DECODE",

    "group": "String",

    "template": "DECODE({{data}}, 'hex')",

    "description": [

      "Decode binary data from textual representation in string.\n",

      "Supported formats are: base64, hex.\n"

    ],

    "args": [

          "data - A string value with the data to be converted",

          "format - A string value indicating the format of the input data. The default value is 'hex'."

    ],    

    "returnType": "Byte array"

}

{

    "name": "ASCII",

    "group": "String",

    "template": "ASCII({{string}})",

    "args": [

        "value whose first ascii character is to be returned"

    ],

    "description": [

      "Returns the ASCII value of the first character in the string.",

      "This method returns an int.\n",

      "Example:\n",

      "ASCII('Hi')"

    ],

    "returnType": "Integer"

}

{

    "name": "INSTR",

    "group": "String",

    "template": "INSTR({{string}}, searchString, startInt)",

    "description": [

      "Returns the location of a search string in a string.",

      "If a start position is used, the characters before it are ignored.",

      "If position is negative, the rightmost location is returned.",

      "0 is returned if the search string is not found.",

      "Please note this function is case sensitive, even if the parameters are not.\n",

      "Example:\n",

      "INSTR(EMAIL,'@')"

    ],

    "args": [

          "string",

          "searchString"

          "startInt - Optional. Start position to be used for search"

    ],    

    "returnType": "Integer"

}