String Field to Numberic Value

[TEM3]

Using Crystal Reports 8.5:

I have a mixed bag string field in an Oracle 9i table that I need to convert the records that are numeric into values. Most of the records are in the form "0.0123". Some have a "%" tacked onto the end. Some records are non-numeric, such as "Not Detected". I need to test for a numeric string and then, if so, convert it to a numeric value.

 

[Knoxville]

IF IsNumeric({fieldname})
THEN ToNumber({fieldname})
ELSE
0 (or whatever you want the default to be)

 

[GJParker]

You can use the IsNumeric() function which returns true or false.

HTH

Gary Parker
MIS Data Analyst
Manchester, England