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.
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.
With or without field name headers (e.g. for Microsoft Word mail merge).
Fixed format lines.
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. http://www.guysoftware.com/asplinks.htm
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.
|Windows Help program (WinHlp32.exe) for Windows Vista|
|Windows Help program (WinHlp32.exe) for Windows 7|
|Windows Help program (WinHlp32.exe) for Windows 8|
ParseRat's fully functional 30 day trial version may be downloaded from many places including directly from Guy Software:
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 parserat.zip (approx 1 megabyte), a zipped archive copy requiring an unzipping tool (see below).
|If 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 parserat.zip 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.|
|Most computers already have a copy of the free Adobe Acrobat reader. If yours doesn't please click here.|
Neither the evaluation nor the paid-up version display third-party advertising, or send information from your system to any other place.
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.
|Standard prices are for delivery by Electronic Download (no shipped media).||
$49.95 (USD) (£32.86, €39.91)
Six User Package*
$199.95 (£131.53, €159.74)
Twenty User Package
$549.95 (£361.77, €439.36)
Forty User Package
$949.95 (£624.90, €758.92)
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 (£6.58, €7.99) and a minimum order of $200.00 USD (£131.56, €159.78).
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.
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).
1752 Duchess Avenue
British Columbia V7V 1P9
Note that Vancouver is in the Pacific Time Zone, 8 hours behind GMT.
The current Vancouver time is 06:15:16 PM Saturday, Mar 08 2014
Click here for Guy Software Home Page.