extract only last 8 digits of a 9 digit V_WString

[nmotiani]

Hi I need help building logic for extracting only last 8 digits of a 9 digit V_WString

Example: Dealer Number = 123456789

Desired Result of Dealer Number = 23456789

[PhilipMannering]

You can use,

right(tostring([My_Field]), 8)

[Bren_Spill2]

@nmotiani - Right([String], 8)

[terry10]

ToNumber(right(ToString([Field1]),8))

[terry10]

Or you could use Regex Replace