New Grove icon Stuff by Peter Stone

Home
(New Grove)

Home Stuff

Get Inventory Script (to file)

Get Inventory Script (to DB)

Get Inventory Search Script

Combine Data Files Console Application

Unix Date Time Convertion

TimeKeeper

Clicker

Central Administrative Host Updating

Randomly Select Data From a List

VMware Windows Services Modifier

Federated Search

Insert Image Metadata Script

PHP Search Engine

Detect High Memory Usage

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.

Creative Commons License
This work is licensed under a Creative Commons Attribution 3.0 Unported License.