Converting String field to number 2

[justinkeller]

Hello,

I need assistance in trying to convert a string field to a number. My problem is that I have a few instances where non digits were used to signify blank values- ie. N, X so the simple tonumber command will not work. I do not care about the non numeric values. Is there any way to convert everything else and just ignore these problem instances?

Thanks

 

[IanWaterman]

Assuming you are using CR9 or above you can test for numeric text

if isnumeric(stringnumber) = true then tonumber(stringnumber)
else 0

Ian

 

[justinkeller]

That works perfectly. Thanks for the help

 

[kenhamady]

Or you can use VAL() which automatically returns zeros when it encounters strings. It also can read the digits before the first string. The formula:

Val ("102B")

returns the number 102.

Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guides to Formulas, Parameters, Subreports, Cross-tabs, VB, Tips and Tricks

http://www.kenhamady.com/