maengler2000
Technical User
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.
We are using CR 2008.
Thanks for your help.
Follow along with the video below to see how to install our site as a web app on your home screen.
Note: This feature may not be available in some browsers.
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;