TNS Utilities

Windows Utility Software from TNS

MATCHCON.EXE Match 2 pre-sorted files on any key and transfer column data
MATCHMEM.EXE Match 2 unsorted files on numeric key and transfer column data
MATCHMAA.EXE Match 2 unsorted files on any key and transfer column data
SELECCON.EXE Select records from a file using another file of key values
MULTCON2/(3)/(4).EXE Select records from a file using 2, 3 or 4 files of key values
MERGECON.EXE Merge up to 9,999 pre-sorted files on up to 3 keys of any type, very fast.
UNIX_PC.EXE Convert Unix files to PC format (change LF to CR/LF)
PC_UNIX.EXE Convert PC files to Unix format (change CR/LF to LF)
HEAD.EXE Display the first X records of a file to the screen (>a file)
BODY.EXE Display records X through Y of a file to the screen (>a file)
TAIL.EXE Display the last X records of a file to the screen (>a file)
EEKNULLS.EXE Convert any NULL characters in a file to any other character.
RECBYTES.EXE Check that all fixed-length CR/LF-terminated records are the same length, and
display the records/numbers of any that aren't.
XCOL32.EXE Transform records with 2 keys into one record per key#1, with one column per key#2

All of our programs are small 32-bit EXE files, and most display a '%Complete' bar.
You can call these programs in Windows 95,98,NT,2000,XP from the DOS-prompt, or Start/Run, or using a shortcut, or a .bat file, or from Visual Basic or Delphi, in other words from any place it is valid to call an .EXE program with parameters.
Many of the programs perform the same function but in different ways to make life easier: for instance there is a data-matching program which is fast and handles only numeric keys, and another which is slower but handles any kind of key, and another which is fast, and handles any type of key - but needs all files to be sorted first.
You can also choose which program fits your PC configuration: one is suitable for a PC with loads of RAM, another can manage with less RAM but may not be as fast.
If you program in Visual Basic, we can supply examples of code which show how to call our programs. We could also produce versions of any of these programs which work with variable-length records, or with fixed-length records without CR/LFs, if there is a demand.

Why not download this sample program, then try it out with your own data?

Click * HERE * to download sample stuff in ZIP file format
- extract the files to any folder, then read the README.TXT file

MATCHCON.EXE	Match 2 pre-sorted files on any key and transfer column data
MATCHMEM.EXE	Match 2 unsorted files on numeric key and transfer column data
MATCHMAA.EXE	Match 2 unsorted files on any key and transfer column data
SELECCON.EXE	Select records from a file using another file of key values
MULTCON2/(3)/(4).EXE	Select records from a file using 2, 3 or 4 files of key values
MERGECON.EXE	Merge up to 9,999 pre-sorted files on up to 3 keys of any type, very fast.
UNIX_PC.EXE	Convert Unix files to PC format (change LF to CR/LF)
PC_UNIX.EXE	Convert PC files to Unix format (change CR/LF to LF)
HEAD.EXE	Display the first X records of a file to the screen (>a file)
BODY.EXE	Display records X through Y of a file to the screen (>a file)
TAIL.EXE	Display the last X records of a file to the screen (>a file)
EEKNULLS.EXE	Convert any NULL characters in a file to any other character.
RECBYTES.EXE	Check that all fixed-length CR/LF-terminated records are the same length, and display the records/numbers of any that aren't.
XCOL32.EXE	Transform records with 2 keys into one record per key#1, with one column per key#2