DOC 2.4.0
String

Like all languages, you have a few data manipulation functions.

string asciistring binstring bit_lengthstring charstring char_lengthstring char_to_intconcatstring csv_valuestring sentence_distancestring sentences_distancestring get_variablestring levenshtein_distancestring md5string shastring countstring 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

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 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


MentDB © 2012 - 2021 - Legal Notice