Alteryx Designer Desktop Discussions

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

Reduce string to a certain amount of characters

Jholiday78
7 - Meteor

Greetings,

 

I am looking to reduce a customers account number to just 10 characters to join to another set of data where the account number is only 10 characters. 

It has leading zeros, so I need to keep some, but not all.  My main objective is to go from 12 characters to 10 characters.  Can this be accomplished in a formula tool?

 

Here is an example:

Customers#                   Desired Output

000036545705              0036545705

 

Jessica

3 REPLIES 3
Qiu
21 - Polaris
21 - Polaris

@Jholiday78 
We can use the Right function and set the length to be 10.

0804-Jholiday78.PNG

Jholiday78
7 - Meteor

Worked like a charm.  Thank you!

Qiu
21 - Polaris
21 - Polaris

@Jholiday78 
Good to know it helps. 😁

Labels
Top Solution Authors