String manipulation is, in most cases changing the string in one way or another.
Each of the examples below are functions, which means they return a value. Generally, you will find them on the right side of an assignment statement. Italicized words would be replaced with a variable name, constant name, or a literal.
Description Visual Basic Java Length of the string Length(string) NameLength = Length(FirstName)
string.length() nameLength = firstName.length();
Change all letters to uppercase UCASE(string) UpperName = UCASE(FirstName)
string.toUpperCase() upperName = firstName.toUpperCase();
Change all letters to lowercase LCASE(string) LowerName = LCASE(FirstName)
string.toLowerCase() lowerName = firstName.toLowerCase();
Find where a substring exists in a string Instr(string, substring)
Instr(startPos, string, substring)HelloStart = Instr(Greeting, "Hello")
string.indexof(substring)
string,indexOf(substring, fromIndex)helloStart = greeting.indexOf("Hello");
Extract a part of the string Left(string, nbrOfChars)
Right(string, nbrOfChars)
Mid(string, startPos, nbrOfChars)
Mid(string, startPos)LeftSubString = Left(Greeting, 5)
RightSubString = Right(Greeting, 5)
MiddleSubString = Mid(Greeting, 3, 5)string.substring(beginIndex, endIndex)
string.substring(beginIndex)
theSubstring = greeting.substring(3, 5)
Trimming spaces off the ends Trim(string)
LTrim(string)
RTrim(string)string.trim();