C |
Index: C D E F L Q S Symbol Code |
CATS | Concaternates strings in each corresponding element of a pair of dynamic arrays. |
COL1 | Only works in conjunction with a FIELD statment. |
COL2 | Only works in conjunction with the FIELD statement. |
COUNT | Counts the number of delimiters. |
COUNTS | Counts instances in a dynamic array. |
D |
Index: C D E F L Q S Symbol Code |
DCOUNT | Counts the number of delimited fields. |
DEL | Deletes elements from a dynamic array. |
DQUOTE | Surronds a string with Double quotes. |
E |
Index: C D E F L Q S Symbol Code |
EQS | Compares each element in the first dynamic array with each element in the second dynamic array, returning a dynamic array full of 1s (matches) and 0s (mismatches). |
F |
Index: C D E F L Q S Symbol Code |
FIELD | Used to return a substring from a string located between a specified delimiter. |
L |
Index: C D E F L Q S Symbol Code |
LEN | Returns the number of characters in a string. |
LENDP | This variation on the LEN command distinguishes between byte length and display length, since NLS supports multi-byte characters. |
LENS | Determines the length of each element in a dynamic array. |
LENSDP | This variation on the LENS command distinguishes between byte length and display length, since NLS supports multi-byte characters. |
Q |
Index: C D E F L Q S Symbol Code |
QUOTE | Encloses a variable, literal, or expression result in double quotes. |
S |
Index: C D E F L Q S Symbol Code |
SQUOTE | Surronds a string with Single quotes. |
STR | Creates a repeating string. |
Symbol |
Index: C D E F L Q S Symbol Code |
: | Concaternates strings |
Code |
Index: C D E F L Q S Symbol Code |
COUNT | Example of different counting options. |
| | |