LPADC(RTRIM(LTRIM($Request Number$)), 15, "REQ000000000000") The RTRIM() is there to handle the situation where a user pastes a number in from Excel. LTRIM is there just for good measure. If you think someone might type "REQ4567", could put REPLACE($Request_Number$,"REQ","") in the inner most set of parenthesis.
Hope that helps, Thad On Wed, Jul 1, 2015 at 11:26 AM, Atul Vohra <[email protected]> wrote: > ** > > Hi > > I am looking for a way to do the following (in an AL): > > Example -- User types in Request ID: 4567 > > AL: sets Request ID = REQ000000004567 > > So depending on what was typed we pad it with REQ and some 0s the length > is 15. > > > > Thanks > > Atul > > > _ARSlist: "Where the Answers Are" and have been for 20 years_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
