String Functions

Retrieves the length of a string.

string STRLEN( string )

Retrieves the length of a string in MBCS (Multi-byte character set).

string STRLENB( string )

Converts all uppercase letters in a string string to lowercase.

string LOWER( string )

Converts string to uppercase.

string UPPER( string )

Makes a string's first character uppercase.

string UCFIRST( string )

Converts the first character of each word in a string to uppercase.

string UCWORDS( string )

Returns the code number of character.

Number CODE( string ,[pos] )

Note: The parameter pos is optional, its default value is 0.

Returns the character specified by the code number.

string CHAR( number )

Calculates the similarity between two strings.

number STRSIMILAR( string1, string2 )

Inserts a sub-string at the given position within string..

string STRINSERT( string, pos, string_to_insert )

A negative value of the parameter pos is used to specify the position from the end of the string.

Repeats string a given number of times.

string STRREPT( string, num_times )

Joins array elements with a string.

string JOIN( string, separator )

Pads a string with leading string to a certain length.

string PADLEFT( string, pad_length, pad_string, [is_repeat_mode] )

The default value of the parameter is_repeat_mode is FALSE.

Pads a string with trailing string to a certain length.

string PADRIGHT( string, pad_length, pad_string, [is_repeat_mode] )

The default value of the parameter is_repeat_mode is FALSE.

Formats a number as a currency string for a locale specified.

string FORMAT_MONEY( number )

Note: The function will use the current local settings of Windows to convert the number.

Returns the formatted date string.

string FORMAT_DATE( datetime, [format_string] )

Note: About the format string, you please refer to the action Format Date and Time.

Replaces all occurrences of the search string with the replacement string.

string REPLACE( string, find_string, new_string )

Note: This function can be used to remove all occurrences of the search string. The comparison is case-sensitive.

Replaces multiple substrings at a time.

string REPLACE_M( string, substrs, replaces, [,is_replace_all], [,separator] )

The default value of the parameter is_replace_all is TRUE, and the separator is the semi-colon character.

Examples:

Splits the string into a sequence of sub-strings by the separator, then replaces one of the sub-strings.

string REPLACE_SUB( string, separator, which_part, replace_text )

The parameter which_part is zero based.

Removes whitespace from the beginning of a string.

string TRIMLEFT( string )

Removes whitespace from the end of a string.

string TRIMRIGHT( string )

Removes spaces from the beginning and end of a string.

string TRIM( string )

Removes one or more characters from a string.

string REMOVECHAR( string, characters )

Removes all nonprintable characters from string.

string STRCLEAN( string )

Note: Any character that is not a displayable ASCII character is removed from the string, included CRLF.

Returns the specified number of characters from the begging of a string.

string LEFT( string, num_characters )

Returns the specified number of characters from the begging of a string in MBCS (Multi-byte character set).

string LEFTB( string, num_characters )

Returns the rightmost characters from a string value.

string RIGHT( string, num_characters )

Returns the rightmost characters from a string value in MBCS (Multi-byte character set).

string RIGHTB( string, num_characters )

Returns a specific number of characters from a string string starting at the position you specify.

string MID( string, pos, [num_characters] )

Note the parameter num_characters is optional, the default value is 1, omiting it does mean get all characters from the position pos to the end of the string.

Returns a specific number of characters from a string string starting at the position you specify in in MBCS (Multi-byte character set). The default value of the parameter num_characters is 1.

string MIDB( string, pos, [num_characters] )

Splits the string into a sequence of sub-strings, then pick one of them.

string STRPICK( string, separator, index_of_substring )

The parameter index_of_substring is zero based. The parameter separator can be a single character or a string.

Gets the difference between two strings.

string STRDIFFER( string1, string2, [return_difference] )

If the parameter return_difference is TRUE (default value TRUE), the characters in string1 which are not in the string2 will be returned. If the parameter return_difference is FALSE, the characters in string1 which are in the string2 will be returned.

Examples:

Finds the first occurrence of a string.

string STRSTR( string, find_string )

Note: The comparison is case-sensitive. This function returns an empty string if failed.

Finds the first occurrence of a case-insensitive string.

string STRSTRI( string )

Finds the position of the nth occurrence of a substring in a string.

Number STRPOS( string, find_string, [index_of_sequence] )

The default value of the parameter index_of_sequence is 0.
Note: This function returns -1 if failed. The comparison is case-sensitive.

Finds the position of the nth occurrence of a case-insensitive substring in a string.

Number RSTRPOS( string, find_string, [index_of_sequence] )

The default value of the parameter index_of_sequence is 0.

Reverses find the index position of the nth occurrence of a substring in a string. The default value of the parameter index_of_sequence is 0.

Number RSTRPOS( string, find_string, [index_of_sequence] )

Note: This function returns -1 if failed. The comparison is case-sensitive.

Reverses find the position of the nth occurrence of a case-insensitive substring in a string.

Number RSTRPOSI( string, find_string, [index_of_sequence] )

The default value of the parameter index_of_sequence is 0.

Encodes a string with MIME base64.

string BASE64_ENCODE( string_or_binary_data )

Decodes a string with MIME base64.

string BASE64_DECODE( string [, data_type])

The parameter data_type can be one of the follow:

• 0 (Default value) -- The decoded data is a string.
• 1 -- The decoded data is an ANSI string.
• 2 -- The decoded data is a binary data.

Note: The parameter string should be a valid based64 encoded string.

Calculates the md5 hash of a string.

string MD5( string )

Calculates HMAC-SHA1 of a string.

string HMAC_SHA1( string, key )

Calculates SHA1 of a string.

string SHA1( string )

Encrypts a string with AES256.

string AESENC( string, password )

Decrypts an encrypted string by AES256.

string AESDEC( string, password )

Encode a string by URL specification.

string URLENC( string )

Decodes a URL encoded string.

string URLDEC( string )

Parses a URL and retrieves a component.

string URLPARSE( url, parseaction )

The parameter parseaction specifies the information to parse from the URL, it can be one of the follow:

• DOMAIN Return the domain name for this URL.
• SITE Return the site associated with this URL.
• SCHEMA Retrieve the schema for this URL.

Searches a string for a match against a regular expression, and returns the matches.

string REGEXP_FIND( string, pattern[, flags, separator, offset] )

Parameters:

• string The string to search for a match.
• pattern The regular expression pattern to match.
• flags Provides options for matching. The value is a string containing any combination of the following values:
• i Performs a match without regard to case.
• g Performs a global match (find all matches rather than stopping after the first match).
• separator A string, if flags includes g, all matches will be joined by this string. The default separator is the semicolon ;
• offset The search starting position. If?offset?is a negative number, the position starts counting from the end of the string.

Examples:

Returns the zero-based index of the first occurrence of the specified pattern in a string, or -1 if it is not.

number REGEXP_INDEXOF( string, pattern[, offset, flags] )

Parameters:

• string The string to search for a match.
• pattern The regular expression pattern to match.
• offset The search starting position. If?offset?is a negative number, the position starts counting from the end of the string.
• flags Provides options for matching. The value is a string containing any combination of the following values:
• i Performs a match without regard to case.
• g Performs a global match (find all matches rather than stopping after the first match).

Examples:

Searches a string for a regular expression, and returns a new string where the specified values are replaced.

string REGEXP_REPLACE( string, pattern[, new_substr, flags, offset] )

Parameters:

• string The string to search for a match.
• pattern The regular expression pattern to match.
• new_substr The string to substitute the match.
• flags Provides options for matching. The value is a string containing any combination of the following values:
• i Performs a match without regard to case.
• g Performs a global match (find all matches rather than stopping after the first match).
• offset The search starting position. If?offset?is a negative number, the position starts counting from the end of the string.

Examples: