Pseudo - Sorting By Population

Sorting three text files cities, provinces and population.

Goal

The idea here is to take all three files and sort them by population. These values do not reflect actual data.

Files

CitiesProvincesPopulation
"Calgary" "Edmonton" "Red Deer" "Lethbridge" "Medicine Hat" "Fort McMurray" "Grande Prairie" "Airdrie" "Spruce Grove" "Okotoks" "Leduc" "Vancouver" "Victoria" "Abbotsford" "Kelowna" "Nanaimo" "White Rock" "Kamloops" "Chilliwack" "Prince George" "Vernon" "Courtenay" "Penticton" "Campbell River" "Walnut Grove" "Duncan" "Parksville" "Winnipeg" "Brandon" "Moncton" "Saint John" "Fredericton" "St. John's" "Halifax" "Sydney" "Toronto" "Hamilton" "Kitchener" "London" "St. Catharines" "Oshawa" "Windsor" "Barrie" "Guelph" "Kingston" "Sudbury" "Thunder Bay" "Kanata" "Brantford" "Peterborough" "Sarnia" "Milton" "Sault Ste. Marie" "Belleville" "North Bay" "Cornwall" "Chatham" "Bowmanville" "St. Thomas" "Georgetown" "Woodstock" "Midland" "Leamington" "Stratford" "Orangeville" "Timmins" "Orillia" "Bolton" "Keswick" "Stouffville" "Charlottetown" "Montreal" "Ottawa" "Quebec City" "Sherbrooke" "Trois-Rivieres" "Chicoutimi" "Saint-Jean" "Chateauguay" "Drummondville" "Saint-Jerome" "Granby" "Beloeil" "Saint-Hyacinthe" "Shawinigan" "Joliette" "Victoriaville" "Valleyfield" "Rimouski" "Sorel" "Alma" "Saint-Georges" "Val-d'Or" "Rouyn" "Buckingham" "Saskatoon" "Regina" "Prince Albert" "Moose Jaw" "Lloydminster" "AL" "AL" "AL" "AL" "AL" "AL" "AL" "AL" "AL" "AL" "AL" "BC" "BC" "BC" "BC" "BC" "BC" "BC" "BC" "BC" "BC" "BC" "BC" "BC" "BC" "BC" "BC" "MB" "MB" "NB" "NB" "NB" "NL" "NS" "NS" "ON" "ON" "ON" "ON" "ON" "ON" "ON" "ON" "ON" "ON" "ON" "ON" "ON" "ON" "ON" "ON" "ON" "ON" "ON" "ON" "ON" "ON" "ON" "ON" "ON" "ON" "ON" "ON" "ON" "ON" "ON" "ON" "ON" "ON" "ON" "PE" "QC" "QC" "QC" "QC" "QC" "QC" "QC" "QC" "QC" "QC" "QC" "QC" "QC" "QC" "QC" "QC" "QC" "QC" "QC" "QC" "QC" "QC" "QC" "QC" "SK" "SK" "SK" "SK" "SK" 1095404 960015 90207 83679 65671 61374 54913 42564 27947 24511 24279 2135201 316327 149855 141767 88799 82368 73472 66382 65503 44600 40809 36902 34514 27969 24479 24326 671551 46061 107086 95902 61522 165346 297943 31597 5132794 670580 444681 366191 309319 290937 276165 166634 122362 117787 106840 102222 101760 93650 80660 79526 75573 67646 63985 53515 49243 44074 43555 41688 40150 37362 31428 31254 30886 30729 30614 30586 25954 25527 24886 42602 3407963 933596 696946 140628 126460 106666 83053 70812 66314 65825 60281 50796 48576 47735 42883 41701 39391 37664 36969 26016 25703 23827 23740 23589 222035 192756 35552 33617 27804

Solution

Sorting

Report

OVER 1 MILLION
Toronto, ON, 5132794

OVER 1 MILLION
Vancouver, BC, 2135201


BETWEEN 500,000 AND 1 MILLION
Edmonton, AL, 960015


BETWEEN 500,000 AND 1 MILLION
Quebec City, QC, 696946


BETWEEN 500,000 AND 1 MILLION
Hamilton, ON, 670580


BETWEEN 500,000 AND 1 MILLION
London, ON, 366191


BETWEEN 500,000 AND 1 MILLION
St. Catharines, ON, 309319


BETWEEN 500,000 AND 1 MILLION
Oshawa, ON, 290937


BETWEEN 500,000 AND 1 MILLION
Saskatoon, SK, 222035


BETWEEN 500,000 AND 1 MILLION
Barrie, ON, 166634


BETWEEN 500,000 AND 1 MILLION
Abbotsford, BC, 149855


BETWEEN 500,000 AND 1 MILLION
Sherbrooke, QC, 140628


BETWEEN 500,000 AND 1 MILLION
Guelph, ON, 122362


BETWEEN 500,000 AND 1 MILLION
Moncton, NB, 107086


BETWEEN 500,000 AND 1 MILLION
Chicoutimi, QC, 106666


BETWEEN 500,000 AND 1 MILLION
Kanata, ON, 101760


BETWEEN 500,000 AND 1 MILLION
Brantford, ON, 93650


BETWEEN 500,000 AND 1 MILLION
Nanaimo, BC, 88799


BETWEEN 500,000 AND 1 MILLION
Saint-Jean, QC, 83053


BETWEEN 500,000 AND 1 MILLION
Peterborough, ON, 80660


BETWEEN 500,000 AND 1 MILLION
Milton, ON, 75573


BETWEEN 500,000 AND 1 MILLION
Chateauguay, QC, 70812


BETWEEN 500,000 AND 1 MILLION
Chilliwack, BC, 66382


BETWEEN 500,000 AND 1 MILLION
Saint-Jerome, QC, 65825


BETWEEN 500,000 AND 1 MILLION
Prince George, BC, 65503


BETWEEN 500,000 AND 1 MILLION
Fredericton, NB, 61522


BETWEEN 500,000 AND 1 MILLION
Granby, QC, 60281


BETWEEN 500,000 AND 1 MILLION
North Bay, ON, 53515


BETWEEN 500,000 AND 1 MILLION
Cornwall, ON, 49243


BETWEEN 500,000 AND 1 MILLION
Shawinigan, QC, 47735


BETWEEN 500,000 AND 1 MILLION
Vernon, BC, 44600


BETWEEN 500,000 AND 1 MILLION
Bowmanville, ON, 43555


BETWEEN 500,000 AND 1 MILLION
Charlottetown, PE, 42602


BETWEEN 500,000 AND 1 MILLION
Victoriaville, QC, 41701


BETWEEN 500,000 AND 1 MILLION
Courtenay, BC, 40809


BETWEEN 500,000 AND 1 MILLION
Valleyfield, QC, 39391


BETWEEN 500,000 AND 1 MILLION
Woodstock, ON, 37362


BETWEEN 500,000 AND 1 MILLION
Penticton, BC, 36902


BETWEEN 500,000 AND 1 MILLION
Campbell River, BC, 34514


BETWEEN 500,000 AND 1 MILLION
Sydney, NS, 31597


BETWEEN 500,000 AND 1 MILLION
Leamington, ON, 31254


BETWEEN 500,000 AND 1 MILLION
Orangeville, ON, 30729


BETWEEN 500,000 AND 1 MILLION
Orillia, ON, 30586


BETWEEN 500,000 AND 1 MILLION
Spruce Grove, AL, 27947


BETWEEN 500,000 AND 1 MILLION
Alma, QC, 26016


BETWEEN 500,000 AND 1 MILLION
Saint-Georges, QC, 25703


BETWEEN 500,000 AND 1 MILLION
Stouffville, ON, 24886


BETWEEN 500,000 AND 1 MILLION
Duncan, BC, 24479


BETWEEN 500,000 AND 1 MILLION
Leduc, AL, 24279


BETWEEN 500,000 AND 1 MILLION
Rouyn, QC, 23740