FW Question: Is there an easy way to highlight all occurrences of each lemma that occurs in a particular passage?

Page 1 of 1 (17 items)
This post has 16 Replies | 1 Follower

Posts 182
David Sloan | Forum Activity | Posted: Thu, Jun 16 2011 4:01 PM

I do a lot of work in OT use of the OT and NT use of the OT. To help with this I have been creating a visual filter to highlight all passages in the Hebrew Bible where a particular lemma occurs, and then I fill that visual filter with all of the words from a passage. Unfortunately this is very tedious as I have to create a new entry for each word. It is furthermore tedious because I have yet to figure out how to spell the lemma (depending on which morphology I use the lemma can be slightly different; it is also unfortunate that sometimes the same root word can be divided into different lemmas based on the assumption that there are various meanings of a Hebrew word). I am wondering if there is a less tedious approach to this.  For example, I was recently looking to see if Psalm 118 has had any influence on Isaiah (or vice versa).  I created the visual filter below and then skimmed Isaiah (in Hebrew) and found places where there seems to be an influence.  But this process took me a few hours.  It would have been easier if 1) I could have just told Logos to automatically create a visual filter based on the words in Psalm 118 or 2) I could have done some form of word study that looked for multiple words and sorted the results by number of different words that are found in common. #2 does not seem to be feasible when searching for as many words as I am here (though I have done this approach when I am looking for the influence of just one verse on Isaiah).  Any thoughts about how to make this easier?

Posts 182
David Sloan | Forum Activity | Replied: Thu, Jun 16 2011 4:06 PM

Posts 847
Praiser | Forum Activity | Replied: Thu, Jun 16 2011 4:08 PM

David, your screen shot didn't post

you need to use the paperclip icon to add your image.

Posts 13411
Mark Barnes | Forum Activity | Replied: Thu, Jun 16 2011 4:10 PM

There's no automatic way you can do this, but here's a few suggestions as to how it might be done.

(1) Compare the Interesting Words section of the Passage Guide for both Psalm 118 and Isaiah. You have to put up with annoying colours and word alignments, but it's worth a glance.

(2) Whilst you're looking at these, generate an analysis search for the wildcard character (*) for the range of Psalm 118, and then group by lemma. It will take perhaps 3-5 minutes to generate.

Now, follow these steps:

  1. Create a new visual filter for Isaiah, and set it to a morph search.
  2. If you're comfortable typing Hebrew, enter lemma:יהוה (or whatever lemma you're interested in). If you're not comfortable typing Hebrew:
    • Open up one of the Bible reference for any lemmas you're interested in. Position your Bible so you can still see both your search panel and your visual filter panel.
    • In your Bible, right-click on the lemma in it's context, and copy the lemma to the clipboard.
    • Paste the lemma into your visual filter.
  3. Choose the correct lemma from the suggestions, and select a highlighting style
  4. Repeat for each lemma that might be of interest.

The screenshot shows the completed process:

Now, apply that visual filter to Isaiah. Set the dropdown near the up and down arrows to "Filter Highlight", and use those arrows to navigate through the resource:

If you want to find out where these words cluster, you'll need to search, instead of using the visual filter. Switch to a morph search, and copy and paste each of the lemmas from your visual filter into the search box. Separate each one with a comma. You could just do a verses search, which might be interesting (though my inclusion of יהוה probably wasn't wise!):

Better, probably, to do an analysis search, and group the results by chapter. You might need to add 'chapter' to the list of columns by right-clicking somewhere in the column header. You can right click on a section header and choose "Collapse all" or "Summary View". You'll see that Isaiah 36-38 and 44-45 look good candidates for further study.

Posts 182
David Sloan | Forum Activity | Replied: Thu, Jun 16 2011 4:10 PM

I cannot get my screenshot to post here, but here is a little more detail from my example:

Search All Morph Text in All Passages in The Hebrew Bible: Andersen-Forbes Analyzed Text with Andersen-Forbes Hebrew Morphology for

lemma:ידה.2

lemma:יהוה

lemma:טוב.1

lemma:עולם

lemma:חסד.2

lemma:אמר.1

lemma:ישׂראל

...

Posts 5337
Kevin Becker | Forum Activity | Replied: Thu, Jun 16 2011 4:21 PM

David, you mentioned that you didn't know how to spell all the lemmas. You can automatically generate the syntax from the right click menu.

This will bring up a morph search window, you can copy the search syntax over to your visual filter

Posts 182
David Sloan | Forum Activity | Replied: Thu, Jun 16 2011 4:33 PM

Thanks, Mark, that is really helpful!

Kevin, do you happen to know which morphology that spelling works with? I've found that depending on whether I am highlighting words in BHS/WIVU, BHS/WHM, or AFAT I have to change the lemma (sometimes putting in the vowels, sometimes not; sometimes adding a 1. or 2. or 3., sometimes not; sometimes specifying whether it is n. or v.).  That's what I mean by spelling and it varies depending on which morphology I use.

Posts 13411
Mark Barnes | Forum Activity | Replied: Thu, Jun 16 2011 4:41 PM

David Sloan:
Thanks, Mark, that is really helpful!

In case you don't otherwise notice, I edited my post with a second method.

David Sloan:
do you happen to know which morphology that spelling works with?

As you say, each morphology has it's own 'spelling'. Lemmas you generate from a particular resource will work with all resources that have the same morphology as that resource.

 

Posts 11111
Forum MVP
NB.Mick | Forum Activity | Replied: Thu, Jun 16 2011 4:50 PM

Off topic:

David Sloan:
I cannot get my screenshot to post here

David, the full instruction to this is at http://wiki.logos.com/Screenshot 

Basically, you can't just paste the screenshot, but need to save it as a graphics file (e.g. *.jpg) and then use the paperclip icon as was shown earlier in this thread to upload the file. Counter-intuitively, the graphic files will not be added to the post (such as any other files) but displayed right away as if you had pasted them.

Just try it!

Mick

Running Logos 9 latest (beta) version on Win 10

Posts 3810
spitzerpl | Forum Activity | Replied: Thu, Jun 16 2011 8:51 PM

David Sloan:
I am wondering if there is a less tedious approach to this. 

Just for fun I tried out an idea I had and it had reasonable success. I am not good with Hebrew so you might be able to filter out the basic words. I'm sure I could have done some of this if necessary If there is a step you don't understand below just ask for further clarification and I'll go into the specifics for how to accomplish it. The following took me about 45 minutes to develop and implement. With fine tuning I think the process could be reduced even further.

The basic Idea - Paste the Lemmas of a passage into Word, weed out all non-biblical characters and get it so there is only one space between words, replace every space with "> OR <Lemma = af/he/" Read through the resulting string and replace all undesired words (e.g. Normal 0 false false false EN-US X-NONE X-NONE <Lemma = af/he/ל>) with nothing. copy everything and paste it into a Bible search box. This will now highlight all of those lemmas in the bible translation of your preference.

 

More detailed walk-thru

1. set the interlinear display option for an english translation to display only the lemmas (I used the NKJV...it might have been the ESV)

2. highlight and copy the resulting text into MS Word (not sure what other processors have the following replace features) If you have the copy footnote setting turned on it might be good to turn it off temporarily.

3. Replace all Spaces with a times New Roman Font with a Space in a different font.

4. Replace all characters (use the string ^?) with a times new roman font with nothing.

5. Replace all double spaces with a single space

6. repeat step 5 until there are no replaces taking place. This will leave just a single space between each word.

7. replace all spaces with the string "> OR <Lemma = af/he/"

8. Manually edit the start of the string and the end of the string as these probably need to be fixed. E.g. take the "> OR " off the beginning and the " OR <Lemma..." off the end.

 

***Some of the strings looked weird due to font issues but when the copy and pasted everything crossed over correctly. If you copy everything and then paste it back in place as Text only things look a little better.

9. read through the resulting text and replace any words you do not want included with a nothing. If you use the Replace all function instead of manually replacing them this could cut off double work. since you are limited with the search string length this will get more relevant words into your search then if you tried to include every word.

10. Copy and paste the resulting string into a Bible Search Box. or paste them one by one into a Visual filter.

 

Let me know if this gets you any closer to what you are looking for!

 

<Edit> I came up with the attached string in Word in less then 15 minutes after restarting the process. Something is wrong with my process, though because if it worked just about everything in Psalm 118 should be highlighted and its not :-( Any clues on what wen wrong?

http://community.logos.com/cfs-file.ashx/__key/CommunityServer.Discussions.Components.Files/98/4113.Lemmas.pdf

Posts 3810
spitzerpl | Forum Activity | Replied: Thu, Jun 16 2011 10:10 PM

Philip Spitzer:
<Edit> I came up with the attached string in Word in less then 15 minutes after restarting the process. Something is wrong with my process, though because if it worked just about everything in Psalm 118 should be highlighted and its not :-( Any clues on what wen wrong?

I did eventually find out whats wrong and how to fix most of it. through the process I've come out with the following results highlighted throughout the scripture. the process is a little more involved and its too late for me to type out revised instructions so if accomplishing this within 1/2 an hour is what you are looking for let me know and I'll give more detailed instructions.

 

Posts 182
David Sloan | Forum Activity | Replied: Fri, Jun 17 2011 9:16 AM

Philip, Mark,

Thank you. You both have taught me a number of shortcuts and tricks that I didn't know before. Philip, I think I ran into the same problem that you did. When a Hebrew root has multiple definitions it puts a number before the root to indicate which definition it is going with. When I search I need that number in there but not in the format it comes in from your approach (e.g., "2 ידה" does not work as a search lemma). Actually this whole thing frustrates me. I wish I could search by root rather than lemma. Are the three versions of ידה really different words in Hebrew? I don't think so. But anyway, Philip, I couldn't get past that point in trying your method. Any root that had "multiple lemmas" according to AFAT didn't work in my final search. I do like, however, that a search gives me more flexibility than a visual filter. With a visual filter I have to skim the text of Isaiah (or wherever else I want to look for echoes), whereas with a search it will highlight things for me so I can do that but it will also produce a report that I can sort by chapter and see statistics that will point me in the right direction. (Mark, I never knew you could group an analyzed search result by chapter ... that was helpful to me.)

Mark, I never use the passage guide. That "interesting words" section is helpful. I should check that out more often. I think that (and other stuff in the passage guide) will help me quite a bit. I also like your idea of searching the wildcard and then grouping by lemma. That gives me a list of lemmas that is easier to work with than what I was doing (trying to figure out is this ידה number 1, 2, or 3 and hovering over each unclear word to see), so that will shave off a good bit of time in my creation of visual filters (though that is still a time-consuming process).

Sometimes I do searches rather than visual filters. I haven't decided yet which method I like better, though you're making me more interested in searches now that you've shown me how to group by chapter.

I wish some of the things I do in Logos could be automated processes, but I doubt there are many other people trying to do the exact things I'm doing. You guys have both shown me shortcuts and helpful tricks to cut down my time, and I greatly appreciate it. Thanks!

Posts 3810
spitzerpl | Forum Activity | Replied: Fri, Jun 17 2011 9:30 AM

David Sloan:
But anyway, Philip, I couldn't get past that point in trying your method.

The way I got past it was to do the following wildcard search and replace for each number

Replace /1*> with ^&:1

It's pretty easy to hit replace all, change numbers, replace all, change numbers. etc. Once you are done with the above search doe the following with each number

replace /1 with /

Posts 13411
Mark Barnes | Forum Activity | Replied: Fri, Jun 17 2011 10:31 AM

David Sloan:
Actually this whole thing frustrates me. I wish I could search by root rather than lemma. Are the three versions of ידה really different words in Hebrew? I don't think so.

If you want an insight into Logos' perspective on root vs lemma, go to here: http://community.logos.com/forums/p/4369/35654.aspx#35654 - this much later and shorter post might also encourage you: http://community.logos.com/forums/p/32500/243886.aspx#243886

The other thing you can do is not use AFAT. The other morphologies tend to use far few homophones than AFAT.

Posts 13411
Mark Barnes | Forum Activity | Replied: Fri, Jun 17 2011 11:11 AM

David Sloan:
Philip, I couldn't get past that point in trying your method. Any root that had "multiple lemmas" according to AFAT didn't work in my final search.

If you want to definitively search every lemma from Psa 118 in Isaiah, let's combine Philip's method with mine, for a 'perfect' result. It's lots of steps, but only takes 10 minutes or so. You'll need Microsoft Excel:

  1. Do the analysis search of Psalm 118 as described above. Export this search to Excel.
  2. In Excel, delete all the columns, except for the lemma (just click in the column header to select the column then press CTRL and the minus key). Delete the first row that contains the column headings.
  3. Select column A (your lemma column), and choose Remove Duplicates from the Data tab. Click OK.
  4. Go to cell B1, and type the following formula: =CONCATENATE("<Lemma = ",A1,">, ")
  5. Copy that formula down so it fills every row, by dragging the bottom right corner of the first cell downwards.
  6. Right-click on the cells you've just populated, and choose copy.
  7. Go to a blank space in the spreadsheet, right-click and choose Paste Special.
  8. Select Values, None and Transpose and click OK.
  9. You should get the column as a row. Now right-click on the row, and choose Copy.
  10. Now go to Logos, and do a Bible Search in Isaiah, using AFAT, and paste in the string from the clipboard. You can do an analysis search if you wish.
  11. Remember that you can create a filter from the search if you want, but not the other way around.
  12. If you want each word highlighted in a different colour, change the formula in excel to use the word OR instead of a comma.

Posts 3810
spitzerpl | Forum Activity | Replied: Fri, Jun 17 2011 8:04 PM

Mark Barnes:
If you want to definitively search every lemma from Psa 118 in Isaiah, let's combine Philip's method with mine, for a 'perfect' result. It's lots of steps, but only takes 10 minutes or so. You'll need Microsoft Excel:

Awesome!

Posts 340
Smithereens | Forum Activity | Replied: Thu, Jun 23 2011 11:51 AM

This thread and the following users were selected by a panel of 5 judges as winners for the "Get an answer to that burning question" event.

Way to go David Sloan, Mark Barnes, and Halo Hound! Look for an email about your prize credit.

Page 1 of 1 (17 items) | RSS