index like comments

yacov · #1 08-02-2021, 02:43 AM

Hi
is it possible to change the field of the index so that it will be printable with the text.
and it will look small clean and without brackets and XE, similar to comments?
The reason I want to use the index is to insert a concordance file instead of taking comments manually.

Thanks.

Guessed · #2 08-02-2021, 04:59 PM

I don't know how to make the xe tags visible but I have to question how is using a concordance file going to result in numbers that increase in order?

Shouldn't you be using either footnotes/endnotes to do this?

yacov · #3 08-02-2021, 08:46 PM

Hi Andrew,
1. My book includes close to 20000 equations. The equations consist of sentences in the Torah. (The Torah has close to 24,000 sentences).
2. I would like to make it easier for the reader, and show him in every sentence what place I took from in the Torah. (ex. bereshit, chapter 03, sentence 03).
3. I have an excel file with all the Torah sentences in the right order, so that converting them to a concordance file will be easy.
4. When I use footnotes/endnote, I will have to do it manually, because the notes do not work automatic with a concordance file, is it right?
thanks a lot,

Guessed · #4 08-03-2021, 12:27 AM

I fail to see how the index is going to be searchable or useful in any way. If you are putting the B column into the XE entry then your index will just be a series of numbers and the page they appear on. You will then need a separate section (or document) to align that information with the table you showed above.

I don't know that I can help you with this but if you produced a sample document (in English) with examples of what you want to see in your document then perhaps I can suggest a macro to deliver that.

Because I can't read Hebrew, I don't know whether your screenshots above are showing the sentence from the Torah or its location (ex. bereshit, chapter 03, sentence 03). I would have thought that your source 'concordance info' would need three columns: 1 = ID number; 2 = the Torah sentence that might appear in the document; 3 = the location of that sentence (in the Torah).

To me, endnotes is still the feature you would want to be using. There isn't a 'concordance method' built-in to Word to automatically tag this but a macro could do that for you if you had the required components.

Looking at it from the reader's point of view, I would want to see a shorthand source inline with the text - the ID numbers mean nothing without the concordance table that shows what it means. eg
... great line from the Torah(Bere, Ch3 S3) talks about blah...
That is instantly recognisable as a source and doesn't require the user to do an extra step of going to an index to get a reference before opening their Torah at the right location.

yacov · #5 08-03-2021, 02:21 AM

Thanks for your help, the example you attached will definitely help me. And it's better because the reference will appear at the bottom of each page.

As for what I meant, attach a sample file including the concordance to it. If there is an easier way it is always better.
In this method each sentence has a fixed serial number even if it appears several times in the document. (But of course there is the problem of extracting the number from the index)

Guessed · #6 08-03-2021, 04:32 AM

Assuming you are planning on putting a complete Torah table at the end of the document as the reference, you could use code like I did in your sample doc. It reads from the final table in the document. Note that it doesn't appear to pick up every sentence in your sample - I'm not sure why but it could have something to do with RTL languages or subtle differences (like a space or comma) in the text not exactly matching the cell text.

Code:

Sub TagText()
  Dim aTbl As Table, aRng As Range, aRow As Row, rngHit As Range, aFld As Field
  Dim sFind As String, sID As String, sClause As String, sRef As String, rngBk As Range
  Set aTbl = ActiveDocument.Tables(ActiveDocument.Tables.Count)
  Set aRng = ActiveDocument.Range(Start:=0, End:=aTbl.Range.Start - 1)
  For Each aRow In aTbl.Rows
    Debug.Print aRow.Cells(1).Range.Text
    sID = Split(aRow.Cells(3).Range.Text, vbCr)(0)
    sClause = Split(aRow.Cells(2).Range.Text, vbCr)(0)
    sFind = Split(aRow.Cells(1).Range.Text, vbCr)(0)
    sRef = "Clause_" & sID
    
    'enable one of the following rows
    'Set rngBk = aRow.Cells(3).Range       'puts id number in ref
    Set rngBk = aRow.Cells(2).Range       'puts middle column in ref
    
    rngBk.End = rngBk.End - 1
    ActiveDocument.Bookmarks.Add Name:=sRef, Range:=rngBk
    
    With aRng.Find
      .ClearFormatting
      .Text = sFind
      Do While .Execute
        aRng.Collapse Direction:=wdCollapseEnd
        Set aFld = ActiveDocument.Fields.Add(Range:=aRng, Text:="Ref " & sRef & " \h")
        aRng.InsertBefore "("
        aRng.End = aFld.Result.End + 1
        aRng.InsertAfter ")"
        aRng.Style = wdStyleFootnoteReference
        aRng.Collapse Direction:=wdCollapseEnd
        aRng.End = aTbl.Range.Start
      Loop
    End With
  Next aRow
End Sub

Sub KillTags()
  With ActiveDocument.Range.Find
    .ClearFormatting
    .Text = ""
    .Style = wdStyleFootnoteReference
    .Replacement.Text = " "
    .Execute Replace:=wdReplaceAll
  End With
End Sub

yacov · #7 08-03-2021, 05:21 AM

This is greate. thanks a lot.

yacov · #8 08-03-2021, 09:23 PM

Hello Andrew,
The macro works very well, the only challenge is to bring the huge table from Excel to Word. The most convenient way I found is with the help of a special Paste-object-excel spreadsheet. The problem is that in this way the macro does not recognize the table.
Is it not possible for it to identify, since Excel also has VBA?

Guessed · #9 08-03-2021, 10:56 PM

The code could run from Excel or Word but xRefs won't be the right tool to use if the complete table is not ALSO sitting in the same document. It makes sense to not include the full text of the Torah at the back of the document but the incrementing id numbers mean nothing without it.

Take a step back and think about what you REALLY want. If the book is standalone and doesn't require the entire Torah as a table at the end of the document then you need to work out what you DO want. The incrementing paragraph numbers mean nothing without the book/para/sentence id in a massive table.

I would either show a tag as(book/para/sentence) in the document itself and the reader can pick up their Torah to find it. This does interrupt the flow of reading the book but it is simple and standalone.

OR show a simple footnote/endnote tag as(1) in the book paragraph and in the footnote/endnotes area you would show them that that id number is a reference to the location in the Torah that they will understand eg.
1 = book/para/sentence

There is no need to include the sentence itself since that precedes the tag in the document anyway and would be repetitive.

yacov · #10 08-03-2021, 11:16 PM

Thanks for your help, this book started as a PowerPoint presentation, and is already on its way to becoming an encyclopedia.
a miracle:-)

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Can a I create an index in a word document where index entries control sections of the document?	pfriorda	Word	3	12-28-2017 08:02 PM
Updating font in index without updating style of index	Nick B	Word	4	11-28-2016 02:00 AM
Get Paragraph index from bookmark starting index	vince692	Word VBA	6	05-13-2016 04:51 AM
How to Get Rid of Comments?	freschij	Outlook	0	08-02-2011 12:47 PM
Comments	davidcs	Word	0	01-05-2010 12:55 AM