Get last two charcaters of a number value

[salvuccicarlos]

Hello, I’m trying to get the last two numbers of a value I get from a query

Eg, that is my value

I need to get the 08 as a number. I’ve already tried this:

It didn’t work

[ben]

Slice is used for arrays. Yours is the first value in an array, hence not the array itself.

Use Sub or Sub String Between instead

Edit: see:

Array.prototype.slice()

String.prototype.substring()

[salvuccicarlos]

I don’t know if the sintaxis is ok, but I believe it’s not because it doesn’t work.

[Teodor]

Hello,
Just use the SUB formatter option, it will generate the right code and files for you …

[salvuccicarlos]

I´m getting this error:

This is the expression:

I need to extract the number as number, because afterwords I have to sum it to another number.

[Teodor]

You will need to first convert the value to string, apply substring, then convert back to number

.toString().substr(2, 2).toNumber()

[salvuccicarlos]

Excellent! But I’ve got other problem…

Some of the codes have 4 digits, an other have 5 digits. Form all codes, i only need the last two.

For eg: if I have the number 10001 using “substr(3, 2)” extracts 01. But in 1001 extracts only 1 (and I need 01)

[Teodor]

Then substract the last two:

substr(-2, 2)

This will always start 2 digits from the end

[salvuccicarlos]

Very helpful! Thank you very much