reading last digit in number

[Yohn]

Hy!

I have to read last digit in 15-digit number. How do I do that?
I have to combine that last digit with one digit witch is in another table.

thx.

 

[Casper]

Maybe something like:

define variable iNumber as decimal decimals 0 no-undo.
 
assign iNumber = 123456789012345.
message
decimal(substring(string(iNumber),length(string(iNumber))))
view-as alert-box.

Casper

 

[KnutHandsome]

Maybe something like:

define variable iNumber as decimal decimals 0 no-undo.
 
assign iNumber = 123456789012345.
message
decimal(substring(string(iNumber),length(string(iNumber))))
view-as alert-box.

I would also parse, but how about

message iNumber MOD 10
view-as alert-box

 

[KnutHandsome]

I would also parse, but how about

message iNumber MOD 10
view-as alert-box

Oops. Think I just spotted a 15 digit flaw in my cunning plan.

 

[KrisM]

not if you use the int64 data type :awink:

 

[Casper]

not if you use the int64 data type :awink:

You're right, with int64 you get another limit:

DEFINE VARIABLE iNumber AS int64       no-undo.
 
assign iNumber = 9999999999999999999. /* 19 digits */
 
/* assign iNumber = 999999999999999999. /* 18 digits */ */
 
message iNumber modulo 10 view-as alert-box.

doesn't work.
But the cunning plan from knuthandsome is much nicer for a 15 digit number .

Casper