Converting PDF to Wikitables
From AcaDec Scores and Information Center
(Redirected from Converting Nationals PDF to Wikitables)
Bugs: Need to figure out how to handle state names with spaces in them (Rhode Island, New York, etc) and people with multiple last names (or first names)
How-to:
- Open Top Scores By Event
- Click anywhere in PDF
- CTRL+A, CTRL+C
- CTRL+V into a MS Word Document (free version is ok)
- Get it below 50,000 characters (replace “County/Region/State” with “State”, etc.)
Use Advanced Find+Replace and check “Use Wildcards”
Replacing IDs with line breaks:
Search for:
([0-9]{4})
Replace with:
^l
Search for:
Last Name
Replace with:
^l Last Name
Search for:
Last Name State Rank ID First Name Team Name Score * ^l
Replace with nothing.
Finally, insert into this Google Sheet to automatically split and order columns:
https://docs.google.com/spreadsheets/d/1_XUK9fXapSyu0M6HyRL7SBFRUp51a25WUNNzFGLE0bM/edit?usp=sharing
Select only the columns you want on the wiki page and copy-paste into:
