Good thinking.. Since you brought that up there might be more than a single white space too.. Maybe its good to run a loop to replace double white spaces with 1, until no double white spaces are found, then do what I suggested earlier (LTRIM, RTRIM and REPLACE for white spaces) and end with replacing double semi colons with one..
Joe -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Heider, Stephen Sent: Monday, March 10, 2008 4:09 PM To: [email protected] Subject: Re: White Space ** If I could add to this… Add another REPLACE() that surrounds the one below that changes “;;” into “;”. This is just in case there already are some semi-colons in the list of email addresses. Stephen Remedy Skilled Professional ---------------------------------------------------------------------------- -- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Ron Tavares Sent: Monday, March 10, 2008 3:48 PM To: [email protected] Subject: Re: White Space ** Just before the Notify action to send the e-mail, do a 'Set Field' action: REPLACE ($<your email address field>$, " ", ";"). I blieve this will do the trick. On 3/10/08, Brittain, Mark <[EMAIL PROTECTED]> wrote: ** 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. No virus found in this outgoing message. Checked by AVG. Version: 7.5.518 / Virus Database: 269.21.7/1323 - Release Date: 3/10/2008 11:07 AM _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
