Correlatives are used to correlate and process raw data either within a file or between files; conversions are used to convert the format of raw or correlated data before it is output. Correlatives are located in Attribute 8 of an Attribute Definition item, conversions are located in Attribute 7.
The table below summarizes all the correlative and conversion processing codes.
|
Code |
Usual Use |
Description |
|
Corr |
Performs arithmetic calculations. |
|
|
Corr |
Allows mvBASIC subroutines to process data from within an Attribute Definition item. |
|
|
Corr |
Concatenates attribute values. |
|
|
Conv |
Converts dates to output format. |
|
|
Corr |
Performs mathematical functions using the stack. |
|
|
Corr |
Extracts groups of characters from an attribute. |
|
|
Corr |
Extracts data that falls within a specified length. |
|
|
Conv |
Extracts alphabetic or numeric characters, or converts character cases. |
|
|
Conv |
Converts decimal numbers to hexadecimal equivalents. |
|
|
Conv |
Converts hexadecimal numbers to decimal equivalents. |
|
|
Conv |
Formats and left-justifies numbers and dollar amounts. |
|
|
Conv |
Formats and right-justifies numbers and dollar amounts. |
|
|
Conv |
Converts times to output format. |
|
|
Conv |
Converts ASCII character strings to hexadecimal equivalents. |
|
|
Conv |
Converts hexadecimal character strings to ASCII equivalents. |
|
|
Corr |
Extracts data that matches a specified pattern. |
|
|
Corr |
Extracts data that falls within a specified range. |
|
|
Corr |
Substitutes data from another attribute, or a character string, for the data in the referenced attribute. |
|
|
Corr |
Extracts characters from the data in an attribute. |
|
|
Corr |
Translates data stored in another file. |
See Also
Using INFO/ACCESS Correlatives and Conversions
Introduction to Correlatives and Conversions