Rated
at TUCOWS
Measurement Unit Conversion with ParseRat 
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 may provide your own conversion rules.
ParseRat permits you to import data from one format, perform various transformations on individual fields and export to the same or a different file format. These transformations may include converting from one measurement unit to a different one.
Although it costs only $49.95 (£33.89, €40.43), ParseRat is a very powerful file converting application, so it may seem a bit overwhelming if you only want to do some simple measurement conversions. The measurement conversion function was added at the request of people who were already using it to do other conversions. These quick instructions will ensure that you have no trouble (you might want to print them for easy reference).
Start ParseRat and open the input file containing your data by clicking on the "Open" icon. ParseRat will auto-detect many file types.
ParseRat may automatically recognise the input fields (it will for CSV and tab-delimited), otherwise you need to specify their locations or the delimiters.
Assuming that you want all of the data in your original file preserved in your new one, click the "Copy all input fields to output fields" button. (You may fine tune the output format if you wish later.)
Click on the Combo tab to open the Combo panel.
Click on the WHITE column to the right of the legend "C1="
Click on the name of the field containing the measurement to be converted in the column of input fields. Notice that the field name appears against the "C1=" legend and the contents of the field appear against "Combination 1" in the lower panel. For an example where house sizes are given in square feet for various addresses the screen looks like this (this house has an area of 1,234 square feet): 
Click the "Unit Conversion" button at the top right of the Combo panel. The conversion selection panel will open.
Select the type of conversion using the radio buttons (e.g. "Distance", "Area", etc.)
Select the "From" and "To" measurement units. Notice that the conversion factors supplied by the program appear in the "equation" panel, along with the results.
The result Y is produced by using the equation Y= A + BX, where X is the data from the input file and A and B are the multiplier and offset for the particular conversion being performed. In this case X is 1,234, B is 0.0929030435966113 (the multiplier to convert square feet to square meters) A is zero (it is used only if there is an "offset" - e.g. in temperature conversions) and Y (the result in Convert 1) is 114.642355798218 (the square meter equivalent of 1,234 square feet).
The screen looks like this:
In order to place the converted value into your output file, select the "Output" tab.
Click the "Add Field" button, then scroll down the "Field Name" list in the "Parser Generated Fields" panel until you reach "Convert 1" and click on that name. The converted value will now appear in the new output field you just added. (It will be called "Convert 1", but if you don't like that name click on the "Rename" button and give it a new name.}
To format the data field: check the "Numeric Field" box, then enter the number of decimal places desired. In this example, 1,234 square feet has been converted to 114.642 square meters and that result has been added to the output data record. The screen now looks like this: 
You may convert up to three additional fields in a single pass, using Combination 2, etc.
At this time you may select the kind of output file you desire (default is comma-delimited), then click the "Output" toolbar icon and create your output file.
Click here to see some other screen shots showing other ways in which you might use ParseRat. |
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). |
Basic Price |
For shipped media as below |
Additional charge |
|
|
Single User |
$49.95 (USD) (£33.89, €40.43) |
Disk and printed manual, by airmail - USA/Canada |
$10.00 (£6.79, €8.09) |
|
|
Six User Package* |
$199.95 (£135.67, €161.86) |
Disk and printed manual, by airmail - other |
$20.00 (£13.57, €16.19) |
|
|
Twenty User Package |
$549.95 (£373.15, €445.18) |
Disk and printed manual by express courier |
$50.00 (£33.93, €40.47) | |
|
Forty User Package |
$949.95 (£644.55, €768.97) |
| ||
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.79, €8.09) and a minimum order of $200.00 USD (£135.70, €161.90).
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). 
Guy Software,
1752 Duchess Avenue
West Vancouver
British Columbia V7V 1P9
Canada
Tel: (604)926-1370
Fax: (604)926-1346
|
Note that Vancouver is in the Pacific Time Zone, 8 hours behind GMT. The current Vancouver time is 01:03:50 PM Thursday, Jul 29 2010 |
Click here for Guy Software Home Page.
