Hi Can you help me with this one?
I want to remove the leading digits of a character in a column.Â
From this:
To this:
I would like to retain the last two digits of a column.
Thank you 🙂
Hi @dunkindonut7777 ,
You can try this.
Thanks.
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)
You can succeed by using the "Right" function in the Formula Tool.
Thanks for the solution!
Great spot! Thanks!