SOLVED
Reduce string to a certain amount of characters
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
Jholiday78
7 - Meteor
08-03-2022
05:09 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
Solved! Go to Solution.
Labels:
- Labels:
- Data Investigation
3 REPLIES 3
21 - Polaris
08-03-2022
05:16 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@Jholiday78
We can use the Right function and set the length to be 10.
08-04-2022
02:01 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Worked like a charm. Thank you!
21 - Polaris
08-04-2022
03:31 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@Jholiday78
Good to know it helps. 😁
![](/skins/images/5A278AAD67B5F68761E04A0A1AFFBB3D/responsive_peak/images/icon_anonymous_message.png)