When I ‘m trying to work with text files that are so big I can’t even open them with programs like Excel, Notepad, or PSPad, I reach for the FREE file-splitter program.
Tag Archives: file
Free File-Splitter Program
Filed under Audit, Free, How to..., Technology, Written by Skyyler
PSPad: Great Text File Audit Tool
PSPad is a great text editor and search tool, so by default, it’s a great audit tool, and it’s free. It can also handle a million lines of text–literally. Are you interested yet? It is also a great file diff/compare tool I’ve ever seen.
PSPad works with text files, such as those ending in TXT or CSV, or any text-based file (like an ini file). It works with DOC files too.
I’ll explain how to do the following with PSPad:
- Search a file (find all lines containing X)
- List all occurrences/matches of a search term
- Export a list of occurrences
- Compare 2 documents (diff)
- Download & install PSPad
ACL tip: Create a File Import Script
Did you know that you can create a script to import a file into ACL? That you can automate loading a table?
I’m talking about the File > New > Table command in ACL, also known as the Data Definition Wizard. Yes, you can create such a script, and I’m going to teach you how!
The good news is that it’s so much easier than you think. The bad news is that it doesn’t APPEAR easy, but it really is, because ACL does the heavy lifting for you. I promise that if you hang in there, you’ll so be a pro. Just try it once, and you’ll be hooked!
Filed under ACL, Data Analytics, How to..., Scripting (ACL), Written by Skyyler
My Favorite Windows Software
In Top 100 Network Security Tools and Easy Windows Scanner, I described a few Windows tools that every auditor or security analyst should know or know about. In this post, I highlight some of my other favorite Windows tools (both security and general utility software). ALL OF THEM ARE FREE.
12/26/14 Update: These are STILL my favorite programs. The only one I don’t use anymore is CutePDF Writer, which I replaced with the FREE Sumntra PDF
Foxit Reader (I no longer recommend FOXit). But if you only want a PDF printer, CutePDF is still a great solution.I also added 2 new tools: PSPad and File Splitter (see my links at the bottom).
Filed under Audit, Free, How to..., Security, Technology