Re: White Space
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: arslist@ARSLIST.ORG 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: arslist@ARSLIST.ORG Subject: Re: White Space ** Just before the Notify action to send the e-mail, do a 'Set Field' action: REPLACE ($$, " ", ";"). 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"
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: arslist@ARSLIST.ORG Subject: Re: White Space ** Just before the Notify action to send the e-mail, do a 'Set Field' action: REPLACE ($$, " ", ";"). 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. __Platinum Sponsor: www.rmsportal.com <http://www.rmsportal.com/> ARSlist: "Where the Answers Are" html___ __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Re: White Space
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: arslist@ARSLIST.ORG 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"
Re: White Space
Just before the Notify action to send the e-mail, do a 'Set Field' action: REPLACE ($$, " ", ";"). 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.* > > __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
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"