These are the codes I had to map (hope the bit of Java is okay). The first three seem like definites, the last four are more up for grabs I'd say as they are
ISO_3_EXCEPTIONS_MAP.put("FIJ", "FJI"); // Fiji
ISO_3_EXCEPTIONS_MAP.put("SEY", "SYC"); // Seychelles
ISO_3_EXCEPTIONS_MAP.put("TAN", "TZA"); // Tanzania
ISO_3_EXCEPTIONS_MAP.put("ZAN", "EAZ"); // Zanzibar (for future, maybe)
ISO_3_EXCEPTIONS_MAP.put("IMN", "IMY"); // Isle of Man
ISO_3_EXCEPTIONS_MAP.put("JEY", "GBJ"); // Jersey (for future, maybe)
ISO_3_EXCEPTIONS_MAP.put("GGY", "GBG"); // Guernsey(for future, maybe)
As for the other matter. I think comma separated is fine, but you probably just need to take quoted string as literals (so if a comma exists in the name it the name the country has to be quoted e.g. France, United Kingdom, "Hong Kong, China SAR". That is how Excel handles it. What language is the core of your system written in? I haven't done any Flash stuff and my Javascript skills are rudimentary but I could help out if it is Java or php (actually, I can recommend a library that takes care of this if you are using Java).
Hi Frank, Thanks for the
Hi Frank,
Thanks for the quick reply.
These are the codes I had to map (hope the bit of Java is okay). The first three seem like definites, the last four are more up for grabs I'd say as they are
ISO_3_EXCEPTIONS_MAP.put("FIJ", "FJI"); // Fiji
ISO_3_EXCEPTIONS_MAP.put("SEY", "SYC"); // Seychelles
ISO_3_EXCEPTIONS_MAP.put("TAN", "TZA"); // Tanzania
ISO_3_EXCEPTIONS_MAP.put("ZAN", "EAZ"); // Zanzibar (for future, maybe)
ISO_3_EXCEPTIONS_MAP.put("IMN", "IMY"); // Isle of Man
ISO_3_EXCEPTIONS_MAP.put("JEY", "GBJ"); // Jersey (for future, maybe)
ISO_3_EXCEPTIONS_MAP.put("GGY", "GBG"); // Guernsey(for future, maybe)
I took the info from http://en.wikipedia.org/wiki/ISO_3166-1_alpha-3.
As for the other matter. I think comma separated is fine, but you probably just need to take quoted string as literals (so if a comma exists in the name it the name the country has to be quoted e.g. France, United Kingdom, "Hong Kong, China SAR". That is how Excel handles it. What language is the core of your system written in? I haven't done any Flash stuff and my Javascript skills are rudimentary but I could help out if it is Java or php (actually, I can recommend a library that takes care of this if you are using Java).
Cheers,
Andy