Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

REMOVING LEADING DIGITS IN A COLUMN

dunkindonut7777
8 - Asteroid

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 🙂

5 REPLIES 5
NexBK
7 - Meteor

NexBK_0-1613450564705.png

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

grazitti_sapna
17 - Castor

Hi @dunkindonut7777 ,

You can try this.

grazitti_sapna_0-1613450880014.png

Thanks.

 

Sapna Gupta
Emil_Kos
17 - Castor
17 - Castor

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
5 - Atom

Thanks for the solution!

olsenprime
5 - Atom

Great spot! Thanks!

Labels
Top Solution Authors