TRIMMING THE FIRST TWO CHARACTERS

Question

Hello I have a data here that contains 10 characters and 8 characters. Some values has 10 characters and I want to remove the first two digits without touching the other 8 characters.

ID CodeExpected Output (New ID code)51515500025155000251515520005155200030300302303003021101803111018031706270050362700503

Basically, I just want to remove the first two characters. Can you help me with this one please?

caltang · Accepted Answer

Try this:

IF LEFT(ToString([ID Code]),2) IN ("51","70")
THEN RIGHT(ToString([ID Code],8)
ELSE ToString([ID Code])
ENDIF