Hi Mark For your purpose try the following
((($Trouble Ticket #$ + " ") + RPAD($Company$, LENGTH, " ") + " ") + $Status$ This LENGHT can be a constant or it can be calculated to be Max Lenght of Company Field. Thanks and Regards, Ganga Prasad Pattnaik, ( Remedy Skilled Professional ) On Tue, Mar 4, 2008 at 6:48 PM, Carey Matthew Black <[EMAIL PROTECTED]> wrote: > Mark, > > Be warned... your approach assumes that the user will be viewing the > output in a fixed width font. If they are using a variable width font > (like my gmail account uses) then the value will likely not align. > > If you really want formatting that is likely to be as you expect it, > then either send it in an attached PDF, or as HTML. I know of no > better solutions to deal with formatting issues than those two paths. > > -- > 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 Mon, Mar 3, 2008 at 2:17 PM, Brittain, Mark <[EMAIL PROTECTED]> > wrote: > > ** > > > > > > Hi All, > > > > I have an escalation that looks for Trouble Tickets that have not been > > touched in a week. When there is a match, I do a set fields to another > form. > > Then I have another escalation that emails out the results. The fields > > pushed are > > > > ((($Trouble Ticket #$ + " ") + $Company$) + " ") + $Status$ > > > > The problem is the Company name can be all different lengths, so the > result > > is wavy. Like this > > TT#01064088 Corporate Systems - Internal WorkInProgress > > TT#01077255 NaviSite, Inc. Assigned > > > > I would like it to be placed like this > > TT#01064088 Corporate Systems - Internal WorkInProgress > > TT#01077255 NaviSite, Inc. Assigned > > > > > > Is there a way to do that? > > > > Thanks > > Mark > > > > Mark Brittain > > ESM Remedy Developer > > NaviSite Inc. > > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
