SUBSTRINGS()

SUBSTRINGS()

Top  Previous  Next

 

The SUBSTRINGS() function performs substring extraction on successive elements of a dynamic array, returning a similarly structured dynamic array of results.

 

 

Format

 

SUBSTRINGS(dyn.array, start, length)

 

where

 

dyn.arrayis the dynamic array to be processed.

 

startis the start position for extraction of each substring.

 

lengthis the length of each extracted substring.

 

 

The SUBSTRINGS() function is the multivalued equivalent of the substring extraction operator [start, length] and processes each element of dyn.array in turn to produce a result dynamic array.

 

 

Example

 

A contains  ABCDEFMFGHIJVMKLMNOVMPQRST

 

B = SUBSTRINGS(A, 2, 3)

 

B will contain BCDFMGHIVMLMNVMQRS