Parsing out digits

[lbolin]

I am wanting to check and see if the digit i have is 5 digits if it is longer than 5 digits I want to cut off the extra digits. 

Example:

544963 -----> 544963

928670000 -------> 92867

928675542 -------> 92867

72143 ------> 72143

[ShankerV]

Hi @lbolin 

Please find the expected output.

tonumber(Left(tostring([Field1]),5))

[ShankerV]

Hi @lbolin 

One more way to do this.

Many thanks

Shanker V

[binu_acs]

@lbolin One way of doing this

IIF(Length(toString([Digits])) >5 , toNumber(Left(toString([Digits]),5)), [Digits])