Commonly used for interpreting and manipulating text fields.
Concatenate
|
Description |
Joins several text strings into one text string. |
|
Remark |
The "&" operator can be used instead of CONCATENATE to join text items. |
|
Example |
Ex. Concatenate(“This “, “is “, “one string!” ) – returns This is one string! |
Left
|
Description |
Returns the first character(s) of a text string. |
|
Remark |
The first argument is the string you want to display. The second argument is number of characters you want. |
|
Example |
Ex. Left(“example”, 2 ) – returns ex. |
Len
|
Description |
Returns the number of characters in a text string. |
|
Example |
Ex. Len(“example” ) – returns 7. |
Lower
|
Description |
Converts all uppercase letters in a text string to lowercase. |
|
Example |
Ex. Lower(“EXAMPLE” ) – returns example. |
Mid
|
Description |
Returns a specific number of characters from a text string starting where you specify. |
|
Remark |
Mid takes three input arguments: 1. The text string. |
|
Example |
Ex. Mid(“example” , 2, 3) – returns xam. |
NewLine
|
Description |
Begins a new line of text. |
|
Remark |
NewLine takes no arguments. |
|
Example |
Ex. NewLine() |
Replace
|
Description |
Replaces part of a text string. |
|
Remark |
Replace takes four input arguments: 1. The text string to partially replaced. |
|
Example |
Ex. Replace("example", 2, 3, "*") – returns e*ple. |
Right
|
Description |
Returns the last characters in a text string. |
|
Remark |
The first argument is the string you want to display. The second argument is number of characters you want. |
|
Example |
Ex. Right("example", 2) – returns le. |
Trim
|
Description |
Removes all spaces from text except for single spaces between words. |
|
Example |
Ex. Trim("This sentence has weird spacing.", 2) – returns This sentence has weird spacing. |
Upper
|
Description |
Converts text to uppercase. |
|
Example |
Ex. Upper("example") – returns EXAMPLE. |
Value
|
Description |
Converts a text string that represents a number to a number. |
|
Example |
Ex. Value("$1,000") – returns 1000. |