convert string to number

[jvolden]

Does any one know of a way to convert a string to a number in Crystal reports 11. Is this possible?

Thank you

 

[Naith]

I would say with the ToNumber or CDbl functions. Of course, without seeing an example of the string in question, I'm just assuming that your string is comprised entirely of numbers.

 

[jvolden]

the string is made up of numbers, periods and a comma. It is a version number for a definition library. We want to be able to say if table.deflib < table.currdef then. The currdef field is numeric and the deflib is a string. When I use the functions mentioned I receive a message stating the strin is non-numeric.

 

[bdreed35]

Can you post sample data and expected results?

~Brian

 

[jvolden]

the string field deflib currently displays 3.21.345,423.
the currdef filed is 3.3.000,100.

I need the string field to be numeric so I can write a condition formula like this
if table.deflib < table.currdef
then
do something.

I can't do this right now because one field is numeric and the other is a string.

 

[bdreed35]

try this:

tonumber(replace(replace({table.deflib},".",""),",",""))

~Brian