Presidential Sorting
Given a nice CSV formatted arrangement of the Presidents of the United States, we need to print out an alphabetical list in pretty columns. Prove that vim can conquer this basic Excel task!
Start file
President,Political Party,Dates in Office George Washington,,1789_97 John Adams,Federalist,1797_1801 Thomas Jefferson,Democratic-Republican,1801_9 James Madison,Democratic-Republican,1809_17 James Monroe,Democratic-Republican,1817_25 John Quincy Adams,Democratic-Republican,1825_29 Andrew Jackson,Democratic,1829_37 Martin Van Buren,Democratic,1837_41 William Henry Harrison,Whig,1841 John Tyler,Whig,1841_45 James Knox Polk,Democratic,1845_49 Zachary Taylor,Whig,1849_50 Millard Fillmore,Whig,1850_53 Franklin Pierce,Democratic,1853_57 James Buchanan,Democratic,1857_61 Abraham Lincoln,Republican,1861_65 Andrew Johnson,Democratic/National Union,1865_69 Ulysses Simpson Grant,Republican,1869_77 Rutherford Birchard Hayes,Republican,1877_81 James Abram Garfield,Republican,1881 Chester Alan Arthur,Republican,1881_85 Grover Cleveland,Democratic,1885_89 Benjamin Harrison,Republican,1889_93 Grover Cleveland,Democratic,1893_97 William McKinley,Republican,1897_1901 Theodore Roosevelt,Republican,1901_9 William Howard Taft,Republican,1909_13 Woodrow Wilson,Democratic,1913_21 Warren Gamaliel Harding,Republican,1921_23 Calvin Coolidge,Republican,1923_29 Herbert Clark Hoover,Republican,1929_33 Franklin Delano Roosevelt,Democratic,1933_45 Harry S. Truman,Democratic,1945_53 Dwight David Eisenhower,Republican,1953_61 John Fitzgerald Kennedy,Democratic,1961_63 Lyndon Baines Johnson,Democratic,1963_69 Richard Milhous Nixon,Republican,1969_74 Gerald Rudolph Ford,Republican,1974_77 Jimmy Carter,Democratic,1977_81 Ronald Wilson Reagan,Republican,1981_89 George Herbert Walker Bush,Republican,1989_93 Bill Clinton,Democratic,1993_2001 George Walker Bush,Republican,2001_9 Barack Hussein Obama,Democratic,2009_
End file
President Political Party Dates in Office Abraham Lincoln Republican 1861–65 Andrew Jackson Democratic 1829–37 Andrew Johnson Democratic/National Union 1865–69 Barack Hussein Obama Democratic 2009– Benjamin Harrison Republican 1889–93 Bill Clinton Democratic 1993–2001 Calvin Coolidge Republican 1923–29 Chester Alan Arthur Republican 1881–85 Dwight David Eisenhower Republican 1953–61 Franklin Delano Roosevelt Democratic 1933–45 Franklin Pierce Democratic 1853–57 George Herbert Walker Bush Republican 1989–93 George Walker Bush Republican 2001–9 George Washington 1789–97 Gerald Rudolph Ford Republican 1974–77 Grover Cleveland Democratic 1885–89 Grover Cleveland Democratic 1893–97 Harry S. Truman Democratic 1945–53 Herbert Clark Hoover Republican 1929–33 James Abram Garfield Republican 1881 James Buchanan Democratic 1857–61 James Knox Polk Democratic 1845–49 James Madison Democratic-Republican 1809–17 James Monroe Democratic-Republican 1817–25 Jimmy Carter Democratic 1977–81 John Adams Federalist 1797–1801 John Fitzgerald Kennedy Democratic 1961–63 John Quincy Adams Democratic-Republican 1825–29 John Tyler Whig 1841–45 Lyndon Baines Johnson Democratic 1963–69 Martin Van Buren Democratic 1837–41 Millard Fillmore Whig 1850–53 Richard Milhous Nixon Republican 1969–74 Ronald Wilson Reagan Republican 1981–89 Rutherford Birchard Hayes Republican 1877–81 Theodore Roosevelt Republican 1901–9 Thomas Jefferson Democratic-Republican 1801–9 Ulysses Simpson Grant Republican 1869–77 Warren Gamaliel Harding Republican 1921–23 William Henry Harrison Whig 1841 William Howard Taft Republican 1909–13 William McKinley Republican 1897–1901 Woodrow Wilson Democratic 1913–21 Zachary Taylor Whig 1849–50
View Diff
1,45c1,45 < President,Political Party,Dates in Office < George Washington,,1789_97 < John Adams,Federalist,1797_1801 < Thomas Jefferson,Democratic-Republican,1801_9 < James Madison,Democratic-Republican,1809_17 < James Monroe,Democratic-Republican,1817_25 < John Quincy Adams,Democratic-Republican,1825_29 < Andrew Jackson,Democratic,1829_37 < Martin Van Buren,Democratic,1837_41 < William Henry Harrison,Whig,1841 < John Tyler,Whig,1841_45 < James Knox Polk,Democratic,1845_49 < Zachary Taylor,Whig,1849_50 < Millard Fillmore,Whig,1850_53 < Franklin Pierce,Democratic,1853_57 < James Buchanan,Democratic,1857_61 < Abraham Lincoln,Republican,1861_65 < Andrew Johnson,Democratic/National Union,1865_69 < Ulysses Simpson Grant,Republican,1869_77 < Rutherford Birchard Hayes,Republican,1877_81 < James Abram Garfield,Republican,1881 < Chester Alan Arthur,Republican,1881_85 < Grover Cleveland,Democratic,1885_89 < Benjamin Harrison,Republican,1889_93 < Grover Cleveland,Democratic,1893_97 < William McKinley,Republican,1897_1901 < Theodore Roosevelt,Republican,1901_9 < William Howard Taft,Republican,1909_13 < Woodrow Wilson,Democratic,1913_21 < Warren Gamaliel Harding,Republican,1921_23 < Calvin Coolidge,Republican,1923_29 < Herbert Clark Hoover,Republican,1929_33 < Franklin Delano Roosevelt,Democratic,1933_45 < Harry S. Truman,Democratic,1945_53 < Dwight David Eisenhower,Republican,1953_61 < John Fitzgerald Kennedy,Democratic,1961_63 < Lyndon Baines Johnson,Democratic,1963_69 < Richard Milhous Nixon,Republican,1969_74 < Gerald Rudolph Ford,Republican,1974_77 < Jimmy Carter,Democratic,1977_81 < Ronald Wilson Reagan,Republican,1981_89 < George Herbert Walker Bush,Republican,1989_93 < Bill Clinton,Democratic,1993_2001 < George Walker Bush,Republican,2001_9 < Barack Hussein Obama,Democratic,2009_ --- > President Political Party Dates in Office > Abraham Lincoln Republican 1861–65 > Andrew Jackson Democratic 1829–37 > Andrew Johnson Democratic/National Union 1865–69 > Barack Hussein Obama Democratic 2009– > Benjamin Harrison Republican 1889–93 > Bill Clinton Democratic 1993–2001 > Calvin Coolidge Republican 1923–29 > Chester Alan Arthur Republican 1881–85 > Dwight David Eisenhower Republican 1953–61 > Franklin Delano Roosevelt Democratic 1933–45 > Franklin Pierce Democratic 1853–57 > George Herbert Walker Bush Republican 1989–93 > George Walker Bush Republican 2001–9 > George Washington 1789–97 > Gerald Rudolph Ford Republican 1974–77 > Grover Cleveland Democratic 1885–89 > Grover Cleveland Democratic 1893–97 > Harry S. Truman Democratic 1945–53 > Herbert Clark Hoover Republican 1929–33 > James Abram Garfield Republican 1881 > James Buchanan Democratic 1857–61 > James Knox Polk Democratic 1845–49 > James Madison Democratic-Republican 1809–17 > James Monroe Democratic-Republican 1817–25 > Jimmy Carter Democratic 1977–81 > John Adams Federalist 1797–1801 > John Fitzgerald Kennedy Democratic 1961–63 > John Quincy Adams Democratic-Republican 1825–29 > John Tyler Whig 1841–45 > Lyndon Baines Johnson Democratic 1963–69 > Martin Van Buren Democratic 1837–41 > Millard Fillmore Whig 1850–53 > Richard Milhous Nixon Republican 1969–74 > Ronald Wilson Reagan Republican 1981–89 > Rutherford Birchard Hayes Republican 1877–81 > Theodore Roosevelt Republican 1901–9 > Thomas Jefferson Democratic-Republican 1801–9 > Ulysses Simpson Grant Republican 1869–77 > Warren Gamaliel Harding Republican 1921–23 > William Henry Harrison Whig 1841 > William Howard Taft Republican 1909–13 > William McKinley Republican 1897–1901 > Woodrow Wilson Democratic 1913–21 > Zachary Taylor Whig 1849–50
Solutions by @connermcd:
Unlock 3 remaining solutions by signing in and submitting your own entry