REMOVING LEADING DIGITS IN A COLUMN

[dunkindonut7777]

Hi Can you help me with this one?

I want to remove the leading digits of a character in a column. 

From this:

Period

001

1207

1208

To this:

Period

01

07

08

I would like to retain the last two digits of a column.

Thank you 🙂

[NexBK]

You can succeed by using the "Right" function in the Formula Tool.

[grazitti_sapna · Accepted solution]

Hi @dunkindonut7777 ,

You can try this.

Thanks.

[Emil_Kos · Accepted solution]

Hi @dunkindonut7777,

The only thing that you need to remember is that your data type needs to be a string. If it wouldn't be a string you would need to use something like this:

Right(tostring([Period]), 2)

[olsenprime]

Thanks for the solution!

[olsenprime]

Great spot! Thanks!