What is the best way to remove a decimal...such as 8.5 return "85" or 17.75 returns "1775."

I started using "Left" and "Right" and "Patterncount" and such, but do not have the best knack for this stuff. So if anyone has a few minutes.... much appreciated.

Mike

Hi Mike,

try:

filter(numberield; "0123456789")

:) )

I knew there was a better way!

Thanks!

You might want to include a minus in the filter options if you have any negative numbers. It also feels weird applying text calculation to a number to turn it from a true number into a text string which changes the meaning of the number.

But I'd probably do it this way: Substitute ( numField ; "." ; "" )

... which still bothers me because it changes the MEANING of that number. But oh well ... I can be overly fussy and anal at times. :crazy2:

It also feels weird applying text calculation to a number to turn it from a true number into a text string which changes the meaning of the number.

Yeah, I had a similar feeling. I got over it by thinking that it is not really being considered as a number in the first place, but text all the way -kind of like: Cat.Dog to CatDog.

What is it for, Mike?

HI..

It is for coding.... as a printer a page size might be 8.5 x 11...

the code should be 8511 and then a series of codes to define paper. Essentially for inventory and work orders.

I could see how you might wonder why I would want to strip a decimal out of a number.

Mike