Notice: Undefined index: id in /home/www/guysoftware/cookieandcurrencyinclude.php on line 4

Notice: Undefined variable: HTTP_REFERER in /home/www/guysoftware/cookieandcurrencyinclude.php on line 14

Notice: Undefined variable: HTTP_HOST in /home/www/guysoftware/cookieandcurrencyinclude.php on line 15
Convert legacy data files using ParseRat Data, Database and File Parser, Converter & Restructurer from Guy Software HomeHELLLP!PlanBeeParseRatConsultingLinks

for Microsoft Windows systems

Now     Download Free Trial of ParseRat (1 MB download) (30 day free trial - see below) Click for user comments about ParseRat

Free yourself from re-keying legacy data. Use ParseRat™ v2.0 to extract, import and re-map data from just about anything or to convert measurements:

Fixed format lines up to 32767 bytes line length.

Delimited Files - pretty much any delimiter and up to 500 fields.

dBase files (up to 500 fields).

Binary files: Many binary files consist of a header followed by a series of fixed-format records. ParseRat allows you to skip the header (if any) and export fields from the following records - with translation of binary numbers if needed. Ability to process "Packed Decimal" - COBOL Comp-3 type and "Big Endian" - Motorola pattern as well as "Little Endian" - Intel pattern binary numbers.

EBCDIC: ParseRat can read EBCDIC files, typically used in mainframes and frequently forming legacy data to be imported to new systems. ParseRat can correctly handle packed, zoned and can translate binary numbers garbled as a result of character-by-character conversion of EBCDIC files by file transfer tools such as IND$FILE and Kermit. Provides a valuable junction between your legacy data and your new applications.

Page Image Files (and other multi-record blocks), single or multiple records per page, with or without headers and footers, fixed format blocks or tag/flag-defined fields. Automatic detection of tags in files of XML format.

HTML files and captured/saved web pages: ParseRat's ability to define single or multi-line blocks based on tags and to extract fields within them also based on tags makes it ideal to import data from structured web pages and HTML files (e.g. convert your NetScape bookmark or address file to a database or mailmerge file). Special routines are included to make data import quick and easy from HTML tables on web sites.

XML: Automatic detection of tags in files of XML format.

Take files posted as a result of users completing HTML forms on web pages and convert them into databases.

As an alternative to input from files (of any length), data may be parsed from the system clipboard (very useful for extracting data from emails and web pages).

Your proprietary library package doesn't provide a utility to export your collection data to dBase? No problem, just have it print catalogue cards to a print file. ParseRat will read the print file and extract the data for you.

Convert the data elements to a different format:

Change date and time formats. Read foreign language dates. Extract integer Year, Month, Day, Hour, Minute, Second. Generate Day of Week. Create four digit years from two digit years with intelligent century choice for Year 2000 (Y2K) conversions. Translate to and from Julian Day Numbers (days since 4713 B.C.) with or without fractional days. Translate "seconds since 1970" date/times.

Recognise decimal, hexadecimal and scientific format numbers in input fields.

Unit Conversion? The information you are importing contains data in square meters, but your database requires it in square feet? No problem, ParseRat has over 2,300 conversions built in for distance, area, volume, weight, energy, temperature and time. If it doesn't have the unit conversion you need, you can provide your own conversion rules. (2.0b) Click here for more detail.

Export numeric data as decimal, hexadecimal and scientific formats. With or without leading zero file for fixed length fields.

Split and combine input fields.

Reassemble and re-parse improperly parsed groups of input fields produced by other products.

Analyse name information. Parse out names into title, first name, middle names, last name, name suffix components. Get usable mailing names from those telephone list CD-ROMs by cutting out noise phrases like "Teen Phone", "Fax Line", "Residence" etc. Correctly recognise multi-word surnames like "Van der Pohl" and "de la Salle". Optionally strip accents for use with software which cannot handle accented characters.

Name Parsing? The CD-ROM you bought has names like "de la Mere Michael S Arnold Jr Dr Psychtrst Residence" in it. You can hardly use it as a mailing list in that format. No problem, ParseRat will remap it to "Dr Michael S Arnold de la Mere Jr" (and if you want, it will even leave off the "Jr" or export the name in fields as "Dr","Michael","S Arnold","de la Mere","Jr") at a fraction of the cost of other data mapping products.

Genderize names, creating default male, female or couple titles from first names. Create appropriate salutations. 10,000 first names are pre-programmed and you can import 10,000 more.

Analyse street address information. Parse out into suite designator, suite number, street number, street name, street designator, street direction, odd/even and put non-civic address elements into a separate field. Produce a "standardised" address if required.

Analyse City address line, parsing out into City, State/Province, Postal/Zip and substituting approved abbreviations. Recognise US, Canadian, British and most European postal code formats.

Change the case of fields on output, UPPER CASE, lower case, Proper Case (correctly handling capitalisation exceptions like McDonald or WordPerfect).

Generate Soundex codes. Soundex codes permit you to match "sound-alike" words, which is handy for de-duplication of lists. For example Beaulieu and Bewley share the soundex code B400.

Optionally strip accents, changing matinée to matinee, for example. Some software "breaks" when presented with accented characters. This can cause a problem when importing accented name and address data from legacy files into some mailing programs unless you remove the accents to "unaccent" it by removing each accent by substituting the unaccented character.

Calculate arithmetic expressions involving the the input fields (e.g. totals and percentages).(2.0b)

Perform additional transformations using "plugin" programs which you write in almost any computer language.

Eliminate duplicate records (and non-identical records containing effectively duplicate data) based on individual field analysis.

Write out to new format and structure

Delimited lines.

With or without field name headers (e.g. for Microsoft Word mail merge).

Fixed format lines.

dBase table.

XML File.

WordPerfect merge file.

System clipboard for pasting into other matrices (e.g. Microsoft Excel) or databases.

Insert "header" and "trailer" blocks in output files. This gives the ability, for example, to generate web pages of list-type data directly from a database. e.g.

Command Line Interface permits calls from shortcuts, batchfiles or other programs needing sophisticated input parsing.

Interleaved Output. You may wish to use your output file as input to a mailmerge program which prints several mailing pieces on a single sheet of paper. Interleaving records permits you to maintain the same sequence as your input records after cutting up the output stack.

Standalone product. ParseRat is a standalone executable of less than 2 megabytes. It does not rely on the presence of the database engines of other products (its competition often does).

Click here to see some screen shots showing how you might use ParseRat in your data migration tasks.

This computer is not running Windows. Therefore you should not install PlanBee on it. This software product uses the classic HLP help format for providing assistance to users. Microsoft no longer automatically includes support for that format in the latest versions of Windows, but provides it on request. You may download the appropriate version for your system directly from Microsoft by clicking one of the links below.
Notice: Undefined variable: bits in /home/www/guysoftware/winhelp.php on line 45
You are using *OS/2* on this machine.
Windows Help program (WinHlp32.exe) for Windows Vista
Windows Help program (WinHlp32.exe) for Windows 7
Windows Help program (WinHlp32.exe) for Windows 8

Availability of free evaluation copy:

Notice: Undefined variable: HTTP_USER_AGENT in /home/www/guysoftware/parserat.htm on line 215

ParseRat's fully functional 30 day trial version may be downloaded from many places including directly from Guy Software:

Click here to download a directly usable installer (approx 1 megabyte) which does not need to be unzipped. If your system gives you the option to "Run" or "Open" instead of to "Save", you may click the "Run" or "Open" button to perform the install immediately. Otherwise save to disk the file prtinst.exe (keeping a note of the folder) then double click on it in Windows Explorer to perform the install.
(Internet Explorer example)

While the directly usable installer is very convenient, it is an EXE file and some systems block these or warn against their use. However you are downloading the file directly from the Guy Software site and therefore no other party has had the opportunity to tamper with it.

Click here to download (approx 1 megabyte), a zipped archive copy requiring an unzipping tool (see below).

SIMTELIf you are located a long way from Chigaco (this site's physical location) you might get a faster download by connecting to one of the mirror sites of the SimTel file collection, located all around the world.
To start your download of from the SimTel file collection location nearest you, click here to select your nearest location.
If you are unfamiliar with installing downloaded software you may click here to see a tutorial.
You may view the help file on line by clicking here.
(If your browser does not know what to do with a HLP file, it might ask you which application to open it with. If so, please select WINHELP32.EXE in your Windows directory.)
Although the help file contains all of the information, you may download a ZIP file containing the manual in MS Word 2.0 format (which most word processors can read) by clicking here or a file in PDF format which needs the free Adobe Acrobat reader by clicking here.
Download free Acrobat reader Most computers already have a copy of the free Adobe Acrobat reader. If yours doesn't please click here.
Guy Software Privacy Policy

Neither the evaluation nor the paid-up version display third-party advertising, or send information from your system to any other place.

About ZIP files.

Software for download is often provided in files whose names end in .ZIP. These are compressed files, which save download time and group a set of files into a single file for downloading convenience. In order to make use of these files, you need to be able to "unzip" them and many computers are shipped with "Unzipping" software, which permits you to doubled-click on the downloaded ZIP file and will then allow you to access the files in it. If your computer does not have such software (i.e. nothing happens when you double-click the ZIP file, or you see gibberish when you do so) we recommend that you download and install WINZIP's free evaluation copy from

Pricing for ParseRat

Prices in Pounds (), Euros (€) and other currencies are conversions from US Dollars and will be recalculated based on currency rates at the time of order.

Select another currency:
Standard prices are for delivery by Electronic Download (no shipped media).

Basic Price

Single User

$49.95 (USD) (35.86, €50.34)

Six User Package*

$199.95 (143.56, €201.51)

Twenty User Package

$549.95 (394.84, €554.24)

Forty User Package

$949.95 (682.02, €957.36)

Rate for Euros (€) and British Pounds () last checked 30/May/2015 05:15 AM GMT
*For use in a bona fide educational institution the limit of six users is waived provided all users are in the same classroom.

Non pre-paid purchase orders are accepted only from government and corporate entities and are subject to an additional handling charge of $10.00 USD (7.18, €10.08) and a minimum order of $200.00 USD (143.59, €201.56).

For the single copy licence, if PARSERAT is installed on the internal hard drive (or equivalent) of a computer and one person uses that computer more than 80% of the time it is in use, then that person may use PARSERAT on one other computer.

Buy the Fully Licensed Version of ParseRat by clicking here

Any questions about the status of the shipment of the order, refunds, registration options, product details, technical support, volume discounts, dealer pricing, site licenses, non-credit card orders, etc, should be directed to Guy Software (click on the Email icon here). E-mail

Guy Software,
1752 Duchess Avenue
West Vancouver
British Columbia V7V 1P9

Tel: (604)926-1370
Fax: (778)279-1752

Note that Vancouver is in the Pacific Time Zone, 8 hours behind GMT.
The current Vancouver time is 01:15:53 PM Saturday, May 30 2015

Webmasters, shareware download sites and re-sellers Click here for PAD XML file with product details in standardized form.

Click here for Guy Software Home Page.