+ Reply to Thread
Results 1 to 1 of 1

Need to parse cell and count instances of specific text

  1. #1
    Registered User
    Join Date
    02-11-2010
    Location
    Maryland, USA
    MS-Off Ver
    Excel 2007
    Posts
    83

    Need to parse cell and count instances of specific text

    Hoping someone here can help with this... COL R of the attached spreadsheet, includes multiple patent claims in each cell. The text of each claim in the cell is preceded by the text “ | “ (1-3 digit(s) for the claim number) “. “ (except in a few instances where the cell begins with "1. " so that it isn't preceded by a " | ".

    I need to parse the text of each claim to categorize the claims in a given cell into 3 categories (System, Method, or Composition). I’d like to create the following additional columns based on this data:
    a. (COL S) with a count of Method claims, (These claims would include one of the following strings within the first 10 words: "method", "process", and/or “computer readable medium”).
    b. (COL T) with a count of System claims, (These claims would include one of the following strings within the first 10 words: “apparatus”, “system”, "structure", "product", "assembly", and/or "construct").
    c. (COL U) with a count of Composition of matter claims (These claims would include the following string within the first 10 words: “composition” and/or "material").
    d. (COL V) with a list of claims that do not have the syntax for any of the three categories above.

    So, for example:

    Sample - results of parsing claims.xlsx

    Thanks in advance. This is just beyond my excel skills
    Last edited by robbyvegas; 10-20-2015 at 11:47 PM. Reason: fixed mislabled new columns

+ 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. Replies: 3
    Last Post: 08-04-2015, 08:03 AM
  2. How to count and report instances of specific text in a block of cells?
    By Rowlock in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-17-2014, 06:23 AM
  3. VBA Find all instances of a specific string and copying the number of count in cell
    By dilshandil in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-23-2013, 10:27 PM
  4. Replies: 6
    Last Post: 06-20-2012, 07:23 PM
  5. How To Parse Specific text from String Data
    By zaidan in forum Excel General
    Replies: 2
    Last Post: 04-08-2011, 04:34 AM
  6. count number of instances of a text string in a cell
    By lawrencef in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-28-2008, 01:55 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