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
  • 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.
Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
dbcc checkdb datawarehouse 2 41
syadmin MSSQL 2 58
would like the bottom of this page to be smaller 3 19
Website Interactive tool that will do calculations 3 31
An enjoyable and seamless user experience can go a long way on an eCommerce site. While a cohesive layout and engaging copy play roles in creating a positive user experience, some sites neglect aspects that seem marginal but in actuality prove very …
Developer portfolios can be a bit of an enigma—how do you present yourself to employers without burying them in lines of code?  A modern portfolio is more than just work samples, it’s also a statement of how you work.
Explain concepts important to validation of email addresses with regular expressions. Applies to most languages/tools that uses regular expressions. Consider email address RFCs: Look at HTML5 form input element (with type=email) regex pattern: T…
This tutorial demonstrates how to identify and create boundary or building outlines in Google Maps. In this example, I outline the boundaries of an enclosed skatepark within a community park.  Login to your Google Account, then  Google for "Google M…

863 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

Need Help in Real-Time?

Connect with top rated Experts

29 Experts available now in Live!

Get 1:1 Help Now