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.