Account number formatting

[tiverson]

I have account numbers that need to be shortened with certain criteria.  

First, if the full Account is not 8 digits, a zero needs to be added to the account (Adj Account) to make it a full 8 digits.

Second, to create the Short Acct, I need to return a minimum of 3 numbers.  The Short Acct ends before the first zero after a minimum of 3 numbers are returned.

Account     Adj Account          Short Acct

1230012        01230012               0123

1300010        01300010               013

20200012      20200012               202

[chuckleswk · Accepted solution]

You can use the following formulas to generate the desired results:

Adj Account: PadLeft(tostring([Account]), 8, '0')

Short Acct: left([Adj Account],3)