Last active
September 4, 2019 12:31
-
-
Save kashipai/9068134b9e91bc283c5e9ac25f53deb6 to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // use jquery in the webpage to fetch the text of each of the rows from the table. | |
| $(temp).find('tr').each( function(index, element) { $(element).find('td').each(function(index2,element2){ console.log($(element))})}); | |
| // Then using the following regex setup a text file for replace. | |
| ([a-z|A-Z|\-|\.|\s]+)([0-9|\-|\,|\s]+)([A-Z]{2})\s\/\s([A-Z]{3})(.*) | |
| //the final output should be good enough for a csv file | |
| ' Afghanistan','93','AF','AFG' |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 'Afghanistan' | '93' | 'AF' | 'AFG' | |
|---|---|---|---|---|
| 'Albania' | '355' | 'AL' | 'ALB' | |
| 'Algeria' | '213' | 'DZ' | 'DZA' | |
| 'American Samoa' | '1-684' | 'AS' | 'ASM' | |
| 'Andorra' | '376' | 'AD' | 'AND' | |
| 'Angola' | '244' | 'AO' | 'AGO' | |
| 'Anguilla' | '1-264' | 'AI' | 'AIA' | |
| 'Antarctica' | '672' | 'AQ' | 'ATA' | |
| 'Antigua and Barbuda' | '1-268' | 'AG' | 'ATG' | |
| 'Argentina' | '54' | 'AR' | 'ARG' | |
| 'Armenia' | '374' | 'AM' | 'ARM' | |
| 'Aruba' | '297' | 'AW' | 'ABW' | |
| 'Australia' | '61' | 'AU' | 'AUS' | |
| 'Austria' | '43' | 'AT' | 'AUT' | |
| 'Azerbaijan' | '994' | 'AZ' | 'AZE' | |
| 'Bahamas' | '1-242' | 'BS' | 'BHS' | |
| 'Bahrain' | '973' | 'BH' | 'BHR' | |
| 'Bangladesh' | '880' | 'BD' | 'BGD' | |
| 'Barbados' | '1-246' | 'BB' | 'BRB' | |
| 'Belarus' | '375' | 'BY' | 'BLR' | |
| 'Belgium' | '32' | 'BE' | 'BEL' | |
| 'Belize' | '501' | 'BZ' | 'BLZ' | |
| 'Benin' | '229' | 'BJ' | 'BEN' | |
| 'Bermuda' | '1-441' | 'BM' | 'BMU' | |
| 'Bhutan' | '975' | 'BT' | 'BTN' | |
| 'Bolivia' | '591' | 'BO' | 'BOL' | |
| 'Bosnia and Herzegovina' | '387' | 'BA' | 'BIH' | |
| 'Botswana' | '267' | 'BW' | 'BWA' | |
| 'Brazil' | '55' | 'BR' | 'BRA' | |
| 'British Indian Ocean Territory' | '246' | 'IO' | 'IOT' | |
| 'British Virgin Islands' | '1-284' | 'VG' | 'VGB' | |
| 'Brunei' | '673' | 'BN' | 'BRN' | |
| 'Bulgaria' | '359' | 'BG' | 'BGR' | |
| 'Burkina Faso' | '226' | 'BF' | 'BFA' | |
| 'Burundi' | '257' | 'BI' | 'BDI' | |
| 'Cambodia' | '855' | 'KH' | 'KHM' | |
| 'Cameroon' | '237' | 'CM' | 'CMR' | |
| 'Canada' | '1' | 'CA' | 'CAN' | |
| 'Cape Verde' | '238' | 'CV' | 'CPV' | |
| 'Cayman Islands' | '1-345' | 'KY' | 'CYM' | |
| 'Central African Republic' | '236' | 'CF' | 'CAF' | |
| 'Chad' | '235' | 'TD' | 'TCD' | |
| 'Chile' | '56' | 'CL' | 'CHL' | |
| 'China' | '86' | 'CN' | 'CHN' | |
| 'Christmas Island' | '61' | 'CX' | 'CXR' | |
| 'Cocos Islands' | '61' | 'CC' | 'CCK' | |
| 'Colombia' | '57' | 'CO' | 'COL' | |
| 'Comoros' | '269' | 'KM' | 'COM' | |
| 'Cook Islands' | '682' | 'CK' | 'COK' | |
| 'Costa Rica' | '506' | 'CR' | 'CRI' | |
| 'Croatia' | '385' | 'HR' | 'HRV' | |
| 'Cuba' | '53' | 'CU' | 'CUB' | |
| 'Curacao' | '599' | 'CW' | 'CUW' | |
| 'Cyprus' | '357' | 'CY' | 'CYP' | |
| 'Czech Republic' | '420' | 'CZ' | 'CZE' | |
| 'Democratic Republic of the Congo' | '243' | 'CD' | 'COD' | |
| 'Denmark' | '45' | 'DK' | 'DNK' | |
| 'Djibouti' | '253' | 'DJ' | 'DJI' | |
| 'Dominica' | '1-767' | 'DM' | 'DMA' | |
| 'Dominican Republic' | '1-809' | 'DO' | 'DOM' | |
| 'East Timor' | '670' | 'TL' | 'TLS' | |
| 'Ecuador' | '593' | 'EC' | 'ECU' | |
| 'Egypt' | '20' | 'EG' | 'EGY' | |
| 'El Salvador' | '503' | 'SV' | 'SLV' | |
| 'Equatorial Guinea' | '240' | 'GQ' | 'GNQ' | |
| 'Eritrea' | '291' | 'ER' | 'ERI' | |
| 'Estonia' | '372' | 'EE' | 'EST' | |
| 'Ethiopia' | '251' | 'ET' | 'ETH' | |
| 'Falkland Islands' | '500' | 'FK' | 'FLK' | |
| 'Faroe Islands' | '298' | 'FO' | 'FRO' | |
| 'Fiji' | '679' | 'FJ' | 'FJI' | |
| 'Finland' | '358' | 'FI' | 'FIN' | |
| 'France' | '33' | 'FR' | 'FRA' | |
| 'French Polynesia' | '689' | 'PF' | 'PYF' | |
| 'Gabon' | '241' | 'GA' | 'GAB' | |
| 'Gambia' | '220' | 'GM' | 'GMB' | |
| 'Georgia' | '995' | 'GE' | 'GEO' | |
| 'Germany' | '49' | 'DE' | 'DEU' | |
| 'Ghana' | '233' | 'GH' | 'GHA' | |
| 'Gibraltar' | '350' | 'GI' | 'GIB' | |
| 'Greece' | '30' | 'GR' | 'GRC' | |
| 'Greenland' | '299' | 'GL' | 'GRL' | |
| 'Grenada' | '1-473' | 'GD' | 'GRD' | |
| 'Guam' | '1-671' | 'GU' | 'GUM' | |
| 'Guatemala' | '502' | 'GT' | 'GTM' | |
| 'Guernsey' | '44-1481' | 'GG' | 'GGY' | |
| 'Guinea' | '224' | 'GN' | 'GIN' | |
| 'Guinea-Bissau' | '245' | 'GW' | 'GNB' | |
| 'Guyana' | '592' | 'GY' | 'GUY' | |
| 'Haiti' | '509' | 'HT' | 'HTI' | |
| 'Honduras' | '504' | 'HN' | 'HND' | |
| 'Hong Kong' | '852' | 'HK' | 'HKG' | |
| 'Hungary' | '36' | 'HU' | 'HUN' | |
| 'Iceland' | '354' | 'IS' | 'ISL' | |
| 'India' | '91' | 'IN' | 'IND' | |
| 'Indonesia' | '62' | 'ID' | 'IDN' | |
| 'Iran' | '98' | 'IR' | 'IRN' | |
| 'Iraq' | '964' | 'IQ' | 'IRQ' | |
| 'Ireland' | '353' | 'IE' | 'IRL' | |
| 'Isle of Man' | '44-1624' | 'IM' | 'IMN' | |
| 'Israel' | '972' | 'IL' | 'ISR' | |
| 'Italy' | '39' | 'IT' | 'ITA' | |
| 'Ivory Coast' | '225' | 'CI' | 'CIV' | |
| 'Jamaica' | '1-876' | 'JM' | 'JAM' | |
| 'Japan' | '81' | 'JP' | 'JPN' | |
| 'Jersey' | '44-1534' | 'JE' | 'JEY' | |
| 'Jordan' | '962' | 'JO' | 'JOR' | |
| 'Kazakhstan' | '7' | 'KZ' | 'KAZ' | |
| 'Kenya' | '254' | 'KE' | 'KEN' | |
| 'Kiribati' | '686' | 'KI' | 'KIR' | |
| 'Kosovo' | '383' | 'XK' | 'XKX' | |
| 'Kuwait' | '965' | 'KW' | 'KWT' | |
| 'Kyrgyzstan' | '996' | 'KG' | 'KGZ' | |
| 'Laos' | '856' | 'LA' | 'LAO' | |
| 'Latvia' | '371' | 'LV' | 'LVA' | |
| 'Lebanon' | '961' | 'LB' | 'LBN' | |
| 'Lesotho' | '266' | 'LS' | 'LSO' | |
| 'Liberia' | '231' | 'LR' | 'LBR' | |
| 'Libya' | '218' | 'LY' | 'LBY' | |
| 'Liechtenstein' | '423' | 'LI' | 'LIE' | |
| 'Lithuania' | '370' | 'LT' | 'LTU' | |
| 'Luxembourg' | '352' | 'LU' | 'LUX' | |
| 'Macau' | '853' | 'MO' | 'MAC' | |
| 'Macedonia' | '389' | 'MK' | 'MKD' | |
| 'Madagascar' | '261' | 'MG' | 'MDG' | |
| 'Malawi' | '265' | 'MW' | 'MWI' | |
| 'Malaysia' | '60' | 'MY' | 'MYS' | |
| 'Maldives' | '960' | 'MV' | 'MDV' | |
| 'Mali' | '223' | 'ML' | 'MLI' | |
| 'Malta' | '356' | 'MT' | 'MLT' | |
| 'Marshall Islands' | '692' | 'MH' | 'MHL' | |
| 'Mauritania' | '222' | 'MR' | 'MRT' | |
| 'Mauritius' | '230' | 'MU' | 'MUS' | |
| 'Mayotte' | '262' | 'YT' | 'MYT' | |
| 'Mexico' | '52' | 'MX' | 'MEX' | |
| 'Micronesia' | '691' | 'FM' | 'FSM' | |
| 'Moldova' | '373' | 'MD' | 'MDA' | |
| 'Monaco' | '377' | 'MC' | 'MCO' | |
| 'Mongolia' | '976' | 'MN' | 'MNG' | |
| 'Montenegro' | '382' | 'ME' | 'MNE' | |
| 'Montserrat' | '1-664' | 'MS' | 'MSR' | |
| 'Morocco' | '212' | 'MA' | 'MAR' | |
| 'Mozambique' | '258' | 'MZ' | 'MOZ' | |
| 'Myanmar' | '95' | 'MM' | 'MMR' | |
| 'Namibia' | '264' | 'NA' | 'NAM' | |
| 'Nauru' | '674' | 'NR' | 'NRU' | |
| 'Nepal' | '977' | 'NP' | 'NPL' | |
| 'Netherlands' | '31' | 'NL' | 'NLD' | |
| 'Netherlands Antilles' | '599' | 'AN' | 'ANT' | |
| 'New Caledonia' | '687' | 'NC' | 'NCL' | |
| 'New Zealand' | '64' | 'NZ' | 'NZL' | |
| 'Nicaragua' | '505' | 'NI' | 'NIC' | |
| 'Niger' | '227' | 'NE' | 'NER' | |
| 'Nigeria' | '234' | 'NG' | 'NGA' | |
| 'Niue' | '683' | 'NU' | 'NIU' | |
| 'North Korea' | '850' | 'KP' | 'PRK' | |
| 'Northern Mariana Islands' | '1-670' | 'MP' | 'MNP' | |
| 'Norway' | '47' | 'NO' | 'NOR' | |
| 'Oman' | '968' | 'OM' | 'OMN' | |
| 'Pakistan' | '92' | 'PK' | 'PAK' | |
| 'Palau' | '680' | 'PW' | 'PLW' | |
| 'Palestine' | '970' | 'PS' | 'PSE' | |
| 'Panama' | '507' | 'PA' | 'PAN' | |
| 'Papua New Guinea' | '675' | 'PG' | 'PNG' | |
| 'Paraguay' | '595' | 'PY' | 'PRY' | |
| 'Peru' | '51' | 'PE' | 'PER' | |
| 'Philippines' | '63' | 'PH' | 'PHL' | |
| 'Pitcairn' | '64' | 'PN' | 'PCN' | |
| 'Poland' | '48' | 'PL' | 'POL' | |
| 'Portugal' | '351' | 'PT' | 'PRT' | |
| 'Puerto Rico' | '1-787' | 'PR' | 'PRI' | |
| 'Qatar' | '974' | 'QA' | 'QAT' | |
| 'Republic of the Congo' | '242' | 'CG' | 'COG' | |
| 'Reunion' | '262' | 'RE' | 'REU' | |
| 'Romania' | '40' | 'RO' | 'ROU' | |
| 'Russia' | '7' | 'RU' | 'RUS' | |
| 'Rwanda' | '250' | 'RW' | 'RWA' | |
| 'Saint Barthelemy' | '590' | 'BL' | 'BLM' | |
| 'Saint Helena' | '290' | 'SH' | 'SHN' | |
| 'Saint Kitts and Nevis' | '1-869' | 'KN' | 'KNA' | |
| 'Saint Lucia' | '1-758' | 'LC' | 'LCA' | |
| 'Saint Martin' | '590' | 'MF' | 'MAF' | |
| 'Saint Pierre and Miquelon' | '508' | 'PM' | 'SPM' | |
| 'Saint Vincent and the Grenadines' | '1-784' | 'VC' | 'VCT' | |
| 'Samoa' | '685' | 'WS' | 'WSM' | |
| 'San Marino' | '378' | 'SM' | 'SMR' | |
| 'Sao Tome and Principe' | '239' | 'ST' | 'STP' | |
| 'Saudi Arabia' | '966' | 'SA' | 'SAU' | |
| 'Senegal' | '221' | 'SN' | 'SEN' | |
| 'Serbia' | '381' | 'RS' | 'SRB' | |
| 'Seychelles' | '248' | 'SC' | 'SYC' | |
| 'Sierra Leone' | '232' | 'SL' | 'SLE' | |
| 'Singapore' | '65' | 'SG' | 'SGP' | |
| 'Sint Maarten' | '1-721' | 'SX' | 'SXM' | |
| 'Slovakia' | '421' | 'SK' | 'SVK' | |
| 'Slovenia' | '386' | 'SI' | 'SVN' | |
| 'Solomon Islands' | '677' | 'SB' | 'SLB' | |
| 'Somalia' | '252' | 'SO' | 'SOM' | |
| 'South Africa' | '27' | 'ZA' | 'ZAF' | |
| 'South Korea' | '82' | 'KR' | 'KOR' | |
| 'South Sudan' | '211' | 'SS' | 'SSD' | |
| 'Spain' | '34' | 'ES' | 'ESP' | |
| 'Sri Lanka' | '94' | 'LK' | 'LKA' | |
| 'Sudan' | '249' | 'SD' | 'SDN' | |
| 'Suriname' | '597' | 'SR' | 'SUR' | |
| 'Svalbard and Jan Mayen' | '47' | 'SJ' | 'SJM' | |
| 'Swaziland' | '268' | 'SZ' | 'SWZ' | |
| 'Sweden' | '46' | 'SE' | 'SWE' | |
| 'Switzerland' | '41' | 'CH' | 'CHE' | |
| 'Syria' | '963' | 'SY' | 'SYR' | |
| 'Taiwan' | '886' | 'TW' | 'TWN' | |
| 'Tajikistan' | '992' | 'TJ' | 'TJK' | |
| 'Tanzania' | '255' | 'TZ' | 'TZA' | |
| 'Thailand' | '66' | 'TH' | 'THA' | |
| 'Togo' | '228' | 'TG' | 'TGO' | |
| 'Tokelau' | '690' | 'TK' | 'TKL' | |
| 'Tonga' | '676' | 'TO' | 'TON' | |
| 'Trinidad and Tobago' | '1-868' | 'TT' | 'TTO' | |
| 'Tunisia' | '216' | 'TN' | 'TUN' | |
| 'Turkey' | '90' | 'TR' | 'TUR' | |
| 'Turkmenistan' | '993' | 'TM' | 'TKM' | |
| 'Turks and Caicos Islands' | '1-649' | 'TC' | 'TCA' | |
| 'Tuvalu' | '688' | 'TV' | 'TUV' | |
| 'U.S. Virgin Islands' | '1-340' | 'VI' | 'VIR' | |
| 'Uganda' | '256' | 'UG' | 'UGA' | |
| 'Ukraine' | '380' | 'UA' | 'UKR' | |
| 'United Arab Emirates' | '971' | 'AE' | 'ARE' | |
| 'United Kingdom' | '44' | 'GB' | 'GBR' | |
| 'United States' | '1' | 'US' | 'USA' | |
| 'Uruguay' | '598' | 'UY' | 'URY' | |
| 'Uzbekistan' | '998' | 'UZ' | 'UZB' | |
| 'Vanuatu' | '678' | 'VU' | 'VUT' | |
| 'Vatican' | '379' | 'VA' | 'VAT' | |
| 'Venezuela' | '58' | 'VE' | 'VEN' | |
| 'Vietnam' | '84' | 'VN' | 'VNM' | |
| 'Wallis and Futuna' | '681' | 'WF' | 'WLF' | |
| 'Western Sahara' | '212' | 'EH' | 'ESH' | |
| 'Yemen' | '967' | 'YE' | 'YEM' | |
| 'Zambia' | '260' | 'ZM' | 'ZMB' | |
| 'Zimbabwe' | '263' | 'ZW' | 'ZWE' |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment