# Keeping the length of the record constant

Options

I am looking for a solution to keep the length of the record constant to 10 digits.

For ex if I have 7 records like this 1) 1234567

2) 123456

3) 12345

4) 1234

5) 123

6) 12

7) 1 Then I need to achieve 1) 0001234567 2) 0000123456 3) 0000012345 4) 0000001234 5) 0000000123 6) 0000000012 7) 0000000001.

I can achieve this in excel by using REPT function but looking for solution in Anaplan. Any help greatly appreciated.

Options

Give this a try:

right("00000000"&line item,10)

Options

Follow the same mentioned by Rob
Jsut give try by using like "D" & right("00000000"&line item,10)

• Options

Thanks for looking into my request @rob_marshall above formula might help me to think in a different way to meet my requirement.

But my actual requirement was, suppose If i have the records like 1) 1, 2) 12, 3) 123, 4) 1234 then I need to achieve 1) D000000001 2) D000000012 3) D000000123 4) D000001234 etc.

Sorry for not making clear in my earlier post.

Thanks

• edited June 26
Options

@RaghuMulki , first identify the length of the record and then add the zero's in the prefix for the remaining character.

• edited June 26
Options

Thanks everyone. we could able to achieve by using the solution suggested by Rob and Ashutosh