I have a text field that I am pulling from a database that represents a size value. I would like to convert that value from text to numeric in CR so that it will be compatible with another program where the data needs to be in short integer format.

The problem: ToNumber doesn't work because it has special characters throughout.

Data returned looks like this:

MeterSize
3/4"
5/8"
1/2"
2"

I tried using Replace (metersize, ""","") to remove the inch symbols, but I think crystal is having an issue with the symbol.

Any tips on taking out the inch symbols (")?
Any tips on getting CR to recognize the division symbol (/)?



                                          

Edited by adavis - 02 Jun 2014 at 5:18am

i believe you can also use the single quote around the double quote in a replace()