to number

[leburg]

I have a text field that is supposed to contain numeric data that I will need to convert to numeric to sum up. I managed to deal with odd negative notation and for the most part perform the conversion neatly...however...human error in data input throws a wrench into my plan, here and there. Problem is when a non-numeric string is encountered the report aborts with an error message stating non-numeric data...

How to get around it or correct this situation is what I'm asking...many thanks in advance for pointers or links.

 

[lbass]

You could try using val()instead of tonumber(). Val() would capture the values of numbers at the beginning of the string only though. Otherwise, you should show samples of the variation in the field, and also indicate whether the field can be null.

-LB

 

[Madawc]

Try something like

if not isnull({your.field})
and NumericText({your.field})
then Tonumber({your.field})

This is based on Crystal 10. It also helps to give your Crystal version - 8, 8.5, 9, 10, 11 or whatever.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[leburg]

numerictext ! check

Thanks, datildo!

Thank you both...