Can Strings Take a Number Value 1

[LadyAmpherion]

If I have a USF1:String[20] that holds a number, can I make Crystal Reports use it as a number? If so, how do I do that?

Please advise and Thanks!

Louanne

 

[Ngolem]

certainly it can....You should have posted an example of the string.

You can extract the portion of the string using Left, Right or Mid and the convert it to a number using tonumber()

Eg. x = "aws123"

tonumber(right(x,3))

Jim Broadbent

The quality of the answer is directly proportional to the quality of the problem statement!