Innov-AIINNOV-AI
Backoffice
← Back Home

FX - String @ Data transformation (ETL) @ MentDB Weak

> Start the server
> (or start the server for the first time (embedded mode - H2 Database))
> (or start the server for the first time (remote mode - MySQL 8 Database))
> Open the MentDB Weak Editor
String
string asciistring binstring bit_lengthstring charstring char_lengthstring char_to_intconcatstring csv_valuestring sentence_distancestring sentences_distancestring orderstring get_variablestring levenshtein_distancestring md5string shastring sha_256string countstring bcrypt_hashstring bcrypt_verifystring encode_sign_generate_keypairstring encode_signstring decode_sign_verifystring encode_rsa_generate_keypairstring encode_rsastring decode_rsastring encode_des_generate_keystring encode_desstring decode_desstring encode_blowfishstring decode_blowfishstring encode_pbestring decode_pbestring encode_b64string decode_b64string del_char_before_each_linestring mql_to_htmlstring ends_withstring first_letter_upperstring first_letterstring generate_random_strstring hexstring hex_to_intstring hex_to_strstring indentstring instrstring instrstring int_to_charstring int_to_hexstring int_to_octstring is_letterstring is_alpha_num_udsstring is_alpha_numstring is_number_charstring itrimstring lcasestring leftstring lengthstring likestring locatestring locatestring lowerstring lpadstring lrtrimstring lrtrim0string ltrimstring matchesstring midstring midstring not_likestring not_regexpstring octstring oct_to_intstring positionstring positionstring regexpstring repeatstring repeat_insert_strstring replacestring reversestring rightstring rpadstring rtrimstring spacestring splitstring split_mqlstring split_sentencestring starts_withstring starts_with_orstring str_to_hexstring strcmpstring strposstring strposstring sublrcharstring substrstring substrstring substringstring substringstring to_stringstring encodestring empty_if_nullstring null_if_emptystring trimstring txtstring txt2string ucasestring unhexstring upperstring zerostring uuidstring unaccentstring slugifystring url_encodestring url_decodestring html_escapestring html_unescapestring json_escapestring sha_512string capitalize_wordsstring camel_casestring snake_casestring kebab_casestring is_blankstring regexp_countstring hmac_sha256string truncatestring containsstring contains_ignore_casestring equals_ignore_casestring regexp_replacestring regexp_extracttype is_matches_regex

string ascii <chr>

Description

    Convert a character to an integer

Parameters

    chr:   The string - String - required
admin
string ascii "a"
mentdb
97

string bin <num>

Description

    Returns a string representation of the binary value of n, where n is a long (bigint) number

Parameters

    num:   The number - Number - required
admin
string bin 97
mentdb
1100001

string bit_length <str>

Description

    Returns the length of the string str in bits

Parameters

    str:   The string - String - required
admin
string bit_length 61
mentdb
16

string char <num>

Description

    Convert an integer to a character

Parameters

    num:   The number - Number - required
admin
string char 97
mentdb
a

string char_length <str>

Description

    Returns the length of the string. The length is equal to the number of Unicode code units in the string.

Parameters

    str:   The string - String - required
admin
string char_length "azerty"
mentdb
6

string char_to_int <chr>

Description

    Convert a character to an integer using the ASCII classification

Parameters

    chr:   The string - String - required
admin
string char_to_int "a"
mentdb
97

concat <str1> <strN>

Description

    Concatenate all parameters (do not use this function with 'string' before it)

Parameters

    str1:   The string - String - required
    strN:   The string - String - required
admin
concat "str1" "str2" "str3"
mentdb
str1str2str3

string csv_value <data> <columnSeparator> <quoteChar>

Description

    Convert a string into a valid CSV value

Parameters

    data:   The string data - String - required
    columnSeparator:   The column separator - String - required
    quoteChar:   The quote character - String - required
admin
string csv_value "a" "," "'"
mentdb
a

string sentence_distance <activationPercent> <levenshteinPercent> <sentence1> <sentence2>

Description

    To get the sentence distance between two sentences

Parameters

    activationPercent:   The activation percentage - Number - required
    levenshteinPercent:   The Levenshtein percentage - Number - required
    sentence1:   The sentence 1 - String - required
    sentence2:   The sentence 2 - String - required
admin
string sentence_distance 40 70 "word1 word2 word3" "word1 word2"
mentdb
267.0

string sentences_distance <activationPercent> <levenshteinPercent> <sentence1> <sentenceObj>

Description

    To get the sentence distance between several sentences

Parameters

    activationPercent:   The activation percentage - Number - required
    levenshteinPercent:   The Levenshtein percentage - Number - required
    sentence1:   The sentence 1 - String - required
    sentenceObj:   The sentence object (key=sentence) - String - required
admin
string sentences_distance 40 70 "vrai passionné" "{
	\"1\": {
		\"i\": \"des saveurs qui explosent en bouche\",
		\"o\": \"1\"
	},
	\"2\": {
		\"i\": \"un vrai passionné de cuisine\",
		\"o\": \"-1\"
	},
	\"3\": {
		\"i\": \"agréablement surpenant\",
		\"o\": \"0\"
	}
}"
mentdb
{
  \"best_id\": \"2\",
  \"best_predict\": \"-1\",
  \"best_sentence\": \"un vrai passionné de cuisine\",
  \"best_value\": 240.0,
  \"handle\": {
    \"1\": {
      \"v\": 0.0,
      \"i\": \"des saveurs qui explosent en bouche\",
      \"o\": \"1\"
    },
    \"2\": {
      \"v\": 240.0,
      \"i\": \"un vrai passionné de cuisine\",
      \"o\": \"-1\"
    },
    \"3\": {
      \"v\": 0.0,
      \"i\": \"agréablement surpenant\",
      \"o\": \"0\"
    }
  }
}

string order <jsonArray>

Description

    Return an ordered array of string

Parameters

    jsonArray:   A JSON array - String - required
admin
string order "[\"A\", \"C\", \"B\"]"
mentdb
"[\"A\", \"B\", \"C\"]"

string get_variable <input> <pattern>

Description

    To get variables from a string

Parameters

    input:   The input - String - required
    pattern:   The pattern ([1] for the first variable) - String - required
admin
string get_variable "Paris is a beautifull city" "[1] is a beautifull city"
mentdb
["Paris"]

string levenshtein_distance <word1> <word2>

Description

    To get the Levenshtein distance (edit distance) between two strings

Parameters

    word1:   The word 1 - String - required
    word2:   The word 2 - String - required
admin
string levenshtein_distance "admn" "admin"
mentdb
1

string md5 <str>

Description

    Get the MD5 hash

Parameters

    str:   The string - String - required
admin
string md5 "admin"
mentdb
21232f297a57a5a743894a0e4a801fc3

string sha <str>

Description

    Get the SHA hash

Parameters

    str:   The string - String - required
admin
string sha "admin"
mentdb
d033e22ae348aeb5660fc2140aec35850c4da997

string sha_256 <str>

Description

    Get the SHA-256 hash

Parameters

    str:   The string - String - required
admin
string sha_256 "admin"
mentdb
8c6976e5b5410415bde908bd4dee15dfb167a9c873fc4bb8a81f6f2ab448a918

string count <string> <find>

Description

    Count the number of occurrences of a string in another string

Parameters

    string:   The string - String - required
    find:   The string - String - required
admin
string count "azertyaze" "a"
mentdb
2

string bcrypt_hash <password> <strength>

Description

    Hash a string with bcrypt

Parameters

    password:   The password - String - required
    strength:   The strength - Number - required
admin
string bcrypt_hash "pwd" 10
mentdb
$2a$10$zkC0//y/lkw0cNRWF/XKeuK.lyfRkvVaCPNdpnrYjsK3Orzl.5nKC

string bcrypt_verify <password> <hash>

Description

    Verify a password with bcrypt

Parameters

    password:   The password - String - required
    hash:   The hash - String - required
admin
string bcrypt_verify "pwd" "$2a$10$zkC0//y/lkw0cNRWF/XKeuK.lyfRkvVaCPNdpnrYjsK3Orzl.5nKC"
mentdb
1

string encode_sign_generate_keypair <keysize>

Description

    Generate a key pair for signature encryption

Parameters

    keysize:   The key size - String - required
admin
string encode_sign_generate_keypair "2048"
mentdb
{
  "privateKey": "MIIEvgIBADANBgkqhkiG9w0BAQEFAASCBKgwggSkAgEAAoIBAQCnwvK73uoux+7wwULXE1OcTJO/KYuClwbX3B15jaE2KSW7PVIVkLehJ6gz0PnIXddpFaKRgoX1fjnovaUtA2n3Y3VzaHR0OEaYG9StkHGisXndDNuazzJ6BeUvvKA83OVB5JMn7skee3Fq29UPjRLhYNGnms/Ry7BpUYSO2KdjNGDgE/qDdc7PUSzDivM76BXdcDQHrrP6RGeqBL4a/3G/gq3jSjMoDLO1vMzdVzFRAX2fROCSBI641Y/UBryd3CQHXssUBBI9Kg3hEO60tr2X/oFDExIONP48y5NmsPsNRKw/hJ8MYaMDAxopuaMq5XUQ3EuOQf63HWOp75/RJNjXAgMBAAECggEBAJWBSdsd1KuuKAXM5alQovGm2QDCoH7X4xRaKLZb/rCKyQJtqopndw6aje7nrMLgxojy6/crUACw5iDBacOMyFHdBB2+mBG+2ULTgpzPHkY0Tfsua0MypbRTLqV1P4QeA/3OG0q6JegRcMkfcmgyfAH4y77HW6+HDAc/y5eWAs6HvOv69KjgVWwk7M+qePJAfqSA1mVfvtZp5woD3xzQY0hIb/lnG/tDCQp+p1v3rFrFpufdkgFX5JTx37oe4mnc4Zrpvr+qxekT1HlJVgo3V9ooN/oVAyuQXg58y3ZmYH6mCXlgNe+QYH/TknHWlqAnK0eu95dgHX6GtNA6Dz9TjsECgYEA0ZvSYs/cXHre4KdWV7h9higezi0JKfygEOBYVEeUiJ1cC/8a43rTns4oobnOczcs7UJUpR3iV+xNmw22rOwLXG8wjXOAmrjvC9iHhMNiNVox/hxZ75755FcjzFz8AOLVCUHeHMiIxrwm1lRL+92ZdYxgXh2IcXy0T+X3xicj5aECgYEAzOQdrsZ/7kaIYCgCF8ugl+aEYi83GE7J/RT0gemvt68JWOGdq18MfFzuYSeLbHZMSaWWbzlNj0mU1dwtgryfiXI3YHQ5Oe70Fef88cZ04lpnOrw+E1B539sG3Ldftif4bBgPfTrP3smXz8LAXdmB030yuiI1x8+fO//CgBrpO3cCgYEApOLw8y4UaON3JD4+m67Tf49b/FBNHyxNNjllApd0bqtq1z0Mh9n9UrVWHTKvBs9mlhVRxLnnbcbDna+B/jGJFmOZTAyKJCxKT4U7xeJ1BQc4wG7JCMiER22NCZwz2PaXIzsfYIEXp04nNv8E7tJ5f5C31hFhXfT9WsTKzqPHh0ECgYBOUWgTNacTEnzwnHpoVBq31ZKG4Vti/ELzbX4k5omXYd3lzp/xMKzaIL+x/Waq9/EjOZtuOm4uNkchFD+FOMqWxETspqB1R6SfdwTV+jEVkM7iwa/MvDdJ3TQbTDDWtSKdVvkcuk1Y8KAJ93yGoyygBbxNL+R00yUfzxyu0RqT8wKBgHinNaHsk3HY5rq7SR708dtj9dqc0DDQ+M+1M979XL8tfqCtZ17xluTi7QAdcq8xIX8ev1hkkkv6elxhjvcqFww9w45cpB76MFuW0dzfi7/32wFkwpwc5ih0+Qcp1qqJspiQKG3/2ur9sNndBejYmtNY4i5mhlllXCiF/87PKRTZ",
  "publicKey": "MIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEAp8Lyu97qLsfu8MFC1xNTnEyTvymLgpcG19wdeY2hNikluz1SFZC3oSeoM9D5yF3XaRWikYKF9X456L2lLQNp92N1c2h0dDhGmBvUrZBxorF53Qzbms8yegXlL7ygPNzlQeSTJ+7JHntxatvVD40S4WDRp5rP0cuwaVGEjtinYzRg4BP6g3XOz1Esw4rzO+gV3XA0B66z+kRnqgS+Gv9xv4Kt40ozKAyztbzM3VcxUQF9n0TgkgSOuNWP1Aa8ndwkB17LFAQSPSoN4RDutLa9l/6BQxMSDjT+PMuTZrD7DUSsP4SfDGGjAwMaKbmjKuV1ENxLjkH+tx1jqe+f0STY1wIDAQAB"
}

string encode_sign <data> <privateKey>

Description

    Get a signature from a string

Parameters

    data:   The data string - String - required
    privateKey:   The private key - String - required
admin
string encode_sign "azerty" (json select "keyId" "/privateKey")
mentdb
MD0CHCGD3SEzr5rIZnSdnyT+DGLPqHbI9VFBjwY3yv0CHQCfA56aUbe0y/ixaXgx7GWXM/JFAYAXnU3uFP/l

string decode_sign_verify <data> <signature> <puvlicKey>

Description

    Check a text with a signature and a public key

Parameters

    data:   The data string - String - required
    signature:   The signature - String - required
    puvlicKey:   The public key - String - required
admin
string decode_sign_verify "azerty" "MD0CHCGD3SEzr5rIZnSdnyT+DGLPqHbI9VFBjwY3yv0CHQCfA56aUbe0y/ixaXgx7GWXM/JFAYAXnU3uFP/l" (json select "keyId" "/publicKey")
mentdb
1

string encode_rsa_generate_keypair <keysize>

Description

    Generate a key pair for RSA encryption

Parameters

    keysize:   The key size - String - required
admin
string encode_rsa_generate_keypair "2048"
mentdb
{
  "privateKey": "MIIEvgIBADANBgkqhkiG9w0BAQEFAASCBKgwggSkAgEAAoIBAQCnwvK73uoux+7wwULXE1OcTJO/KYuClwbX3B15jaE2KSW7PVIVkLehJ6gz0PnIXddpFaKRgoX1fjnovaUtA2n3Y3VzaHR0OEaYG9StkHGisXndDNuazzJ6BeUvvKA83OVB5JMn7skee3Fq29UPjRLhYNGnms/Ry7BpUYSO2KdjNGDgE/qDdc7PUSzDivM76BXdcDQHrrP6RGeqBL4a/3G/gq3jSjMoDLO1vMzdVzFRAX2fROCSBI641Y/UBryd3CQHXssUBBI9Kg3hEO60tr2X/oFDExIONP48y5NmsPsNRKw/hJ8MYaMDAxopuaMq5XUQ3EuOQf63HWOp75/RJNjXAgMBAAECggEBAJWBSdsd1KuuKAXM5alQovGm2QDCoH7X4xRaKLZb/rCKyQJtqopndw6aje7nrMLgxojy6/crUACw5iDBacOMyFHdBB2+mBG+2ULTgpzPHkY0Tfsua0MypbRTLqV1P4QeA/3OG0q6JegRcMkfcmgyfAH4y77HW6+HDAc/y5eWAs6HvOv69KjgVWwk7M+qePJAfqSA1mVfvtZp5woD3xzQY0hIb/lnG/tDCQp+p1v3rFrFpufdkgFX5JTx37oe4mnc4Zrpvr+qxekT1HlJVgo3V9ooN/oVAyuQXg58y3ZmYH6mCXlgNe+QYH/TknHWlqAnK0eu95dgHX6GtNA6Dz9TjsECgYEA0ZvSYs/cXHre4KdWV7h9higezi0JKfygEOBYVEeUiJ1cC/8a43rTns4oobnOczcs7UJUpR3iV+xNmw22rOwLXG8wjXOAmrjvC9iHhMNiNVox/hxZ75755FcjzFz8AOLVCUHeHMiIxrwm1lRL+92ZdYxgXh2IcXy0T+X3xicj5aECgYEAzOQdrsZ/7kaIYCgCF8ugl+aEYi83GE7J/RT0gemvt68JWOGdq18MfFzuYSeLbHZMSaWWbzlNj0mU1dwtgryfiXI3YHQ5Oe70Fef88cZ04lpnOrw+E1B539sG3Ldftif4bBgPfTrP3smXz8LAXdmB030yuiI1x8+fO//CgBrpO3cCgYEApOLw8y4UaON3JD4+m67Tf49b/FBNHyxNNjllApd0bqtq1z0Mh9n9UrVWHTKvBs9mlhVRxLnnbcbDna+B/jGJFmOZTAyKJCxKT4U7xeJ1BQc4wG7JCMiER22NCZwz2PaXIzsfYIEXp04nNv8E7tJ5f5C31hFhXfT9WsTKzqPHh0ECgYBOUWgTNacTEnzwnHpoVBq31ZKG4Vti/ELzbX4k5omXYd3lzp/xMKzaIL+x/Waq9/EjOZtuOm4uNkchFD+FOMqWxETspqB1R6SfdwTV+jEVkM7iwa/MvDdJ3TQbTDDWtSKdVvkcuk1Y8KAJ93yGoyygBbxNL+R00yUfzxyu0RqT8wKBgHinNaHsk3HY5rq7SR708dtj9dqc0DDQ+M+1M979XL8tfqCtZ17xluTi7QAdcq8xIX8ev1hkkkv6elxhjvcqFww9w45cpB76MFuW0dzfi7/32wFkwpwc5ih0+Qcp1qqJspiQKG3/2ur9sNndBejYmtNY4i5mhlllXCiF/87PKRTZ",
  "publicKey": "MIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEAp8Lyu97qLsfu8MFC1xNTnEyTvymLgpcG19wdeY2hNikluz1SFZC3oSeoM9D5yF3XaRWikYKF9X456L2lLQNp92N1c2h0dDhGmBvUrZBxorF53Qzbms8yegXlL7ygPNzlQeSTJ+7JHntxatvVD40S4WDRp5rP0cuwaVGEjtinYzRg4BP6g3XOz1Esw4rzO+gV3XA0B66z+kRnqgS+Gv9xv4Kt40ozKAyztbzM3VcxUQF9n0TgkgSOuNWP1Aa8ndwkB17LFAQSPSoN4RDutLa9l/6BQxMSDjT+PMuTZrD7DUSsP4SfDGGjAwMaKbmjKuV1ENxLjkH+tx1jqe+f0STY1wIDAQAB"
}

string encode_rsa <data> <publicKey> <privateKey>

Description

    Encode a string with the DES algorithm

Parameters

    data:   The data string - String - required
    publicKey:   The public key - String - required
    privateKey:   The private key - String - required
admin
string encode_rsa "azerty" (json select "keyId" "/publicKey") (json select "keyId" "/privateKey")
mentdb
AI1yh7NIDFHjWeO3PKOTdC0sJC68MyZtCJvjG3fpkTFenS+8jSuS4qtq6XNB9X5fzBuyKKD0Cpcn4k8ePmoYJxuPdjnwLrE807QR/hl20lOUn773ldViV91LH0/nlfkxBeiEGjrUwN8he8nqeF8pVSqZiJpz5+YxnnG3nxcLQB1YABSlAtC9hx41+BLUbJx5AMFgtGZ72q/XxeTCKs8vXUc6TtAtF9TPvNznN506/TsS+CeaPAkLdwC3yLeI+u6Wlf9EwPDyfUtcpIvDxcRgWJYy1lwjgONCpRbgQTyX01Uk+dXAgctozYZnlVoyllwe5pevMemGG8y87llBJImCJCA=

string decode_rsa <data> <privateKey>

Description

    Decode a string with the DES algorithm

Parameters

    data:   The data string - String - required
    privateKey:   The private key - String - required
admin
string decode_rsa "AI1yh7NIDFHjWeO3PKOTdC0sJC68MyZtCJvjG3fpkTFenS+8jSuS4qtq6XNB9X5fzBuyKKD0Cpcn4k8ePmoYJxuPdjnwLrE807QR/hl20lOUn773ldViV91LH0/nlfkxBeiEGjrUwN8he8nqeF8pVSqZiJpz5+YxnnG3nxcLQB1YABSlAtC9hx41+BLUbJx5AMFgtGZ72q/XxeTCKs8vXUc6TtAtF9TPvNznN506/TsS+CeaPAkLdwC3yLeI+u6Wlf9EwPDyfUtcpIvDxcRgWJYy1lwjgONCpRbgQTyX01Uk+dXAgctozYZnlVoyllwe5pevMemGG8y87llBJImCJCA=" (json select "keyId" "/privateKey")
mentdb
azerty

string encode_des_generate_key <keysize>

Description

    Generate a key for DES encryption

Parameters

    keysize:   The key size - String - required
admin
string encode_des_generate_key "56"
mentdb
eVHgJt9uHAE=

string encode_des <data> <secretKey>

Description

    Encode a string with the DES algorithm

Parameters

    data:   The data string - String - required
    secretKey:   The secret key - String - required
admin
string encode_des "azerty" "eVHgJt9uHAE="
mentdb
uMIF5QaE3zc=

string decode_des <data> <secretKey>

Description

    Decode a string with the DES algorithm

Parameters

    data:   The data string - String - required
    secretKey:   The secret key - String - required
admin
string decode_des "uMIF5QaE3zc=" "eVHgJt9uHAE="
mentdb
azerty

string encode_blowfish <data> <secretKey>

Description

    Encode a string with the Blowfish algorithm

Parameters

    data:   The data string - String - required
    secretKey:   The secret key - String - required
admin
string encode_blowfish "azerty" "mySecretKey"
mentdb
HFnj8tkXUyY=

string decode_blowfish <data> <secretKey>

Description

    Decode a string with the Blowfish algorithm

Parameters

    data:   The data string - String - required
    secretKey:   The secret key - String - required
admin
string decode_blowfish "HFnj8tkXUyY=" "mySecretKey"
mentdb
azerty

string encode_pbe <data> <password>

Description

    Encode a string with the PBE algorithm

Parameters

    data:   The data string - String - required
    password:   The password - String - required
admin
string encode_pbe "azerty" "myPassword"
mentdb
{"encrypted":"gREfhYMVFjs=","params":"MA0ECG5GZ4n6ieTAAgEK"}

string decode_pbe <json_data> <password>

Description

    Decode a string with the PBE algorithm

Parameters

    json_data:   The JSON data and parameters string - String - required
    password:   The password - String - required
admin
string decode_pbe "{"encrypted":"gREfhYMVFjs=","params":"MA0ECG5GZ4n6ieTAAgEK"}" "myPassword"
mentdb
azerty

string encode_b64 <string>

Description

    Encode a string in Base64

Parameters

    string:   The string - String - required
admin
string encode_b64 "azerty"
mentdb
YXplcnR5

string decode_b64 <string>

Description

    Decode a string from Base64

Parameters

    string:   The string - String - required
admin
string decode_b64 "YXplcnR5"
mentdb
azerty

string del_char_before_each_line <data> <nbChar>

Description

    Delete a number of characters on each line

Parameters

    data:   The data - String - required
    nbChar:   The number of characters - Number - required
admin
string del_char_before_each_line "sdlfkjdf
dfgdfgdfgdfgd" 4
mentdb
kjdf
fgdfgdfgd

string mql_to_html <mql>

Description

    Convert MQL source code to HTML

Parameters

    mql:   The MQL source code - String - required
admin
in editor {string mql_to_html (mql {

	concat "r=" [R];

})};
mentdb


	<span style='color:#003cc8'>concat</span> <span style='color:#007700'>"r="</span> <span style='color:#ba1c00'>[R]</span>;

string ends_with <stringValue> <stringToEnd>

Description

    Check if a value ends with another string

Parameters

    stringValue:   The string - String - required
    stringToEnd:   The end string - String - required
admin
string ends_with "azertyaze" t
mentdb
0

string first_letter_upper <str>

Description

    Returns the string with the first letter in uppercase and the rest of the string in lowercase.

Parameters

    str:   The string - String - required
admin
string first_letter_upper "azerty"
mentdb
Azerty

string first_letter <str>

Description

    Returns the first letter of a string.

Parameters

    str:   The string - String - required
admin
string first_letter "azerty"
mentdb
a

string generate_random_str <size>

Description

    Generate a random string, with the length of the random string as parameter.

Parameters

    size:   The size of the string - String - required
admin
string generate_random_str 1
mentdb
D

string hex <num>

Description

    Returns a string representation of the hexadecimal value of num, where num is a long int (bigint) number

Parameters

    num:   The number - Number - required
admin
string hex 97
mentdb
61

string hex_to_int <hex>

Description

    Convert a hexadecimal number to a long int (bigint) number

Parameters

    hex:   The hex number - String - required
admin
string hex_to_int 97
mentdb
151

string hex_to_str <hex>

Description

    Get the ASCII character associated with a hexadecimal number.

Parameters

    hex:   The hexadecimal number - String - required
admin
string hex_to_str 61
mentdb
a

string indent <str> <nbSpaceBefore>

Description

    Returns the indented string

Parameters

    str:   The string - String - required
    nbSpaceBefore:   The string - String - required
admin
string indent "azerty
a
b
c" 3
mentdb
azerty
   a
   b
   c

string instr <str1> <str2>

Description

    Returns the index within this string of the first occurrence of the specified substring

Parameters

    str1:   The string - String - required
    str2:   The string - String - required
admin
string instr "azerty" "r"
mentdb
3

string instr <str1> <str2> <fromIndex>

Description

    Returns the index within this string of the first occurrence of the specified substring, starting at the specified index

Parameters

    str1:   The string - String - required
    str2:   The string - String - required
    fromIndex:   The start index - Number - required
admin
string instr "azerty" "r" 4
mentdb
-1

string int_to_char <num>

Description

    Convert an integer to a character

Parameters

    num:   The number - Number - required
admin
string int_to_char 97
mentdb
a

string int_to_hex <num>

Description

    Returns a string representation of the hexadecimal value of n, where n is a long int (bigint) number

Parameters

    num:   The number - Number - required
admin
string int_to_hex 97
mentdb
61

string int_to_oct <num>

Description

    Returns a string representation of the octal value of n, where n is a long int (bigint) number

Parameters

    num:   The number - Number - required
admin
string int_to_oct 97
mentdb
141

string is_letter <value>

Description

    Check if a value contains only letters

Parameters

    value:   The value - String - required
admin
string is_letter "abcd"
mentdb
1

string is_alpha_num_uds <value>

Description

    Check if a value contains only letters, underscores or digits

Parameters

    value:   The value - String - required
admin
string is_alpha_num_uds "abc_12d"
mentdb
1

string is_alpha_num <value>

Description

    Check if a value contains only letters or digits

Parameters

    value:   The value - String - required
admin
string is_alpha_num "abc12d"
mentdb
1

string is_number_char <value>

Description

    Check if a value contains only digits

Parameters

    value:   The value - String - required
admin
string is_number_char "-456.45"
mentdb
0

string itrim <str>

Description

    Replace multiple spaces between words by a single space

Parameters

    str:   The string - String - required
admin
string itrim "aze   rty"
mentdb
aze rty

string lcase <str>

Description

    Converts all the characters of the string to lower case using the rules of the default locale

Parameters

    str:   The string - String - required
admin
string lcase "AZERTY"
mentdb
azerty

string left <str> <len>

Description

    Returns every index of a string until the number of characters returned is equal to the n parameter sent.

Parameters

    str:   The string - String - required
    len:   The length - Number - required
admin
string left "AZERTY" 3
mentdb
AZE

string length <str>

Description

    Returns the length of the string. The length is equal to the number of Unicode code units in the string.

Parameters

    str:   The string - String - required
admin
string length "azerty"
mentdb
6

string like <str> <pat>

Description

    Performs a pattern match of a string expression expr against a pattern pat

Parameters

    str:   The string - String - required
    pat:   The pattern - String - required
admin
string like "azerty" ".*ze.*"
mentdb
1

string locate <str1> <str2>

Description

    Returns the index within this string of the first occurrence of the specified substring

Parameters

    str1:   The string - String - required
    str2:   The string - String - required
admin
string locate "azerty" "r"
mentdb
3

string locate <str1> <str2> <fromIndex>

Description

    Returns the index within this string of the first occurrence of the specified substring, starting at the specified index

Parameters

    str1:   The string - String - required
    str2:   The string - String - required
    fromIndex:   The start index - Number - required
admin
string locate "azerty" "r" 4
mentdb
-1

string lower <str>

Description

    Converts all the characters of the string to lower case using the rules of the default locale

Parameters

    str:   The string - String - required
admin
string lower "AZERTY"
mentdb
azerty

string lpad <str> <padString> <paddedLength>

Description

    Pads the left side of a string with a specific set of characters

Parameters

    str:   The string - String - required
    padString:   The pad string - String - required
    paddedLength:   The end of the substring - Number - required
admin
string lpad "azertyaze" "#" 10
mentdb
#azertyaze

string lrtrim <str>

Description

    Returns the string without space characters on the left and on the right

Parameters

    str:   The string - String - required
admin
string lrtrim "  azerty   "
mentdb
azerty

string lrtrim0 <str>

Description

    Returns the string without 0 characters on the left and on the right

Parameters

    str:   The string - String - required
admin
string lrtrim0 "  123   "
mentdb
  123

string ltrim <str>

Description

    Removes the space characters at the beginning of a string until a different character is found.

Parameters

    str:   The string - String - required
admin
string ltrim "  azerty   "
mentdb
azerty   

string matches <str> <pat>

Description

    Verify if two strings match; the use of '.*' for autocompletion is handled.

Parameters

    str:   The string - String - required
    pat:   The pattern - String - required
admin
string matches "azerty" ".*ze.*"
mentdb
1

string mid <str> <index>

Description

    Returns a new string starting at index.

Parameters

    str:   The string - String - required
    index:   The beginning of the substring - Number - required
admin
string mid "azertyaze" 3
mentdb
rtyaze

string mid <str> <beginIndex> <endIndex>

Description

    Returns a new string that starts at beginIndex of the original string and ends at endIndex of the original string.

Parameters

    str:   The string - String - required
    beginIndex:   The beginning of the substring - Number - required
    endIndex:   The end of the substring - Number - required
admin
string mid "azertyaze" 3 5
mentdb
rt

string not_like <str> <pat>

Description

    Verify if two strings are different.

Parameters

    str:   The string - String - required
    pat:   The pattern - String - required
admin
string not_like "azerty" ".*ze.*"
mentdb
0

string not_regexp <str> <pat>

Description

    Verify if two strings are different.

Parameters

    str:   The string - String - required
    pat:   The pattern - String - required
admin
string not_regexp "azerty" ".*ze.*"
mentdb
0

string oct <num>

Description

    Convert num, which is an int, to its octal form.

Parameters

    num:   The number - Number - required
admin
string oct 97
mentdb
141

string oct_to_int <oct>

Description

    Convert oct, which is an octal number, to a long int (bigint).

Parameters

    oct:   The octal number - String - required
admin
string oct_to_int "15"
mentdb
13

string position <str1> <str2>

Description

    Returns the index at which the first occurrence has been found.

Parameters

    str1:   The string - String - required
    str2:   The string - String - required
admin
string position "azerty" "r"
mentdb
3

string position <str1> <str2> <fromIndex>

Description

    Returns the index within this string of the first occurrence of the specified substring, starting at the specified index

Parameters

    str1:   The string - String - required
    str2:   The string - String - required
    fromIndex:   The start index - Number - required
admin
string position "azerty" "r" 4
mentdb
-1

string regexp <str> <pat>

Description

    Verify if two strings are identical.

Parameters

    str:   The string - String - required
    pat:   The pattern - String - required
admin
string regexp "azerty" ".*ze.*"
mentdb
1

string repeat <str> <count>

Description

    Returns the string passed as parameter repeated count times.

Parameters

    str:   The string - String - required
    count:   The count - Number - required
admin
string repeat "AZERTY" 3
mentdb
AZERTYAZERTYAZERTY

string repeat_insert_str <str> <strToInsert> <incr>

Description

    Returns str with strToInsert inserted every n characters

Parameters

    str:   The string - String - required
    strToInsert:   The string to insert - String - required
    incr:   The increment - Number - required
admin
string repeat_insert_str "azertyuiop" "-" 3
mentdb
aze-rty-uio-p-

string replace <str> <target> <replacement>

Description

    Replaces every occurrence of 'target' by the 'replacement' parameter in the string sent to this function.

Parameters

    str:   The string - String - required
    target:   The target string - String - required
    replacement:   The replacement - String - required
admin
string replace "azerty" "z" 9
mentdb
a9erty

string reverse <str>

Description

    Returns the reversed form of 'str'.

Parameters

    str:   The string - String - required
admin
string reverse "AZERTY"
mentdb
YTREZA

string right <str> <len>

Description

    Get every character starting from the end of the string up to len.

Parameters

    str:   The string - String - required
    len:   The length - Number - required
admin
string right "AZERTY" 3
mentdb
RTY

string rpad <str> <padString> <paddedLength>

Description

    Add characters at the end of the string only if the specified 'paddedLength' is larger than the size of the original string.

Parameters

    str:   The string - String - required
    padString:   The pad string - String - required
    paddedLength:   The end of the substring - Number - required
admin
string rpad "azertyaze" "#" 10
mentdb
azertyaze#

string rtrim <str>

Description

    Removes the space characters at the end of the string until a character other than space is found.

Parameters

    str:   The string - String - required
admin
string rtrim "  azerty   "
mentdb
  azerty

string space <count>

Description

    Returns a string composed of n space characters

Parameters

    count:   The number of spaces - String - required
admin
string space "5"
mentdb
     

string split <str> <regex> <limit>

Description

    Split a string using spaces as separators.

Parameters

    str:   The string - String - required
    regex:   The regex - String - required
    limit:   The limit - Number - required
admin
string split "a b c" " " -1
mentdb
["a","b","c"]

string split_mql <str> <index>

Description

    Split MQL source code

Parameters

    str:   The string - String - required
    index:   The index position - Number - required
admin
string split_mql "a b c" 1
mentdb
b

string split_sentence <str> <chars>

Description

    Split a sentence using every non-alphanumeric character as separator. If several non-alphanumeric characters are found in a row, this function still splits the sentence without putting any non-alphanumeric character in the words.

Parameters

    str:   The string - String - required
    chars:   The separator characters - Number - required
admin
string split_sentence "Hello, how are you ? Bye." ",?."
mentdb
...

string starts_with <stringValue> <stringToStart>

Description

    Verify if the first character of a string is equal to the first character of another string.

Parameters

    stringValue:   The string - String - required
    stringToStart:   The start string - String - required
admin
string starts_with "azertyaze" v
mentdb
0

string starts_with_or <stringValue> <stringToStart>

Description

    Verify if the first character of a string is equal to the first character of another string.

Parameters

    stringValue:   The string - String - required
    stringToStart:   The start string - String - required
admin
string starts_with_or "azertyaze" aeiou
mentdb
1

string str_to_hex <str>

Description

    Converts the ASCII decimal form of each character to its hexadecimal form.

Parameters

    str:   The string - String - required
admin
string str_to_hex 97
mentdb
3937

string strcmp <str1> <str2>

Description

    Compare two strings and return the difference of their ASCII decimal forms. If it returns 0, the function found no difference; in any other case the strings are different.

Parameters

    str1:   The string 1 - String - required
    str2:   The string 2 - String - required
admin
string strcmp "AZERTY" "iop"
mentdb
-40

string strpos <str1> <str2>

Description

    Returns the index at which the first occurrence of the second string has been found in the first one. It always returns the lowest possible index. Returns -1 if no occurrence is found.

Parameters

    str1:   The string - String - required
    str2:   The string - String - required
admin
string strpos "azerty" "r"
mentdb
3

string strpos <str1> <str2> <fromIndex>

Description

    Returns the index at which the first occurrence of the second string has been found in the first one. It always returns the lowest possible index. Returns -1 if no occurrence is found

Parameters

    str1:   The string - String - required
    str2:   The string - String - required
    fromIndex:   The start index - Number - required
admin
string strpos "azerty" "r" 4
mentdb
-1

string sublrchar <str> <numberDeleteChar>

Description

    Delete a number of characters at the start and at the end of the string

Parameters

    str:   The string - String - required
    numberDeleteChar:   The number of characters to delete - Number - required
admin
string sublrchar "azerty" 1
mentdb
zert

string substr <str> <index>

Description

    Returns the original string starting at the sent index.

Parameters

    str:   The string - String - required
    index:   The beginning of the substring - Number - required
admin
string substr "azertyaze" 3
mentdb
rtyaze

string substr <str> <beginIndex> <endIndex>

Description

    Returns the original string, starting at 'beginIndex' and ending at 'endIndex'.

Parameters

    str:   The string - String - required
    beginIndex:   The beginning of the substring - Number - required
    endIndex:   The end of the substring - Number - required
admin
string substr "azertyaze" 3 5
mentdb
rt

string substring <str> <index>

Description

    Returns the original string starting at the sent index.

Parameters

    str:   The string - String - required
    index:   The beginning of the substring - Number - required
admin
string substring "azertyaze" 3
mentdb
rtyaze

string substring <str> <beginIndex> <endIndex>

Description

    Returns the original string, starting at 'beginIndex' and ending at 'endIndex'.

Parameters

    str:   The string - String - required
    beginIndex:   The beginning of the substring - Number - required
    endIndex:   The end of the substring - Number - required
admin
string substring "azertyaze" 3 5
mentdb
rt

string to_string <str>

Description

    Return a valid SQL string value (example: 'i''m a man')

Parameters

    str:   The string - String - required
admin
string to_string "az\"erty"
mentdb
'az"erty'

string encode <str> <sourceEnc> <destinationEnc>

Description

    Encode a string to another encoding format

Parameters

    str:   The string - String - required
    sourceEnc:   The source encoding format - String - required
    destinationEnc:   The destination encoding format - String - required
admin
string encode "az\"erty" "ISO-8859-1" "UTF-8"
mentdb
az"erty

string empty_if_null <str>

Description

    Set the string to empty if it is null (ex: str = NULL, empty_if_null(str) -> str = '')

Parameters

    str:   The string - String - required
admin
string empty_if_null "a b@mail.com"
mentdb
a b@mail.com

string null_if_empty <str>

Description

    Set the string to null if it is empty (ex: str = '', null_if_empty(str) -> str = NULL)

Parameters

    str:   The string - String - required
admin
string null_if_empty "a b@mail.com"
mentdb
a b@mail.com

string trim <str>

Description

    Returns the string without space characters on the left and on the right, and with a single space wherever several spaces are found between non-space characters.

Parameters

    str:   The string - String - required
admin
string trim " aze   rty "
mentdb
aze rty

string txt <data>

Description

    Return a valid SQL string value (example: 'i''m a man')

Parameters

    data:   The data - String - required
admin
string txt "az'erty"
mentdb
'az\'erty'

string txt2 <data>

Description

    Return a valid SQL string value (example: 'i''m a man')

Parameters

    data:   The data - String - required
admin
string txt2 "az'erty"
mentdb
'az''erty'

string ucase <str>

Description

    Converts all the characters of the string to upper case using the rules of the default locale

Parameters

    str:   The string - String - required
admin
string ucase "azerty"
mentdb
AZERTY

string unhex <hex>

Description

    Convert a hexadecimal number to a long int (bigint).

Parameters

    hex:   The hex number - String - required
admin
string unhex 97
mentdb
151

string upper <str>

Description

    Converts all the characters of the string to upper case using the rules of the default locale

Parameters

    str:   The string - String - required
admin
string upper "azerty"
mentdb
AZERTY

string zero <str>

Description

    Return 0 if 'str' is an empty string, otherwise return the string

Parameters

    str:   The string - String - required
admin
string zero "az'erty"
mentdb
az'erty

string uuid

Description

    Generate a random UUID (v4). 

admin
string uuid
mentdb
3f2b8c1e-6a0d-4e5b-9c7a-1d2e3f4a5b6c

string unaccent <str>

Description

    Remove the accents (√© => e, √ß => c, ≈ì => oe).

Parameters

    str:   The string - String - required
admin
string unaccent "Été à Saint-Denis"
mentdb
Ete a Saint-Denis

string slugify <str>

Description

    Generate a slug for an URL or a file name.

Parameters

    str:   The string - String - required
admin
string slugify "Été à Saint-Denis !"
mentdb
ete-a-saint-denis

string url_encode <str>

Description

    Encode a string for an URL (UTF-8).

Parameters

    str:   The string - String - required
admin
string url_encode "a b&c=é"
mentdb
a%20b%26c%3D%C3%A9

string url_decode <str>

Description

    Decode an URL encoded string (UTF-8).

Parameters

    str:   The string - String - required
admin
string url_decode "a%20b%26c%3D%C3%A9"
mentdb
a b&c=é

string html_escape <str>

Description

    Escape the HTML special characters (& < > " ').

Parameters

    str:   The string - String - required
admin
string html_escape "<b>Tom & Jerry</b>"
mentdb
<b>Tom & Jerry</b>

string html_unescape <str>

Description

    Decode the HTML entities (basic and numeric).

Parameters

    str:   The string - String - required
admin
string html_unescape "<b>café</b>"
mentdb
<b>café</b>

string json_escape <str>

Description

    Escape a string to put it in a JSON value (without the surrounding quotes).

Parameters

    str:   The string - String - required
admin
string json_escape (concat "He said \"hi\"" [_n_])
mentdb
He said \"hi\"\n

string sha_512 <str>

Description

    Get the SHA-512 hash in hexadecimal.

Parameters

    str:   The string - String - required
admin
string sha_512 "abc"
mentdb
ddaf35a193617aba...a54ca49f

string capitalize_words <str>

Description

    Capitalize the first letter of each word.

Parameters

    str:   The string - String - required
admin
string capitalize_words "jean-paul DUPONT"
mentdb
Jean-Paul Dupont

string camel_case <str>

Description

    Convert to camelCase.

Parameters

    str:   The string - String - required
admin
string camel_case "Date de naissance"
mentdb
dateDeNaissance

string snake_case <str>

Description

    Convert to snake_case.

Parameters

    str:   The string - String - required
admin
string snake_case "dateDeNaissance"
mentdb
date_de_naissance

string kebab_case <str>

Description

    Convert to kebab-case.

Parameters

    str:   The string - String - required
admin
string kebab_case "dateDeNaissance"
mentdb
date-de-naissance

string is_blank <str>

Description

    Check if a string is null, empty or only white spaces.

Parameters

    str:   The string - String - required
admin
string is_blank "   "
mentdb
1

string regexp_count <str> <pat>

Description

    Count the matches of a regex.

Parameters

    str:   The string - String - required
    pat:   The regex - String - required
admin
string regexp_count "a1b22c333" "[0-9]+"
mentdb
3

string hmac_sha256 <str> <key>

Description

    Get the HMAC SHA-256 signature in hexadecimal (ex: webhook).

Parameters

    str:   The string - String - required
    key:   The secret key - String - required
admin
string hmac_sha256 "message" "secret"
mentdb
8b5f48702995c159...

string truncate <str> <max>

Description

    Cut a string to a max length and add '...' if it was cut.

Parameters

    str:   The string - String - required
    max:   The max length - Number - required
admin
string truncate "Hello world" 8
mentdb
Hello...

string contains <str> <find>

Description

    Check if a string contains another (case sensitive).

Parameters

    str:   The string - String - required
    find:   The string to find - String - required
admin
string contains "MentDB server" "DB"
mentdb
1

string contains_ignore_case <str> <find>

Description

    Check if a string contains another (case insensitive).

Parameters

    str:   The string - String - required
    find:   The string to find - String - required
admin
string contains_ignore_case "MentDB server" "db"
mentdb
1

string equals_ignore_case <str1> <str2>

Description

    Compare two strings (case insensitive).

Parameters

    str1:   The string 1 - String - required
    str2:   The string 2 - String - required
admin
string equals_ignore_case "MentDB" "mentdb"
mentdb
1

string regexp_replace <str> <pat> <replacement>

Description

    Replace all matches of a regex ($1, $2 ... for the groups).

Parameters

    str:   The string - String - required
    pat:   The regex - String - required
    replacement:   The replacement - String - required
admin
string regexp_replace "2026-10-30" "([0-9]+)-([0-9]+)-([0-9]+)" "$3/$2/$1"
mentdb
30/10/2026

string regexp_extract <str> <pat> <group>

Description

    Extract the first match of a regex (group 0 = the whole match, empty if not found).

Parameters

    str:   The string - String - required
    pat:   The regex - String - required
    group:   The group number - Number - required
admin
string regexp_extract "Order n°A-1234 sent" "([A-Z])-([0-9]+)" 2
mentdb
1234

type is_matches_regex <str> <pat>

Description

    Compare two strings to see if they are identical. With '.*' the function tries to autocomplete a word to see if a match occurs (ex: is_matches_regex(azerty, .*er.*): here .*er.* matches azerty); in this case it still returns true if the strings match after autocompletion.

Parameters

    str:   The string - String - required
    pat:   The pattern - String - required
admin
type is_matches_regex "azerty" ".*ze.*"
mentdb
1
start: 2026-10-30end: 2026-10-30v_start: 422v_end: