String
Like all languages, you have a few data manipulation functions.
string ascii <chr>
Description
convert a character to 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
concat all parameters (do not use this function with string before)
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: Quote char - 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 percent - Number - required
levenshteinPercent: The levenshtein percent - 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 percent - Number - required
levenshteinPercent: The levenshtein percent - 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 (length difference) 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
Parameters
str: The string - String - required
admin
string md5 "admin"
mentdb
21232f297a57a5a743894a0e4a801fc3
string sha <str>
Description
get the sha
Parameters
str: The string - String - required
admin
string sha "admin"
mentdb
d033e22ae348aeb5660fc2140aec35850c4da997
string count <string> <find>
Description
count the number of occurences 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 encode_sign_generate_keypair <keysize>
Description
Generate a key pair for sign 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 into 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 from 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 into 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 from 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 into 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 from 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 into 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 from 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 into b64
Parameters
string: The string - String - required
admin
string encode_b64 "azerty"
mentdb
YXplcnR5
string decode_b64 <string>
Description
decode a string from b64
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 char on each lines
Parameters
data: The data - String - required
nbChar: The number of chars - Number - required
admin
string del_char_before_each_line "sdlfkjdf<br>dfgdfgdfgdfgd" 4
mentdb
kjdf<br>fgdfgdfgd<br>
string mql_to_html <mql>
Description
Convert a 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 from 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 an hexadecimal number to 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 to an 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<br>a<br>b<br>c" 3
mentdb
azerty<br> a<br> b<br> 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: starting to index - Number - required
admin
string instr "azerty" "r" 4
mentdb
-1
string int_to_char <num>
Description
convert an integer to 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, underscore char or numbers
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 numbers
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 number char
Parameters
value: The value - String - required
admin
string is_number_char "-456.45"
mentdb
0
string itrim <str>
Description
transform multiple spaces by only one space between strings
Parameters
str: The string - String - required
admin
string itrim "aze rty"
mentdb
aze rty
string lcase <str>
Description
converts all of the characters in this 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 indexes of a string until the number of character returned is equal to the n paramater 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 this 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 paterne - 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: starting to index - Number - required
admin
string locate "azerty" "r" 4
mentdb
-1
string lower <str>
Description
converts all of the characters in this 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 sub string - Number - required
admin
string lpad "azertyaze" "#" 10
mentdb
#azertyaze
string lrtrim <str>
Description
returns the string without space character 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 character 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 if found.
Parameters
str: The string - String - required
admin
string ltrim " azerty "
mentdb
azerty
string matches <str> <pat>
Description
Verify if two strings are matching, the use of '.*' for autocompletion is handled.
Parameters
str: the string - String - required
pat: the paterne - 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 begin of the sub string - 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 end at endIndex of the original string.
Parameters
str: The string - String - required
beginIndex: The begin of the sub string - Number - required
endIndex: The end of the sub string - 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 paterne - 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 paterne - String - required
admin
string not_regexp "azerty" ".*ze.*"
mentdb
0
string oct <num>
Description
convert num which is an int to an 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 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 occurence 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: starting to 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 paterne - String - required
admin
string regexp "azerty" ".*ze.*"
mentdb
1
string repeat <str> <count>
Description
returns count number of times the string that was passed as parameter.
Parameters
str: The string - String - required
count: The count number - Number - required
admin
string repeat "AZERTY" 3
mentdb
AZERTYAZERTYAZERTY
string repeat_insert_str <str> <strToInsert> <incr>
Description
returns str with strToInsert inserted all 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 occurences 'target' by the 'replacement' parameter in the string that was sent to this function.
Parameters
str: The string - String - required
target: The string target - String - required
replacement: The replacement - String - required
admin
string replace "azerty" "z" 9
mentdb
a9erty
string reverse <str>
Description
returns the inverted form of 'str'.
Parameters
str: The string - String - required
admin
string reverse "AZERTY"
mentdb
YTREZA
string right <str> <len>
Description
get every charcater starting from the end of the string 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 specified 'paddedLength' is larger than the size of the original array.
Parameters
str: The string - String - required
padString: The pad string - String - required
paddedLength: The end of the sub string - Number - required
admin
string rpad "azertyaze" "#" 10
mentdb
azertyaze#
string rtrim <str>
Description
removes space characters starting from the end of the string until another character 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 space - String - required
admin
string space "5"
mentdb
string split <str> <regex> <limit>
Description
Split a string with spaces used 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 an 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-alphanumerical characters as separators. If multiple non-alphanumerical characters are found, this function will still split the sentence without putting any non-alphanumerical characters in the words.
Parameters
str: The string - String - required
chars: The chars separator - 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 each character's ASCII decimal form to an 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 returns the difference from their ASCII decimal form. If it returns 0, it means that the function found no differences, in any other cases it means that 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 occurence between the two sent strings has been found. It will always return the lowest index possible. Returns -1 if no ocucrences are 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 occurence between the two sent strings has been found. It will always return the lowest index possible. Returns -1 if no ocucrences are found
Parameters
str1: The string - String - required
str2: The string - String - required
fromIndex: starting to index - Number - required
admin
string strpos "azerty" "r" 4
mentdb
-1
string sublrchar <str> <numberDeleteChar>
Description
delete a number of char at the start and at the end of the string
Parameters
str: The string - String - required
numberDeleteChar: The number of char 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 begin of the sub string - 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 begin of the sub string - Number - required
endIndex: The end of the sub string - 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 begin of the sub string - 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 begin of the sub string - Number - required
endIndex: The end of the sub string - Number - required
admin
string substring "azertyaze" 3 5
mentdb
rt
string to_string <str>
Description
return a valid sql string data (example: 'i'am 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 state of the string to empty if the string 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 the string 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 character on the right, left and will put only one space if multiple 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 data (example: 'i'am 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 data (example: 'i''am a man')
Parameters
data: The data - String - required
admin
string txt2 "az'erty"
mentdb
'az''erty'
string ucase <str>
Description
converts all of the characters in this 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 an 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 of all the characters in this 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 else the function will return the string
Parameters
str: The string - String - required
admin
string zero "az'erty"
mentdb
az'erty
type is_matches_regex <str> <pat>
Description
This fucntion compares two strings to see if both of the strings are identical. With '.*' the function will try to autocomplete a word to see if a match occurs (ex : type is_matches_regex(azerty, .*er.*) Here .*er.* will be replaced by azerty)., in this case, it will still return true if it matches after autocompletion.
Parameters
str: the string - String - required
pat: the paterne - String - required
admin
type is_matches_regex "azerty" ".*ze.*"
mentdb
1
Innov-AI
Services
Supporters
Contact
About