| 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. |
| | |