Use last 6 digits

I have a column where need to use the last 6 digits to join it up with another table.

For example:

84923123456

I just need

123456

And don’t need the start of the figure.

Do you know how I can extract this?

Hi there!

you can use modulo function in Math Formula node. Number of zeroes gives you number of last digits.
84923123456 % 1000000 = 123456 :wink:

Br,
Ivan

3 Likes