Are you familiar with OpenRefine? It would take some work, but you could copy/paste this into a text file and wangle it thusly. The Transpose function will convert row headings into columns.
The text file itself will require some cleanup before the cleanup in OpenRefine. A reader like Notepad++ that allows mass edits with Regular Expressions (RegEx) will help.
Of course, I intend to mess with this on my own. If I get it to something I like, I'll share it.
Maristella
________________________________
From: Association for Recorded Sound Discussion List <[log in to unmask]> on behalf of Brewster Kahle <[log in to unmask]>
Sent: Tuesday, May 21, 2019 7:45:26 PM
To: [log in to unmask]
Subject: [EXT] [ARSCLIST] anyone database-ized Brian Rust's: Jazz Records 1917–1934?
It is a huge help that the pdf is available (thank you Mainspring!). I
would like to use it for automatically finding dates for records in the
Great 78 Project and point back to the right page in the book.
To do this I need it in a format like a CSV (but can convert it from any
other database-like format)
Label, catno, matrix, performer, title, date, page-number
https://nam04.safelinks.protection.outlook.com/?url=https%3A%2F%2F78records.files.wordpress.com%2F2016%2F06%2Frust_jr_free-edition.pdf&data=02%7C01%7CMaristella.Feustle%40UNT.EDU%7C8b8d4f1d834e4e0d7edb08d6de4ed8d6%7C70de199207c6480fa318a1afcba03983%7C0%7C1%7C636940827573551798&sdata=GPQRS6qaptUPdK%2F4k%2FMA6MQYOup5OBc7fWRfUS%2BtuLI%3D&reserved=0
I did this for Almost Complete ...
https://nam04.safelinks.protection.outlook.com/?url=https%3A%2F%2Farchive.org%2Fdetails%2Falmostcomplete7800barr%2Fpage%2F115&data=02%7C01%7CMaristella.Feustle%40UNT.EDU%7C8b8d4f1d834e4e0d7edb08d6de4ed8d6%7C70de199207c6480fa318a1afcba03983%7C0%7C1%7C636940827573551798&sdata=Dg32sHIPav8nG3Cuw%2FvP5aQiFs41o8peK%2FGnDIUiEuk%3D&reserved=0
and American 45. and 78...
https://nam04.safelinks.protection.outlook.com/?url=https%3A%2F%2Farchive.org%2Fstream%2Famerican45fortyf00dani%23page%2F38%2Fmode%2F1up&data=02%7C01%7CMaristella.Feustle%40UNT.EDU%7C8b8d4f1d834e4e0d7edb08d6de4ed8d6%7C70de199207c6480fa318a1afcba03983%7C0%7C1%7C636940827573551798&sdata=e1CCa7fy%2FXwtkoi3RuAMwTs6K166HFPCYn4koG%2BVMdo%3D&reserved=0
by having these hand key'ed and each month I use this for the new records.
Does anyone have any databased version of this? It must have started
out in such a thing.
Thank you!
-brewster
