FX - String @ Data transformation (ETL) @ MentDB Weak
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 zerotype is_matches_regex
string ascii <chr>
Description
convert a character to integer
convert a character to integer
Parameters
chr: The string - String - required
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
returns a string representation of the binary value of n, where n is a long (bigint) number
Parameters
num: The number - Number - required
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
returns the length of the string str in bits
Parameters
str: The string - String - required
str: The string - String - required
admin
string bit_length 61
mentdb
16
string char <num>
Description
convert an integer to a character
convert an integer to a character
Parameters
num: The number - Number - required
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.
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
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
convert a character to an integer using the ASCII classification
Parameters
chr: The string - String - required
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)
concat all parameters (do not use this function with string before)
Parameters
str1: The string - String - required
strN: The string - String - required
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
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
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
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
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
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
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
Return an ordered array of string
Parameters
jsonArray: A JSON Array - String - required
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
To get variables from a string
Parameters
input: The input - String - required
pattern: The pattern ([1] for the first variable) - String - required
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
To get the levenshtein distance (length difference) between two strings
Parameters
word1: The word 1 - String - required
word2: The word 2 - String - required
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
get the md5
Parameters
str: The string - String - required
str: The string - String - required
admin
string md5 "admin"
mentdb
21232f297a57a5a743894a0e4a801fc3
string sha <str>
Description
get the sha
get the sha
Parameters
str: The string - String - required
str: The string - String - required
admin
string sha "admin"
mentdb
d033e22ae348aeb5660fc2140aec35850c4da997
string sha_256 <str>
Description
get the sha 256
get the sha 256
Parameters
str: The string - String - required
str: The string - String - required
admin
string sha_256 "admin"
mentdb
8c6976e5b5410415bde908bd4dee15dfb167a9c873fc4bb8a81f6f2ab448a918
string count <string> <find>
Description
count the number of occurences of a string in another string
count the number of occurences of a string in another string
Parameters
string: The string - String - required
find: The string - String - required
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
Hash a string with bcrypt
Parameters
password: The password - String - required
strength: The strength - Number - required
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
Verify a password with bcrypt
Parameters
password: The password - String - required
hash: The hash - String - required
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 sign encryption
Generate a key pair for sign encryption
Parameters
keysize: The key size - String - required
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
Get a signature from a string
Parameters
data: The data string - String - required
privateKey: The private key - String - required
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
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
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
Generate a key pair for RSA encryption
Parameters
keysize: The key size - String - required
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
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
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
Decode a string from DES algorithm
Parameters
data: The data string - String - required
privateKey: The private key - String - required
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
Generate a key for DES encryption
Parameters
keysize: The key size - String - required
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
Encode a string into DES algorithm
Parameters
data: The data string - String - required
secretKey: The secret key - String - required
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
Decode a string from DES algorithm
Parameters
data: The data string - String - required
secretKey: The secret key - String - required
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
Encode a string into blowfish algorithm
Parameters
data: The data string - String - required
secretKey: The secret key - String - required
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
Decode a string from blowfish algorithm
Parameters
data: The data string - String - required
secretKey: The secret key - String - required
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
Encode a string into PBE algorithm
Parameters
data: The data string - String - required
password: The password - String - required
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
Decode a string from PBE algorithm
Parameters
json_data: The json data and parameters string - String - required
password: The password - String - required
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
encode a string into b64
Parameters
string: The string - String - required
string: The string - String - required
admin
string encode_b64 "azerty"
mentdb
YXplcnR5
string decode_b64 <string>
Description
decode a string from b64
decode a string from b64
Parameters
string: The string - String - required
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
delete a number of char on each lines
Parameters
data: The data - String - required
nbChar: The number of chars - Number - required
data: The data - String - required
nbChar: The number of chars - Number - required
admin
string del_char_before_each_line "sdlfkjdf dfgdfgdfgdfgd" 4
mentdb
kjdf fgdfgdfgd
string mql_to_html <mql>
Description
Convert a MQL source code to HTML
Convert a MQL source code to HTML
Parameters
mql: The mql source code - String - required
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
check if a value ends with another string
Parameters
stringValue: The string - String - required
stringToEnd: The end string - String - required
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.
returns the string with the first letter in uppercase and the rest of the string in lowercase.
Parameters
str: The string - String - required
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.
returns the first letter from a string.
Parameters
str: The string - String - required
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.
generate a random string with the length of the random string as parameter.
Parameters
size: The size of the string - String - required
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
returns a string representation of the hexadecimal value of num, where num is a long int (bigint) number
Parameters
num: The number - Number - required
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
convert an hexadecimal number to long int (bigint) number
Parameters
hex: The hex number - String - required
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.
get the ASCII character associated to an hexadecimal number.
Parameters
hex: The hexadecimal number - String - required
hex: The hexadecimal number - String - required
admin
string hex_to_str 61
mentdb
a
string indent <str> <nbSpaceBefore>
Description
returns the indented string
returns the indented string
Parameters
str: The string - String - required
nbSpaceBefore: The string - String - required
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
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
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
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
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
convert an integer to character
Parameters
num: The number - Number - required
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
returns a string representation of the hexadecimal value of n, where n is a long int (bigint) number
Parameters
num: The number - Number - required
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
returns a string representation of the octal value of n, where n is a long int (bigint) number
Parameters
num: The number - Number - required
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
check if a value contains only letters
Parameters
value: The value - String - required
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
check if a value contains only letters, underscore char or numbers
Parameters
value: The value - String - required
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
check if a value contains only letters or numbers
Parameters
value: The value - String - required
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
check if a value contains only number char
Parameters
value: The value - String - required
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
transform multiple spaces by only one space between strings
Parameters
str: The string - String - required
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
converts all of the characters in this string to lower case using the rules of the default locale
Parameters
str: The string - String - required
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.
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
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.
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
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
performs a pattern match of a string expression expr against a pattern pat
Parameters
str: the string - String - required
pat: the paterne - String - required
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
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
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
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
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
converts all of the characters in this string to lower case using the rules of the default locale
Parameters
str: The string - String - required
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
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
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
returns the string without space character on the left and on the right
Parameters
str: The string - String - required
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
returns the string without 0 character on the left and on the right
Parameters
str: The string - String - required
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.
removes the space characters at the beginning of a string until a different character if found.
Parameters
str: The string - String - required
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.
Verify if two strings are matching, the use of '.*' for autocompletion is handled.
Parameters
str: the string - String - required
pat: the paterne - String - required
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.
returns a new string starting at index.
Parameters
str: The string - String - required
index: The begin of the sub string - Number - required
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.
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
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.
verify if two strings are different.
Parameters
str: the string - String - required
pat: the paterne - String - required
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.
verify if two strings are different.
Parameters
str: the string - String - required
pat: the paterne - String - required
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.
convert num which is an int to an octal form.
Parameters
num: The number - Number - required
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).
convert oct which is an octal number to long int (bigint).
Parameters
oct: The octal number - String - required
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.
returns the index at which the first occurence has been found.
Parameters
str1: The string - String - required
str2: The string - String - required
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
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
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.
verify if two strings are identical.
Parameters
str: the string - String - required
pat: the paterne - String - required
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.
returns count number of times the string that was passed as parameter.
Parameters
str: The string - String - required
count: The count number - Number - required
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
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
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.
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
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'.
returns the inverted form of 'str'.
Parameters
str: The string - String - required
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.
get every charcater starting from the end of the string to len.
Parameters
str: The string - String - required
len: The length - Number - required
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.
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
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.
removes space characters starting from the end of the string until another character than space is found.
Parameters
str: The string - String - required
str: The string - String - required
admin
string rtrim " azerty "
mentdb
azerty
string space <count>
Description
returns a string composed of n space characters
returns a string composed of n space characters
Parameters
count: The number of space - String - required
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.
Split a string with spaces used as separators.
Parameters
str: The string - String - required
regex: The regex - String - required
limit: The limit - Number - required
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
Split an MQL source code
Parameters
str: The string - String - required
index: The index position - Number - required
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.
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
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.
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
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.
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
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.
converts each character's ASCII decimal form to an hexadecimal form.
Parameters
str: The string - String - required
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.
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
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.
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
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
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
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
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
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.
returns the original string starting at the sent index.
Parameters
str: The string - String - required
index: The begin of the sub string - Number - required
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'.
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
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.
returns the original string starting at the sent index.
Parameters
str: The string - String - required
index: The begin of the sub string - Number - required
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'.
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
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')
return a valid sql string data (example: 'i'am a man')
Parameters
str: The string - String - required
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
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
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 = '')
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
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)
set the string to null if the string is empty (ex : str = '', null_if_empty(str)-> str = NULL)
Parameters
str: The string - String - required
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.
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
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')
return a valid sql string data (example: 'i'am a man')
Parameters
data: The data - String - required
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')
return a valid sql string data (example: 'i''am a man')
Parameters
data: The data - String - required
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
converts all of the characters in this string to upper case using the rules of the default locale
Parameters
str: The string - String - required
str: The string - String - required
admin
string ucase "azerty"
mentdb
AZERTY
string unhex <hex>
Description
convert an hexadecimal number to a long int(bigint).
convert an hexadecimal number to a long int(bigint).
Parameters
hex: The hex number - String - required
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
converts of all the characters in this string to upper case using the rules of the default locale
Parameters
str: The string - String - required
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
return 0 if 'str' is an empty string else the function will return the string
Parameters
str: The string - String - required
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.
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
str: the string - String - required
pat: the paterne - String - required
admin
type is_matches_regex "azerty" ".*ze.*"
mentdb
1