Select a code from a smart field

[#1]

Good evening,

I have a code made up of 10 digits where each piece represents an information.
An example:
abcdefghij
0123456789

"a" represents the continents - in which case 0 would be Africa.
"bc" represent countries - in this case would be Zimbabwe
"d" represents a state ....

and so on.

How to create lists?
Continents, countries, states, etc.

I need this because I have a table like this:

Code / Income / GDP

And now want to group (not sure if this is the right word), but wanted to make views by continent, country, state, etc. .

Any tips?


Hugs

Gledson

[Oleg_Troyansky]

I'd recommend creating Mapping Tables for each one of the lists, and then parsing the string into individual characters (using functions LEFT() and MID() ) and mapping individual characters to the corresponding fields, using the mapping tables.