+ Reply to Thread
Results 1 to 4 of 4

Indexes and Concordances, oh my !!

  1. #1
    Registered User
    Join Date
    02-26-2020
    Location
    Houston, TX
    MS-Off Ver
    365
    Posts
    19

    Indexes and Concordances, oh my !!

    Scenerio: I must create a "word" index for multiple documents each week. I foresee a time when I'll have to do this with no less than 5 large documents on a daily basis. Eventually I would like to show page:line for each occurrence of a word. I have tried a couple of scripts already. I am much better with Excel than Word and this has me stumped.

    The following script is what I have been using to acquire distinct words:

    Please Login or Register  to view this content.
    I can take this list, convert to a table, add a column, copy / paste, delete extra colum and I now have a concordance.
    ISSUES:
    No exclusion list. I have tried multiple methods but have thus far failed.
    I would like to declare a string such as this -

    Please Login or Register  to view this content.
    And remove such words prior to printing to the new document. That would at least eliminate one step in my process.

    I have found no examples of how I could capture the line number for the index.
    The reason it this will eventually be necessary is that page:line is the standard for the courts.
    Transcripts are 25 lines per page and have a min / max pitch number. Text is imported into a template for proper formatting before I even begin to run scrpts.

  2. #2
    Forum Guru macropod's Avatar
    Join Date
    12-22-2011
    Location
    Canberra, Australia
    MS-Off Ver
    Word, Excel & Powerpoint 2003 & 2010
    Posts
    3,723

    Re: Indexes and Concordances, oh my !!

    Clearly, your StrExcl variable has come from one of my concordance macros (e.g.https://answers.microsoft.com/en-us/...0-0bdb3832f3b0, https://social.msdn.microsoft.com/Fo...?forum=worddev, https://www.techsupportforum.com/thr...t-them.639713/, & https://www.msofficeforums.com/31360-post2.html). It would be a trivial undertaking to enhance that code to output the line numbers as well. For example, with the version in the last link, you could simply change:
    Please Login or Register  to view this content.
    to:
    Please Login or Register  to view this content.
    With the versions in the first two links, it's no more complicated than changing:
    Please Login or Register  to view this content.
    to:
    Please Login or Register  to view this content.
    As I said, a trivial undertaking.
    Last edited by macropod; 01-16-2023 at 04:53 PM.
    Cheers,
    Paul Edstein
    [Fmr MS MVP - Word]

  3. #3
    Registered User
    Join Date
    02-26-2020
    Location
    Houston, TX
    MS-Off Ver
    365
    Posts
    19

    Re: Indexes and Concordances, oh my !!

    You're absolutely correct macropod. I also read the exchange between you and another fellow regarding the concordance and his desired format (same as mine).
    The one I am currently using is by Mr. Wyatt, cut it has no exclusion list, which yours does and such is highly desireable.

    And yes, I was hoping you would respond as your macro achieved most of what I was looking for.

    I am certainly going to try your additional suggestions, once I can come up for air from my daily grind. Hopefully this afternoon.

  4. #4
    Registered User
    Join Date
    02-26-2020
    Location
    Houston, TX
    MS-Off Ver
    365
    Posts
    19

    Re: Indexes and Concordances, oh my !!

    And yeah, the "rules" are dictated by SCOTUS and then the states generally adopt those same rules. But, it does make the transcripts purdie.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Sum of 2 indexes
    By preddy1110 in forum Excel General
    Replies: 4
    Last Post: 06-06-2014, 07:29 AM
  2. Not all sheet indexes are working
    By Excel_vba in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-10-2013, 06:03 PM
  3. Deleting Indexes
    By jingoxx in forum Excel General
    Replies: 0
    Last Post: 01-08-2013, 05:08 PM
  4. [SOLVED] 3D look-ups? Indexes?
    By BRISBANEBOB in forum Excel General
    Replies: 7
    Last Post: 12-04-2012, 11:35 PM
  5. Excel 2007 : Pivot's with Lookups or Indexes
    By Isepic in forum Excel General
    Replies: 2
    Last Post: 04-16-2010, 06:30 PM
  6. Changeable indexes
    By Steel_lady in forum Excel General
    Replies: 3
    Last Post: 05-07-2008, 01:15 PM
  7. [SOLVED] Row, column indexes are HUGE!! Why??
    By Ed in forum Excel General
    Replies: 3
    Last Post: 03-23-2005, 05:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1