====== Dynamic Arrays ====== Commands listed in this section enable a procedure to manipulate data in OpenInsight format. For example, they allow you to add, delete, change, find, or sum data within the structure of OpenInsight' rows, or in dynamic arrays. ^Command^Description^ |[[angle_brackets_operator|< >]]|Extracts or replaces a single field, value, or sub-value of a dynamic array.| |[[delete_function|Delete(]])|Deletes a field, value, or sub-value from a dynamic array.| |[[extract|Extract statement]]|Fetches a field, value, or sub-value out of a dynamic array.| |[[field|Field()]]|Extracts a sub-string expression using a specified delimiter character and position.| |[[fieldstore|FieldStore(]])|Replaces, deletes, or inserts a sub-string into a larger string, using any specified delimiter.| |[[inlist|InList()]]|Determines whether a specified value exists in a delimited list.| |[[insert|Insert()]]|Inserts a string as a new field, value, or sub-value in a dynamic array.| |[[locate|Locate]], [[locate_by|Locate...By statement]]|Locates the position of a field, value, or sub-value in a string, then returns the value of that position. The By clause is for locating an item in an ordered array.| |[[remove|Remove statement]]|Fetches a field, value, or sub-value out of a dynamic array.| |[[replace|Replace()]]|Replaces a field, value, or sub-value in a dynamic array with a designated string.| |[[sum|Sum()]]|Sums the numeric values of the lowest level of a dynamic array, creating out of them a higher level (for example, summed sub-values become a value, summed values become a field).|