Gary, Why does RPAD not work? AKA: RPAD($field$,5,"0")
I must not understand something about your question....? -- Carey Matthew Black Remedy Skilled Professional (RSP) ARS = Action Request System(Remedy) Love, then teach Solution = People + Process + Tools Fast, Accurate, Cheap.... Pick two. On Fri, Sep 12, 2008 at 10:03 AM, Shoemaker, Gary <[EMAIL PROTECTED]> wrote: > ** > I am trying to do set a field to specific format using the functions but can > not get exactly what I want. It is a 5 character string and needs to end > up as a 5 character string. The pattern is that I leave all leading 0 and > pad right up to 3 - the number of leading 0 if leading is more than 1. > Any suggestion on this would be greatly appreciated. > 12566 goes to 12000 > 11456 goes to 11000 > 10456 goes to 10000 > 09456 goes to 09000 > 08456 goes to 08000 > 00956 goes to 00900 > 00096 goes to 00090 > 00009 goes to 00009 > > > > > > > However beautiful the strategy, you should occasionally look at the results. > Sir Winston Churchill _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
