String Functions

Retrieve the length of a string.

string STRLEN( 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 )

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

string STRINSERT( string, pos, string_to_insert )

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.

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 )

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

string LEFT( string, num_characters )

Returns the rightmost characters from a string value.

string RIGHT( 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, omiting it does mean get all characters from the position pos to the end of the 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 )

Finds the first occurrence of a string.

string STRSTR( string, find_string )

Note: The comparison is case-sensitive. This function returns a 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, [num_sequence] )

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, [num_sequence] )

Reverses find the index position of the nth occurrence of a substring in a string.

Number RSTRPOS( string, find_string, [num_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, [num_sequence] )

Repeats string a given number of times.

string STRREPT( string, num_times )

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.

Encodes a string with MIME base64.

string BASE64_ENCODE( string )

Decodes a string with MIME base64.

string BASE64_DECODE( string )

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

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.

Calculates the md5 hash of a string.

string MD5( string )