Commonly used for interpreting and manipulating text fields.
The "&" operator can be used instead of CONCATENATE to join text items.
Ex. Concatenate(“This “, “is “, “one string!” ) – returns This is one string!
Returns the first character(s) of a text string.
The first argument is the string you want to display. The second argument is number of characters you want.
Ex. Left(“example”, 2 ) – returns ex.
Ex. Len(“example” ) – returns 7.
Ex. Lower(“EXAMPLE” ) – returns example.
Returns a specific number of characters from a text string starting where you specify.
2. The place you want to start.
3. The number of characters you want to display.
Ex. Mid(“example” , 2, 3) – returns xam.
Begins a new line of text.
Replaces part of a text string.
1. The text string to partially replaced.
2. The place you want to start replacing.
3. The number of characters to replace.
3. The string you want to substitute.
Ex. Replace("example", 2, 3, "*") – returns e*ple.
Returns the last characters in a text string.
Ex. Right("example", 2) – returns le.
Ex. Trim("This sentence has weird spacing.", 2) – returns This sentence has weird spacing.
Ex. Upper("example") – returns EXAMPLE.
Ex. Value("$1,000") – returns 1000.