Changing Fraction text to Decimal values

[jstaphse]

I need to change some imported data that was entered as text. the users entered fractional data as

ex. 3 3/4 instead of 3.75. I got the wonderful task of changing ~900 records that have this in multiple fields.

Anyone have a solution they would like to share?

Thanks.

[Raybaudi]

Hi

if there is always a space between number and fraction, you can try to use this calculation as a substitute calc for all records:

Evaluate ( Substitute ( yourTextField ; " " ; " + " ) )

[jstaphse]

Thanks Ray!

I just tried your solution, thinking ir looked odd, and it worked perfect. Now I'm analyzing it to understand it.

Thanks again.