Solved

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
7
796 Views
Last Modified: 2013-12-07
Hello,
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?
0
Comment
Question by:tkeiffer
  • 5
  • 2
7 Comments
 
LVL 20

Expert Comment

by:edster9999
Comment Utility
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.
0
 

Author Comment

by:tkeiffer
Comment Utility
I am running Windows.
0
 

Author Comment

by:tkeiffer
Comment Utility
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.
0
Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

 
LVL 20

Expert Comment

by:edster9999
Comment Utility
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 :

http://www.google.com/search?q=windows%20software%20to%20count%20occurence%20of%20words

0
 

Author Comment

by:tkeiffer
Comment Utility
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?
0
 

Author Comment

by:tkeiffer
Comment Utility
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.
0
 

Accepted Solution

by:
tkeiffer earned 0 total points
Comment Utility
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:  http://www.writewords.org.uk/phrase_count.asp
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Read about achieving the basic levels of HRIS security in the workplace.
Although it can be difficult to imagine, someday your child will have a career of his or her own. He or she will likely start a family, buy a home and start having their own children. So, while being a kid is still extremely important, it’s also …
This tutorial walks through the best practices in adding a local business to Google Maps including how to properly search for duplicates, marker placement, and inputing business details. Login to your Google Account, then search for "Google Mapmaker…
Any person in technology especially those working for big companies should at least know about the basics of web accessibility. Believe it or not there are even laws in place that require businesses to provide such means for the disabled and aging p…

743 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

16 Experts available now in Live!

Get 1:1 Help Now