Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

I need to pad a numeric string using a SharePoint calculated column. I have two fields, Sectiontxt and calcPadNum. For example, if a user enters 1.12.1 into Sectiontxt, I want calcPadNum to be 011201.

I know that IF(LEN(ModuleNum)<2,0&ModuleNum,ModuleNum) will test if the length of ModuleNum field is less than 2, and if it is, it will add a 0 before it.

*I am using MOSS 2007, and I read here that the MID function is not supported. Is there any other (functional) option that I can use?

I know that I could add the following fields to the list ModuleNum, SectionNum, Sub_SectionNum, and then pad the number that way, but I am trying to avoid having the user enter the same info in multiple fields.

Many Thanks!

share|improve this question
    
Okay, so I think it IS possible using the FIND() function, but it is going to be a seriously nested function... and nested functions are not my best. [link] (sharepoint.stackexchange.com/questions/29140/…) Anyone? –  jg100309 Oct 18 '13 at 15:57
    
Okay, so I'm back to my original plea. It looks like the FIND() function isn't going to help, since it only finds the first "." and doesn't go any farther, and there can be several "." that are entered. –  jg100309 Oct 18 '13 at 16:18

1 Answer 1

From your link it seems that you are using SP2010. This post indicates that MID() should work.

You might try &TEXT(ModuleNum,"00")

in place of

0&ModuleNum

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.