Category
General-Purpose Functions
Description
Use the top N digits of a number to make a new number
Syntax
Top(value, digits)
Parameters
value - the number to get top digits from
digits - the count of digits to get
Notes
This function was added to make it easier to use different levels of the TRBC industry codes, though it can be used with any numeric value.
The TRBC codes are 10-digit numbers from which every pair of digits going from left to right makes the industry designation more specific.
For the economic sector code, use Top(TRBC, 2).
For the business sector code, use Top(TRBC, 4).
For the industry group code, use Top(TRBC, 6).
For the specific industry code, use Top(TRBC, 8).
|