NGCombine.exe
In mid 2005 I needed to merge the text based data output from a scripted process into an existing "archive"
file, without causing the "archive" file to "blow out" with duplicated data. I ideally wanted to be able to call
the application for doing this, from within the script. I decided to solve this with a console application
witten in VB .NET I have since "cleaned" the application up and improved the error checking, so that it is
more robust and self explanatory. The file is small (15KB) and does not require installing...
NGCombine.exe
Combines the contents of two text files sorting the data and eleminating empty lines. (If applied to
a single file, the file is sorted eleminating empty lines.) NGCombine.exe has been limited to processing
1,000,000 records (that is lines of text) per file.
Syntax
NGCombine [/a [X:\...]] [/n [X:\...]] [/o [X:\...]] [/e]
Parameters
/a [X:\...]
Required: Specifies filepath for the file containing original or "Archive" data.
/n [X:\...]
Specifies filepath for the file containing "New" or incoming data. If this file is not specified,
a data sort will occur on the original or "Archive" data only.
/o [X:\...]
Specifies filepath for the output data. If this file is not specified, the default
output filepath is the original or "Archive" data filepath.
/e
Eliminates any duplicate lines of data.
/r
Reverses the sort order.
/?
Displays help at the command prompt.
Prerequisites
You will need to have loaded the Microsoft .NET Framework Version 1.1 on any
workstation on which you want to run this application.
Download
The zip file download of NGCombine.exe here.
The downloaded zipfile will need to be opened and NGCombine.exe can be copied into the system directory
of your workstation or to a directory of your choosing. If you load the file into the system directory
you will not need to use a full filepath to call it.
Improvements
05/03/2006 Improved the Help display.
08/03/2006 Added reverse sort function.
|