White SpaceMark, During the time of submit a modify, In 3 Set Fields actions in the following order 1) Use LTRIM to remove any white spaces to the left of the string E.g. LTRIM($EmailAddresses$) 2) Use RTRIM to remove any white spaces to the right of the string E.g. RTRIM($EmailAddresses$) 3) Use REPLACE to replace " " with a ";" E.g. REPLACE($EmailAddresses$, " ",";")
You could do that whole operation with one nested Set Field action REPLACE(RTRIM(LTRIM($EmailAddresses$)), " ",";"). I think nested may be better performance-wise during a modify all operation or if you are using this operation in an Escalation.. Cheers Joe -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Brittain, Mark Sent: Monday, March 10, 2008 3:31 PM To: [email protected] Subject: White Space ** HI All, I am having a challenge with white space in emails. If a use selects multiple email addresses from a menu, there is a white space. Of course this barfs when the email goes out. Is there a way to replace the white space on submit with a semi-colon. Thanks Mark Mark Brittain ESM Remedy Developer NaviSite Inc. 315-453-2912 x5418 (office) 315-317-2897 (cell) This e-mail is the property of NaviSite, Inc. It is intended only for the person or entity to which it is addressed and may contain information that is privileged, confidential, or otherwise protected from disclosure. Distribution or copying of this e-mail, or the information contained herein, to anyone other than the intended recipient is prohibited. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
