HomeHELLLP!PlanBeeMetric, Imperial and other distance, volume, area, weight, energy, time and temperature measurement unit conversion with ParseRatConsultingLinks

You have all of the data you need to extract in the file above but you want it in comma-separated format and you want the areas in hectares instead of acres and you want the dates spelled out. How will you do it without re-keying?  Metric, Imperial and other distance, volume, area, weight, energy, time and temperature measurement unit conversion with ParseRat  This is how you
want your output
file to look.

ParseRat's built-in
filters will do it
for you.


Ratedat TUCOWS Rated 5 stars at WebAttack.com Paul's Picks Shareware Winner Metric, Imperial and other distance, volume, area, weight, energy, time and temperature measurement unit conversion with ParseRatClick for user comments about ParseRat

Buy Now: Metric, Imperial and other distance, volume, area, weight, energy, time and temperature measurement unit conversion with ParseRat Measurement Unit Conversion with ParseRat Download software: Metric, Imperial and other distance, volume, area, weight, energy, time and temperature 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.

Built-in measurement unit conversion factors

A quick "How To"

Although it costs only $49.95 , 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):
Metric, Imperial and other distance, volume, area, weight, energy, time and temperature measurement unit conversion with ParseRat

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:
Metric, Imperial and other distance, volume, area, weight, energy, time and temperature measurement unit conversion with ParseRat

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:
Metric, Imperial and other distance, volume, area, weight, energy, time and temperature measurement unit conversion with ParseRat

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.


Availability of free evaluation copy: