Searching for Louw-Nida Domains

Ryan Robinson

I don't know if this can be done. So, I would appreciate if anyone can help me figure out if it is possible. 

So, I want to see what are the highest occurring domains in 1 Corinthians 1:10-4:21. However, I don't want to find the highest occurring subdomains. 

I know how to find the highest occurring subdomain (92.24). I want to know if it's 92 or 1 or 12 and so on. 

If someone could help me here, that would be awesome! 

Thanks!

Keep Smiling 4 Jesus :)

Ryan Robinson said:

I know how to find the highest occurring subdomain (92.24). I want to know if it's 92 or 1 or 12 and so on. 

Dreaming of Concordance export that would include sub-domain counts as shown on screen: (would allow spreadsheet to group domains for summarization)

Louw-Nida sub-domain count in 1 Corinthians 1:10-4:21 is 1330. Screen shot shows domain 92 having count of 288, which is 21.7 %. Domain 89 has count of 186, which is 14 %.

Sense shows a lot of quality and wisdom

Keep Smiling [:)]

Mark Barnes

I’m not at my desk at the moment, but I think you get LN numbers in Analysis export to Excel. If so, what you want should be doable. 

Ryan Robinson

https://community.logos.com/discussion/comment/968491#Comment_968491

Yeah. You do. But again, it would be something like 92.x, not just 92. 

I am not savvy enough on Excel to figure out just the higher level domain with that exported. If you can tell me how to do that, I would be thankful. 

Beloved Amodeo

https://community.logos.com/discussion/comment/968630#Comment_968630

Ryan Robinson said:

Yeah. You do. But again, it would be something like 92.x, not just 92. 

I am not savvy enough on Excel to figure out just the higher level domain with that exported. If you can tell me how to do that, I would be thankful. 

If you already know how to extract the data for export to Excel you are familiar with the hard part, working with the data in Excel is fairly straightforward. First, present the data in the format you desire. Here's what I did.

You will notice that in my example the domains are already in finished format, sorry about that. Next, select the entire column that has Louw Nida followed by the sub-domain; don't select the column heading. On the Home tab note Find & Select at your far right; select this. From the drop-down list select Replace. In the dialogue box, enter Louw Nida. Then select Find All; then Replace All. The result you will be left with are all the sub-domain numbers.

Now you will select all of the sub-domain numbers. Once you have accomplished this your home free. Select Decrease Decimal in the Number field and the result is what you are after. I hope you find this helpful. Should you accidentally select the corner of the cell and replace all the data in the cells to agree with the first cell CTRL-Z will put the data right. 

Keep Smiling 4 Jesus :)

https://community.logos.com/discussion/comment/968630#Comment_968630

Ryan Robinson said:

I am not savvy enough on Excel to figure out just the higher level domain with that exported.

Export Louw-Nida search to Excel file:

Open with LibreOffice (or Excel) followed by inserting a column for Domain

Formula extracts Domain number from string "Louw Nida ##.###" where the number of Domain starts in position 11

=MID(G2,11,FIND(".",G2)-11)

Used FIND since some Domains are single digits while others are two. When Domain has single digit, then FIND returns 12 (so calculates length of one for text copy). When Domain has two digits, then FIND returns 13 (so length to copy is two characters).

Copied formula to rest of column followed by adding another column with value of 1 so could insert a Pivot Table to sum Count by Domain

Sorted Pivot Table Count in Descending Order. Added Calculation to show % Used

Domain 92 has 314 Greek words in passage 1 Corinthians 1:10-4:21

Keep Smiling [:)]

Beloved Amodeo

https://community.logos.com/discussion/comment/968685#Comment_968685

KS4J, Your work not surprisingly supercedes mine. After some effort I was able to duplicate your results in Excel. Thanks for your input. I've learned a lot as usual.