Function | What Does it do? | Example | Result |
Len(str) | Returns the length of the string | Len(“Hello”) | 5 |
Ucase(str) | Changes the string to upper case | Ucase(“Hello”) | HELLO |
Lcase(str) | Changes the string to lower case | Lcase(“Hello”) | hello |
Left(str, num) | Shorten the string from the left | Left(“Hello”,3) | Hel |
Right(str, num) | Shorten the string from the right | Right(“Hello”,3) | llo |
Mid(str, start, length) | Extract the middle of a string | Mid(“Hello”,2,2) | el |
Instr(start, look in this string, find this string) | Find if a string is in another string | Instr(0,”Hello there”,”Hello”) | 1 |
Trim(str) | Removes preceding and trailing spaces | Trim(” hello there “) | hello there |
LTrim(str) | Removes spaces from the beginning of a string | Ltrim(” hello “) | hello |
Rtrim(str) | Removes spaces from the end of a string | Rtrim(” hello “) | hello |
String(num, char) | Repeats the char num times | String(2, “a”) | aa |
Space(num) | Makes a certain num of spaces | Space(2) | |
Cint(str) | Change a string to a integer | Cint(111.1) | 111 |
Clng(str) | Change a string to a long (use if you get an overflow error) | Clng(111.1) | 111 |
Cdbl(str) | Change a string to a double | Cdbl(111.1) | 111.1 |
Split(str,delimiter) | Split a string into an array | Split(“Hello,There,Friend”, “,”) | (0) = Hello (1) = There (2) = Friend |
Join(array, delimiter) | Join an array into a string | Join(array(“Hello”, “There”, “Friend”),”,”) | Hello,There,Friend |