====== String Manipulation ======

 

String manipulation commands allow you to find, add, change, delete, or count characters in a variable.

 

^Command^Description^
|[[brackets_operator|[n,m]]]|Extracts or assigns m characters starting at column n from or to a string.|
|[[char|Char()]]|Returns the ASCII character string value of an expression.|
|[[col1|Col1()]], [[col2|Col2()]]|Returns the column positions of delimiters used by the Field and Bracket ([ ]) commands.|
|[[convert|Convert statement]]|Converts a set of characters in a string into a different set of character.|
|[[count|Count()]]|Counts repetitions of a particular character (or string of characters) in a string.|
|[[delete_function|Delete()]]|Use to delete elements from a dynamic array. Data can be deleted from field, value, and subvalue positions.|
|[[field|Field()]]|Returns successive fields which precede a defined delimiter.|
|[[fieldstore|FieldStore()]]|Used to replace, delete, or insert substrings in a string.|
|[[index|Index()]]|Returns starting column location of a designated occurrence of a sub-string.|
|[[insert|Insert()]]|Used to insert a field, value, or subvalue into a character string dynamic array.|
|[[len|Len()]]|Returns length of a specified string.|
|[[locate|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|MatParse statement]]|Turns a dynamic array into a dimensioned array.|
|[[matunparse|MatUnparse()]]|Turns a dimensioned array into a dynamic array.|
|[[seq|Seq()]]|Returns the ASCII sequence of a character.|
|[[swap|Swap statement]]|Exchanges all occurrences of one sub-string in a string for another.|
|[[trim|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.|