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

< >

Extracts or replaces a single field, value, or sub-value of a dynamic array.

Delete()

Deletes a field, value, or sub-value from a dynamic array.

Extract statement

Fetches a field, value, or sub-value out of a dynamic array.

Field()

Extracts a sub-string expression using a specified delimiter character and position.

FieldStore()

Replaces, deletes, or inserts a sub-string into a larger string, using any specified delimiter.

InList()

Determines whether a specified value exists in a delimited list.

Insert()

Inserts a string as a new field, value, or sub-value in a dynamic array.

Locate, 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 statement

Fetches a field, value, or sub-value out of a dynamic array.

Replace()

Replaces a field, value, or sub-value in a dynamic array with a designated string.

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

  • No labels