Function |
Grammar |
Function |
Len |
Len (String|varname) |
Returns the number of characters within a string, or the number of bytes required to store a variable. |
Trim |
Trim (String) |
Remove the space before and after the string |
Ltrim |
Ltrim (String) |
Remove the space before the string |
Rtrim |
Rtrim (String) |
Remove the space after the string |
Mid |
Mid (String,start,length) |
Gets a length string from the start character of the string string, if the third argument is omitted to represent a string starting from the start character to the end of the string |
Left |
Left (String,length) |
To get a length string from the left side of a string string |
Right |
Right (String,length) |
To get a length string from the right of a string string |
LCase |
LCase (String) |
Converts all uppercase letters in string strings to lowercase letters |
UCase |
UCase (String) |
Converts all uppercase letters in a string string to uppercase letters |
StrComp |
StrComp (String1,string2[,compare]) |
Returns a comparison between the string1 string and the string2 string, if two strings are the same, returns 0 if less than 1, or 1 if greater than |
InStr |
INSTR (String1,string2 [, compare] ) |
Returns the position of the first occurrence of the string1 string in the string2 string |
Split |
Split (String1,delimiter [, count[, start] ]) |
Splits a string into a one-dimensional array based on delimiter, where delimiter is used to identify the substring bounds. If omitted, use a space ("") as the separator. The number of substrings returned by count,-1 indicates that all substrings are returned. Start is 1 to perform a text comparison, if 0 or omit to perform a binary comparison. |
Replace |
Replace(expression, find, replacewith[, compare[, count[, start]]]) |
Returns a string in which a specified number of substrings (find) is replaced with another substring (replacewith). |