How to remove the last digit?

[BK]

For example
125000 -> 125
55000 -> 55
34500000 -> 34500
182309000 -> 182309

I wanna get the above results
If the last 3 digits at the end are not 000, or if the value is 0
I want to ignore it.

I using commends a trim, left, right, remove, etc..
but I don't know

I want to know how to do it.

[TheDane]

It's not elegant, but you could do
Macro Macro2

Code:

Copy      Help

str number="55000"
str s
if s.right(number 3) = "000"
,int NumberLength = number.len - 3
,out s.left(number NumberLength)

[BK]

I solved problem.

thank you so much.

[Kevin]

Function Function9600

Code:

Copy      Help

str ss s results
s=
;125000
;55000
;2500
;34500000
;10000000000
;182309000
;990
foreach(ss s)
,if(findrx(ss ".*0{3}$" 0 1 results)>=0)  ;;finds numbers only that end in 3 zeros
,,results.replacerx("0{3}$" "") ;; removes the 3 zeros from the results of findrx
,,out results