How do I get a word and phrase count from a large text/txt or excel file or MS access database field?

Posted on 2008-10-07
Last Modified: 2013-12-07
Is there any free software, or a macro, or a transcript analyzer, that can take a large text file (500,000+ words), or csv file, or Access database to give me the number of occurances of one word, two word, three word, four word and five word phrases?
Question by:tkeiffer
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 2
LVL 20

Expert Comment

ID: 22669433
What OS are you running ?
You can do this under Linux pretty easily.
If it is windows there are no counting apps built in so you'll need to download it.

Author Comment

ID: 22670627
I am running Windows.

Author Comment

ID: 22670734
I'd even pay for software if it wasn't rediculously expensive and worked on the large files i have.  I found some software called "Textanz" that does what I'm trying to do but it crashes with a memory error 5 minutes into processing at 556,000K memory.
Tutorials alone can't teach real engineering

So we built better training tools.

-Hands-on Labs
-Instructor Mentoring
-Scenario-Based Tests
-Dedicated Cloud Servers

All at your fingertips. What are you waiting for?

LVL 20

Expert Comment

ID: 22671931
I'm a linux fan so I can tell you how to do it there. But I doubt that is the path you want to go down so instead -
a quick google turns up a fair list :


Author Comment

ID: 22672965
I've done exhaustive searches with no avail.  If I found a way to install Linux somewhere then how could I do it?  Could I hire you to do it?

Author Comment

ID: 22673007
One of the main problems with the software on your google search, and my many google searches, is that most of that software only does single word counts.  I need it to examine the text and find all mutliple word phrases and count those too.

Accepted Solution

tkeiffer earned 0 total points
ID: 22675571
I found a free site that will do. I can do up to a 150K words each time which is good enough.  The website is:

Featured Post

Webinar: MariaDB® Server 10.2: The Complete Guide

Join Percona’s Chief Evangelist, Colin Charles as he presents MariaDB Server 10.2: The Complete Guide on Tuesday, June 27, 2017 at 7:00 am PDT / 10:00 am EDT (UTC-7).

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Dramatic changes are revolutionizing how we build and use technology. Every company is automating, digitizing, and modernizing operations. We need a better, more connected way to work together as teams so we can harness the insights from our system…
This post contains step-by-step instructions for setting up alerting in Percona Monitoring and Management (PMM) using Grafana.
Learn how to create flexible layouts using relative units in CSS.  New relative units added in CSS3 include vw(viewports width), vh(viewports height), vmin(minimum of viewports height and width), and vmax (maximum of viewports height and width).
This is a high-level webinar that covers the history of enterprise open source database use. It addresses both the advantages companies see in using open source database technologies, as well as the fears and reservations they might have. In this…

734 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question