Conversion between units

Hi. I am working on a project where i need to do calculations based on physical length measurements. The data i get can consist of three different measurement units (meters, feet, and inches), and there is an arbitrary amount of measurements. The format is

[measurement1][unitX][measurement2][unitX][measurement..n][unit..X]

[measurement1][unitZ][measurement2][unitX][measurement..n][unit..Y]

[measurement1][unitZ][measurement2][unitY][measurement..n][unit..Z]

and so on. My calculations expect the data to be meters, so i have to convert the measurements to meters before i begin my calculations.

How would you go about dynamically converting these measurements to meters, when the units can jump around all over the place?

Developer

Input

Parse

Spatial Analysis

Data Investigation

Accepted answers

philipmannering

Hi @3p_khr ,

Perhaps something like the solution attached would work. You would just need to manually add the conversion amounts to the Text Input Tool.

Hope this helps,

Philip

Dynamic unit conversion.yxmd

All comments

philipmannering

Could you do a find and replace on the unit? (I guess you would need to do this three times, unless you pivoted your data) So if you find an inch, append the value 0.0254, 'meter' => 1, etc. Then multiply by that conversion factor for each of your measurements.

If you provide some dummy data, I can mock something up.

Philip

3p_khr

Hi Philip, i have been looking at the dynamic replace, but in the end i had to give up.
I would love to see your solution to my problem. I have attached some mock data.

MockData.csv

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703