Jump to content


Photo

Exporting Biblical Text (Hebrew, Greek, etc.) to a Spreadsheet


  • Please log in to reply
3 replies to this topic

#1 Neill

Neill

    Member

  • Active Members
  • Pip
  • 26 posts
  • Gender:Male
  • Location:Jerusalem, Israel
  • Accordance Version:11.x
  • Platforms:Mac OS X, iOS

Posted 03 August 2016 - 12:15 PM

Hello all,

 

I'm going to be starting a textual criticism project comparing 4QNumB (4Q27 in Accordance) with MT, LXX, etc.  I would like to arrange the text in a spreadsheet where each cell contains a discrete lexical item so I can easily compare variants.  I would then like to tag textual phenomena in the spreadsheet and get some statistics on that.  I I'm hoping for some general advice on how to get started, but my main desire is to export each text into this spreadsheet without copy/pasting each word.  Would Accordance services be able to accomplish this?  Thank you in advance for being patient with my tech ignorance.  

 

Neill



#2 Timothy Jenney

Timothy Jenney

    Mithril

  • Accordance
  • 2,571 posts
  • Gender:Male
  • Location:sunny Winter Haven, FL
  • Interests:a great cup of coffee, sci-fi, jazz and the blues, kayaking, camping, fishing and the great outdoors
  • Accordance Version:11.x
  • Platforms:Mac OS X, iOS

Posted 03 August 2016 - 12:55 PM

Happy to help, Neill!

 

Selecting the text, then using Language>Parsing will give you the text and the morphological details. Yes, the information will paste very nicely into Excel (save for the parentheses which appear backwards Correction: the newest version of Excel handles the parentheses correctly. See screenshots.). However, all the parsing information for each word winds up in a single cell. If you want to put each aspect (stem, number, etc.) into its own cell, you'll have to use Text Edit or MS Word to replace the white spaces in the parsing with tabs, then paste it in separately. Even then you'll have to do some manual cuts and pastes to make everything uniform.

 

Still, this is far better than typing it all in by hand! (which we all used to have to do, back in the "dark ages"!)

 

Old Excel for the Mac (14.6.6): Attached File  Screen Shot 2016-08-03 at 1.52.49 PM.png   449.68KB   1 downloads

 

New Excel for the Mac (15.4): Attached File  Screen Shot 2016-08-03 at 2.14.08 PM.png   224.66KB   1 downloads


Blessings,
"Dr. J"

Timothy P. Jenney, Ph. D.
"Lighting the Lamp" Host and Producer

Academic Licensing Assistant

 

iMac: Late 2014 27" 5k display, 4.0 GHz quad core i7, 24 GB RAM, 500 GB SSD,  AMD Radeon R9 M295X 4096 MB, OSX 10.11, El Capitan

MBP: Early 2011 17" MBP (8,3), 2.3 GHz quad core i7, 16 GB RAM, 480 SSD  + 1.5 TB HD, AMD Radeon HD 6750M, OSX 10.11, El Capitan

iPhone 6 plus: 64 GB, iOS 9.0.2


#3 Neill

Neill

    Member

  • Active Members
  • Pip
  • 26 posts
  • Gender:Male
  • Location:Jerusalem, Israel
  • Accordance Version:11.x
  • Platforms:Mac OS X, iOS

Posted 03 August 2016 - 02:31 PM

Dr. Jenney,

Thanks so much! I'll be trying this out soon.

Neill
  • Timothy Jenney likes this

#4 SimpleTheist

SimpleTheist

    Member

  • Active Members
  • Pip
  • 10 posts
  • Accordance Version:11.x
  • Platforms:Windows

Posted Today, 12:35 AM

You can potentially speed up the process by using the find and replace feature on word to find spaces and replace them with tabs.






0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users