Convert legacy database.

Extract field information from system support file and apply to secondary dat files. Analyze system files and write VB program to extract and convert data fields. Apply this structure to flat files and output into Excel format.

Translate 400+ field structure and unpack compressed data fields.

Setup for unpacking compressed fields for record with over 400 fields. Split each record into two halves each with unique identifier and create two Excel spreadsheets, thus allowing more than the 255 fields into Excel.

Convert mortgage data from multiple source companies.

Convert mortgage data from various sources. Read data from various tape formats, converted from many different file formats. These included Variable record types with packed data fields, individual packed data files, straight EBCDIC and straight ASCII.

Custom program "Padder"

Custom program "EZ TAR"

Extracts files / folders from TAR archives. Prevents illegal file / folder names, deals with long and file names. Also works with damaged archives, which have been block padded for appropriate alignment.

Custom program "FileSplitter"

Program to split large files into series of smaller files based on required number or records, bytes or files.

Custom program "Hex Analyzer"

Move through raw files and realign data as needed. Can view in different bit sizes such as 8-bit, 10-bit, 32-bit and 36-bit, reverse endian, swap bytes and convert floating point and binary fields of many styles, offset bytes / bits and set viewing chunk / record size. Also previews EBCDIC, ASCII, BCD, -128 and others.

Custom program "Table Delimiter"

Works with Table Viewer to create custom output in dBase, flat ASCII / EBCDIC and delimited with any character. Also can perform insertion of custom record marks.

Custom program "DupeSplit"

Split duped tape data and processes into data files based on internal tape labeling or create sequentially named logical tape files. Can also convert EBCDIC to ASCII on the fly with various record mark choices.