Convert Feet and Inches to Inches

[maengler2000]

My data is a string 5' 4" and I need to convert it to inches or 64"

We are using CR 2008.

Thanks for your help.

 

[kray4660]

It would be a bit tricky since you would have to parse out each of the numbers then convert and do the math.

numbervar feet;
numberbar inches;
feet := val(left({field},instr({field},"'")-1);
inches := val(mid({field},{field},instr({field}," "), len({field}) -1);

feet *12 + inches

If I did the mid properly and the feet/inches are always formatted the same. I think this should work. Not tested.

 

[CoSpringsGuy]

another interesting option. This will also account for measurements without inches ex.. 6'

numbervar feet := val(split({@field},"'")[1]);
numbervar inches := if instr(split({@field},"'")[2],"""") > 0  then
    val(split(split({@field},"'")[2],"""")[1])
    else 0;
(feet*12) + inches;

_____________________________________
Crystal Reports 2011 and XI
Intersystems Cache 2012 ODBC connection

 

[SkipVought]

Hi,

This is the problem working from a report, usually one generated by Unknown.

I'll bet that the source table has more definitive data: either in single units, defined with an additional UNITS field, or multi fields like FEET & INCHES. So my major quest would be to access the source data.

Skip,

_{Just traded in my OLD subtlety...
for a NUance!}