INVERT()

Top  Previous  Next

 

The INVERT() function "inverts" a dynamic array, transposing fields and values.

 

 

Format

 

INVERT(dyn.array)

 

where

 

dyn.arrayis the dynamic array to be inverted.

 

 

The INVERT() function returns a new dynamic array in which the fields of dyn.array become values and the values of dyn.array become fields. Other mark characters are treated as part of the data.

 

 

 

Example

 

If DYN contains  AVMBVMCFMDVME

STR = INVERT(DYN)

will set STR to AVMDFMBVMEFMC