Topic
No replies
Shailee
Shailee
3 Posts
ACCEPTED ANSWER

Pinned topic Lookup table values with spaces not being identified

‏2010-03-03T10:22:10Z |
Hi,

I know that .CLS file cannot classify values with spaces e.g. "United Kingdom". But I believe that this can be achieved using .TBL files. For e.g I created lookup tables for Province with following values in the given order:
"JAWA BARAT"
"PAPUA BARAT"
"RIAU KEPULAUAN"
PAPUA
RIAU

(all being unique and different values). But now when i use the following code:
*? = @province.tbl |
COPY_S [1] {PR}
RETYPE [1] 0

It correctly identifies the last two values (PAPUA and RIAU) but does not identify values with spaces ("JAWA BARAT").

Also I would like to know that since values like RIAU and PAPUA are valid values but are also a part of bigger strings like ("RIAU KEPULAUAN" and "PAPUA BARAT"). How to handle such cases that both are identified correctly as Provinces.

Pl Note that the actual list of values is huge, so I cant split the values into single words (for classification) and then concatenate them in the .PAT file.

Please help.

Thanks,
Shailee.