Ponderances of Steve

August 5, 2012

12 Most Must-Have Free Utilities for Wrangling Text Files

Filed under: gtd,Reviews,Writing — Steve LeBlanc @ 3:14 pm

I love text files. Unlike an MS Word document, text files contain no formatting, which makes them smaller, easier to search and faster to open. They commonly have a file extension of .txt or .log. (Click here to show file extensions on your system.) I use text files all the time. For writing, for lists, links and reminders, for activity logs, and on rare occasions, for programming. I create them, search for them, manipulate them and play with them. While Windows does allow for text files, it sort of treats them like neglected step children, used mostly for batch files (small programs), log files and ReadMe files. Windows prefers to think about proprietary files, like Word and Excel documents. File search in Windows 7 will only look in approved directories. Well, I enter all my articles in a text editor (not a Word Processor). I save files in funny places and I search for them often. I needed better tools than Windows offered and I found them. Most are small, brilliant and portable, (no-install, just unzip and use, with no menu items or registry changes). Any one of these could lighten your workload. So jump right in and give one a try. You’ll find help pages on most of them. At the very least, install Win32pad and Everything file finder, both suitable for newbies. The following are listed in order of increasing geekiness.

1. Win32pad http://www.gena01.com/win32pad/download.shtml

Win32pad is a must-have replacement for the crippled Windows text editor, Notepad. Killer features include: a) full compatibility with Notepad; b) Exit on Esc; c) Auto-indent; d) highlighted, clickable links on well-formed URLs, like http:// and file:// ; and e) File Change alert (when another program modifies an open file, aka Dirty File notification).

2. Everything http://www.voidtools.com/

Everything is a file finder. Search Google for “everything” and you will find the coolest file finder in the world. Everything, by VoidTools, offers AJAX-like find capacity. (Search results populate down as you type.) But unlike the Find box in the Windows Start menu, Everything can find every single occurrence of files on your computer. There are options to include or exclude certain files, file types or whole folders. Search Results include: Name, Path, Size, Date Modified. No one who uses it can ever go back to plain old Windows Search.

3.  BareGrep http://www.baremetalsoft.com/

Baregrep lets you search inside all your files for a word or phrase found inside any of them. It then returns not only the filenames, but also shows you the word in context of each line in which it was found. Thus you see how many times that word showed up in each document. While this works best for text files, it works adequately for Word documents if you just disregard the formatting characters found at the beginning of each search result line. This makes it easy to find stuff when you don’t remember what a file is called. You can think of BareGrep as the Everything tool for looking inside of files for words and phrases.

While Windows offers something similar in its Search box, you have to open every file it offers to see how the phrase shows up in the context of the file. With BareGrep, it’s right there in the Results panel. But what makes it amazing is that it allows you to search on powerful text patterns called Regular Expressions (RegEx). With them, you can search for all lines in all files that contain, for example, a date in any format (12/02/99, 99.12.02, 2 December 1999, or 2 Dec 1999). From the Search results, you can double click on any line to open the source file. While visiting their site, be sure to click on Regex Reference, or learn about Regular Expressions online. Unbelievably useful! (For geeks, this is a GUI version of the grep command.)

BareGrep TIP: While the configuration settings are not sticky (remembered in next session), you can set some command line options in a Windows shortcut to the program, things like default directory. For you geeks, here’s the Target field of my BareGrep shortcut: “D:\Program Files\Util\baregrep.exe” -i -d D:\ ” a ” *.txt This says to launch BareGrep with Ignore Case, Default Folder of D:\, Files type of *.txt and default Text search of ” a “. As I type in new text, it automatically begins to search.

4.  xPlorer2 http://zabkat.com/x2lite.htm

xPlorer2 is a dual-pane, multi-tab file manager to replace the more confusing Windows Explorer. It’s a joy to use and feature-rich. I normally keep two panes open, with 3-5 tabs each. While the Lite version uses the Windows Search command by default, you can change that in Advanced Options or use the better Find utility that comes in the Pro version. There is extensive Help, including great screencasts. A file manager is used to view and play with your files. You can run program installers that you have downloaded or copy files from one folder to another. Or you can rename and move the file attachments from an email that were stored in your Download folder.

xPlorer2 TIP: Check the option in Help / How do I? to see tutorials, but be sure to uncheck it when done. When you click on Help / Contents, you get prompted to download the PDF Help file, xplorer² PDF manual. Unzip it and place it in the program directory of xPlorer2. Unfortunately, the download page for the xplorer2 Help file is confusing. Be sure to click on the top right Download link. Configuration TIP: Be sure to check the following: Tools / Options / Window / Tree / Keep Synchronized with folder in active view pane. For a simpler file manager, more like Windows Explorer in XP, you might prefer CubicExplorer, a nice single-pane file manager with tabs. I found some of the configurations to be confusing. But it’s real easy to use. And the tabs are great.

5.  PNotes http://pnotes.sourceforge.net/index.php

Ever need to write down a quick note while working on other things? PNotes is a sticky note utility, allowing you to create lots of notes on your screen, which can later be dismissed or saved at TXT or RTF files. You can even launch timed reminder notes. I use this program to pop up at regular intervals (15 min) to ask me, “What are you working on? Is there a higher priority?”. My answer goes into my ActivityLog.txt file. I open the file directly from the note by double clicking on the space that follows this line file://D:\dat\ActivityLog.txt. You can set this file to anything you want, as long as there are no spaces in the filepath. Clickable http:// and file:// links (like those in Win32pad) are great in timed reminder notes. Alternatively you could use Stickies which is much like Pnotes.

6.  TyperTask http://www.vtaskstudio.com/support.php

TyperTask is a portable*, tiny (53k) “text expander” utility, to replace repetitive cut and pastes. It works like AutoCorrect or AutoText in MS Word. But it works in every browser, text editor and text box in Windows. The replacement text is triggered by assignment to either configurable keywords or hotkeys. So, you would set a keyword to autoexpand into some block of plain text, such as a signature line in an email. It comes with an adequate Help file. Configuring it is a snap. Alternatively, you might like HotkeyP  HotkeyP is a tiny, portable hotkey manager. Assign a keyboard shortcut or mouse shortcut to any executable file, block of text, document, folder or web page. Harder to configure with poor help file, but worth it. I set my Right-Left mouse clicks (rocker action) to go Back in any browser. And Left-Right to go Forward.

TyperTask TIP: make sure you choose unique keywords, ones you don’t normally use while typing. TyperTask compares to much larger progams, like PhraseExpress (4 mb) and ActiveWords (22 mb) which have the added feature of saving formatting. *TyperTask TIP: As a “portable application,” you will need to unzip this file folder into some trusted place, like a newly created folder called Utils. Create Utils under the Programs folder and unzip this file into there, resulting in this: C:\program files\Utils\TyperTask

Note: A regular (non-portable) program comes with its own installer, which when run, puts the files in the correct folder and places entries into the Start menu and registry. A portable program can be installed onto a USB or external drive, which can then be used on any machine. Or it can be put into any folder of your computer. It makes no changes to the system registry.

7.  Keynote NF http://code.google.com/p/keynote-nf/

Keynote NF is the evolution of Tranglos Keynote (by Marek Jedlinski), with New Features. It’s a hierarchical note taking utility with RTF formatting, much like an editor. It’s amazing for those who think in hierarchies. Killer features include: a) Tie any note to an external txt file. b) Clipboard Capture feature that, when enabled, auto appends to the active note every single time you copy something to the clipboard with Ctrl-C, without ever having to change apps and hit Paste. It’s great for copying lots of text clips or quotes from web pages. For a bit simpler interface, try TreePad Lite  Or you might prefer a webapp for this, like EverNote.com  but it’s slower.

8.  Notepad2 http://code.google.com/p/notepad2-mod/

Notepad2 is another Notepad replacement, available in several different flavors, but geared more towards programmers. This version includes these options: Exit on Esc, File Change Notification and Bookmarks (for jumping back and forth to different locations in the file). For programmers it includes: Syntax Highlighting (color coded keywords in program files), Code-Folding, Highlight Current Line, View Line numbers and Regular Expression search. Plus it will highlight all occurrences of any selected phrase. I love that. Unfortunately, it does not support clickable URLs. That would be a deal breaker, unless I happen to need the bookmarks, which are fun. Choose the first download (.exe) for a regular Windows installer, or use the .zip file for a portable, hand install. (Drop it in your Utils directory and create a shortcut to it.) Then spend some time configuring the Settings and View menus.

9.  Notepad++ http://notepad-plus-plus.org/

Notepad++ is a great programmers editor, but you don’t need to be a programmer to benefit from it. While it does make writing computer code a joy (compared to Notepad), writers will appreciate its many features: a) MDI tabbed editor for multiple documents and session management; b) Regular Expression (RegEx) Search & Replace; c) Select any word and all occurrences of that word are highlighted; and d) Column Mode Select allows for Block Cut & Paste. Say you want to cut all the http:// off the front of each line in the file. Or paste a preface to each line, all at once. Hard to explain without seeing it. There are countless text manipulation commands, like Convert Case and Join Lines, and lots of Plugins. And the program is in constant development. Alternatively you might like PSPad, another great programmers editor.

10.  Programmer’s Notepad http://www.pnotepad.org/

Programmer’s Notepad is an adequate editor for programming. But it is great for those who want to write notes and articles in a text editor, rather than a word processor like MS Word. Features: a) MDI tabbed editor; b) grep-like feature of showing all the lines in the active file that contain a text string; and c) remembers all files that were loaded in last session.

11.  TextView http://www.flos-freeware.ch/archive.html

TextView is a great text file viewer. Nice when you just need to quickly peek inside lots of text files. You can page through a number of files with a single click at a time, one after the other. With another click, you can launch the default editor for the active file (in my case, Win32pad). It is a two-pane viewer. In the left pane is a list of files in the current directory. In the right pane, is the contents of the file you clicked on, looking much like it would in an editor. The benefit is you don’t have to open and close all those files when you are just looking for something. And there is no risk of making any changes to the file. It also allows for Exit on Esc key, one of my favorite features. Plus it’s small and portable.

12.  WinMerge 2.12.4 http://winmerge.org/

WinMerge is “Text Diff engine.” When you need to know if two files are identical, you could use the COMP command-line utility that comes with Windows. But when you actually need to see what has changed, say between two versions, you need a strong file compare utility for Text Differences. WinMerge is a two-pane file viewer, with one file in each pane. This utility allows you to compare two versions of a document, in order to see the differences. It will show line by line comparisons, with different color fonts showing the differences. Includes option Browse the file directory for each file, or Drag & Drop the filename and path from Windows Explorer. And allows for Esc to Exit the program. Alternatively you might like the Text Diff feature in PSPad, another excellent programmer’s editor.

Bonus Section: Not exactly text utilities but very useful.

*   Greenshot screen capture http://sourceforge.net/projects/greenshot/

Greenshot is a fabulous screen capture utility, allowing you to select the area of the screen you want, and add text, arrows, highlighter, obfuscater, all before you even save the file. Even the Help file is excellent. Give it a quick read. Or hit PrntScreen and Drag to select and play. The download also comes as an Installer or a portable zip version. I suspect that even the zip file install modifies the registry some, as it adds a hook to PrntScreen. Small at 1mb and well designed. All my favorite things. If I were to create a screen capture program from scratch, this is how I’d do it. Perfect for those who write tutorials. But for faster auto-save of lots of screenshots, you might prefer MWSnap.exe

*   KeePass http://keepass.info/download.html

Some folks keep their passwords in text files, some on scraps of paper, neither of which is very secure. KeePass is a popular password database that sits on your PC. Save all your passwords in a single password protected, encrypted database file. Also allows for some automated logins and auto insert of key text, like Username and Password on web forms. Easy to use (except for the automation) and allows you to “Export to text file.” Or you might prefer the webapp LastPass.com for saving your passwords “in the cloud,” meaning online.

Text files, they aren’t just for geeks anymore. Or maybe you’re geekier than you think. Every one of these makes far more sense when you see a screenshot of the utility. So feel free to visit each site. Best of all, every one is FREE. What are some of your favorite text utilities?

About these ads

4 Comments »

  1. Your comment about Greenshot reminded me of a program called CleanPrint, which is great for editing webpages so you can save paper and only print what you like. ‘CleanPrint is an eco-friendly tool that saves paper, ink and money when printing from the internet.’ http://wordpress.org/extend/plugins/cleanprint-lt/

    Comment by germanbini — January 2, 2013 @ 8:30 pm | Reply

    • Thanks for comment germanbini. I went to the link and did not quite get how ClearnPrint would benefit a wordpress blog. Might even confuse some readers. But on research, I found there are extensions for all popular browsers, like Chrome, Firefox, IE, Safari and even iPad. As a browser extension, it make great sense. So for that I thank you. Will be trying it out. http://www.formatdynamics.com/bookmarklets/ Nice design and nice site, and I assume, nice folks.

      Comment by Steve LeBlanc — January 3, 2013 @ 7:24 pm | Reply

  2. Do you have a recommendation for parsing a text file – such as a Maillist Digest to import the individual posts into a database?

    Comment by David Anders — November 3, 2013 @ 12:53 pm | Reply

    • David,
      Not exactly. But you should be able to use any of these to get the job done. Here are the Good, Better & Best options:
      1. Any good text editor, such as Notepad++, PSPad, or Programmers Notepad mentioned above should be able to do what you want. But you’ll have to do some fancy RegExp work to get it right. If you don’t know how to use Regular Expressions, you should learn it, given the nature of your question. It’s used in many command line tools, in Linux and Windows.

      2. http://www.grymoire.com/Unix/Sed.html SED is a stream editor for Linux & Windows, allowing you to do quite complex Search & Replace functions. But it’s like learning a small language. Learning RegExp (Regular Expressions) is half the battle. If are willing to learn a language like Perl, Python, Ruby or even Windows PowerShell, you can do this too. They were designed for powerful text manipulations, and all use RegExp.

      3. http://www.turtlewar.org/projects/gentext/ Gentext looks like your best bet. It was designed for just this sort of text parsing. It’s not well known. It’s tricky to learn, but very powerful. Unfortunately, there are no good tutorials for it, but there are examples in the download. I have yet to learn it well. It does Search & Replace really well, with all sort of logic branching and added text, such as HTML, in the output. Just output your result into a tab delimited list, and you can import that into a database.

      Hope this helps. Come back and let me know in the comments.

      Comment by Steve LeBlanc — November 3, 2013 @ 1:56 pm | Reply


RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

The Rubric Theme. Blog at WordPress.com.

Follow

Get every new post delivered to your Inbox.

%d bloggers like this: