Basically what I have is an unsorted list that needs to get broken down into groupings.
I want the raw data in the zip file to end up like the formatted data without doing it by hand. Help me WATMM you're my only hope.
The groupings are as follows (since you can't attach docx files, what is this 1998?):
Regions (according to Industry Canada)
Asia and Oceania: Afghanistan, Bangladesh, Bhutan, Brunei Darussalam, Myanmar (Burma), Cambodia, China, East Timor, Hong Kong, India, Indonesia, Japan, Korea, North, Korea, South, Laos, Macau (Macao), Malaysia, Maldives, Mongolia, Nepal, Pakistan, Philippines, Singapore, Sri Lanka, Taiwan, Thailand, Vietnam, American Samoa, Australia, Christmas Island, Cocos (Keeling) Islands, Cook Islands, Fiji, French Polynesia, Guam, Heard/McDonald Island, Kiribati (incl. Tuvalu), Marshall Island, Micronesia, Nauru, New Caledonia, New Zealand, Niue, Norfolk Island, Palau, Papua New Guinea, Pitcairn Island, Samoa (Western), Solomon Islands, Tokelau, Tonga, U.S. Minor Outlying Islands, Vanuatu (New Hebrides), Wallis and Futuna Islands
Africa and Middle East: Algeria, Angola, Benin, Botswana, Bouvet Island, British Indian Ocean Territories, Burkina Faso, Burundi, Cameroon, Cape Verde, Central African Republic, Chad, Comoros, Congo (formerly Brazzaville), Congo (formerly Zaire), Côte-d'Ivoire, Djibouti, Equatorial Guinea, French Southern Territories, Gabon, Gambia, Ghana, Guinea, Guinea-Bissau, Kenya, Lesotho, Liberia, Madagascar, Malawi, Mali, Mauritania, Mauritius, Morocco, Mozambique, Namibia, Niger, Nigeria, Réunion Island, Rwanda, São Tomé and Principe, Senegal, Seychelles, Sierra Leone, South Africa, Saint Helena, Swaziland, Tanzania, Togo, Tunisia, Uganda, Western Sahara, Zambia (Zambi), Zimbabwe, Bahrain, Cyprus, Egypt, Eritrea, Ethiopia, Iran, Iraq, Israel, Jordan, Kuwait, Lebanon, Libya, Oman (formerly Muscat and Oman), Qatar, Saudi Arabia, Somalia, Sudan, Syria, Turkey, United Arab Emirates
Western Europe: Andorra, Austria, Belgium, Denmark, Faeroe Islands, Finland, France (incl. Monaco, French Antilles), Germany, Gibraltar, Greece, Iceland, Ireland, Italy (incl. Vatican City State), Luxembourg, Malta, Netherlands, Norway, Portugal, San Marino, Spain, Sweden, Switzerland, United Kingdom, Vatican City State
Eastern Europe: Albania, Armenia, Azerbaijan, Belarus (formerly Byelorussia), Bosnia-Hercegovina, Bulgaria, Croatia, Czech Republic, Czechoslovakia, Estonia, Georgia, Germany, East, Hungary, Kazakhstan, Kosovo, Kyrgyzstan, Latvia, Lithuania, Macedonia, Moldova, Montenegro, Poland, Romania, Russia, Serbia, Slovakia, Slovenia, Tajikistan, Turkmenistan, Ukraine, Uzbekistan, Yugoslavia - Serbia and Montenegro
Latin America: Anguilla, Antigua and Barbuda, Aruba, Bahamas, Barbados, Belize, Bermuda, British Virgin Islands, Cayman Islands, Costa Rica, Cuba, Dominica, Dominican Republic, El Salvador, Grenada, Guadeloupe, Guatemala, Haiti, Honduras, Jamaica, Martinique, Montserrat, Netherlands Antilles, Nicaragua, Panama, Saint Lucia, Saint Kitts and Nevis, Saint Vincent and the Grenadines, Trinidad and Tobago, Turks and Caicos Islands, Argentina, Bolivia, Brazil, Chile, Colombia, Ecuador, Falkland Islands, French Guiana, Guyana, Paraguay, Peru, Surinam, Uruguay, Venezuela, Mexico
Attached Files
canadaexports.zip 21.83KB
3 downloads