String Manipulation
String manipulation commands allow you to find, add, change, delete, or count characters in a variable.
| Command | Description |
|---|---|
| [n,m] | Extracts or assigns m characters starting at column n from or to a string. |
| Char() | Returns the ASCII character string value of an expression. |
| Col1(), Col2() | Returns the column positions of delimiters used by the Field and Bracket ([ ]) commands. |
| Convert statement | Converts a set of characters in a string into a different set of character. |
| Count() | Counts repetitions of a particular character (or string of characters) in a string. |
| Delete() | Use to delete elements from a dynamic array. Data can be deleted from field, value, and subvalue positions. |
| Field() | Returns successive fields which precede a defined delimiter. |
| FieldStore() | Used to replace, delete, or insert substrings in a string. |
| Index() | Returns starting column location of a designated occurrence of a sub-string. |
| Insert() | Used to insert a field, value, or subvalue into a character string dynamic array. |
| Len() | Returns length of a specified string. |
| Locate statement | Locates the position of a field, value, or sub-value in a string, returns the value of that position. By clause is used for locating a position where an item should be inserted. |
| MatParse statement | Turns a dynamic array into a dimensioned array. |
| MatUnparse() | Turns a dimensioned array into a dynamic array. |
| Seq() | Returns the ASCII sequence of a character. |
| Swap statement | Exchanges all occurrences of one sub-string in a string for another. |
| Trim(),TrimB(), TrimF() | Deletes extra blank spaces from a character string or variable. TrimB() deletes blank spaces at the end of a character string. TrimF() deletes spaces from the from of a character string. |