Splitting of a string
Hi All I need to split the following string: vimals;appadmin;rianaj a filter must use the first logon id vimals and then appadmin and then rianaj etc. therefore it must split the string on ; I want to pass it to the E-Mail engine, which uses Hard returns to send a message to a list of people as per Email engine 700 documentation page 89 To specify one or more recipients, enter any of the following choices separated by hard returns (the server evaluates each line separately) in the User Name field: _ AR System user logins _ AR System groups _ Direct email addresses Any suggestions will be of great help. Regards Frans Ferreira Senior Technical Consultant African Legend Indigo Tel +27118086300 Mobile +27836263674 Fax +27118020797 Web www.alindigo.com BLOCKED::BLOCKED::http://www.alindigo.com __ Standard Bank Disclaimer and Confidentiality Note This e-mail, its attachments and any rights attaching hereto are, unless the context clearly indicates otherwise, the property of Standard Bank Group Limited and/or its subsidiaries (the Group). It is confidential, private and intended for the addressee only. Should you not be the addressee and receive this e-mail by mistake, kindly notify the sender, and delete this e-mail, immediately and do not disclose or use same in any manner whatsoever. Views and opinions expressed in this e-mail are those of the sender unless clearly stated as those of the Group. The Group accepts no liability whatsoever for any loss or damages whatsoever and howsoever incurred, or suffered, resulting, or arising, from the use of this email or its attachments. The Group does not warrant the integrity of this e-mail nor that it is free of errors, viruses, interception or interference. Licensed divisions of the Standard Bank Group are authorised financial services providers in terms of the Financial Advisory and Intermediary Services Act, No 37 of 2002 (FAIS). For information about the Standard Bank Group Limited visit our website http://www.standardbank.co.za ___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: Splitting of a string
Frans, If you only want to convert the string into a format that the email engine can use to send to multiple recipients, have you tried the REPLACE() function? Set Fields with something likeREPLACE($FieldName$, ;, |) *For this email I used the pipe symbol (|) in place of a return. Stephen Remedy Skilled Professional From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Ferreira, Frans F Sent: Monday, October 01, 2007 3:14 AM To: arslist@ARSLIST.ORG Subject: Splitting of a string Hi All I need to split the following string: vimals;appadmin;rianaj a filter must use the first logon id vimals and then appadmin and then rianaj etc. therefore it must split the string on ; I want to pass it to the E-Mail engine, which uses Hard returns to send a message to a list of people as per Email engine 700 documentation page 89 To specify one or more recipients, enter any of the following choices separated by hard returns (the server evaluates each line separately) in the User Name field: _ AR System user logins _ AR System groups _ Direct email addresses Any suggestions will be of great help. Regards Frans Ferreira Senior Technical Consultant African Legend Indigo Tel +27118086300 Mobile +27836263674 Fax +27118020797 Web www.alindigo.com BLOCKED::BLOCKED::http://www.alindigo.com __ Standard Bank Disclaimer and Confidentiality Note This e-mail, its attachments and any rights attaching hereto are, unless the context clearly indicates otherwise, the property of Standard Bank Group Limited and/or its subsidiaries (the Group). It is confidential, private and intended for the addressee only. Should you not be the addressee and receive this e-mail by mistake, kindly notify the sender, and delete this e-mail, immediately and do not disclose or use same in any manner whatsoever. Views and opinions expressed in this e-mail are those of the sender unless clearly stated as those of the Group. The Group accepts no liability whatsoever for any loss or damages whatsoever and howsoever incurred, or suffered, resulting, or arising, from the use of this email or its attachments. The Group does not warrant the integrity of this e-mail nor that it is free of errors, viruses, interception or interference. Licensed divisions of the Standard Bank Group are authorised financial services providers in terms of the Financial Advisory and Intermediary Services Act, No 37 of 2002 (FAIS). For information about the Standard Bank Group Limited visit our website http://www.standardbank.co.za __ __20060125___This posting was submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: Splitting of a string
Check out the REPLACE function. You may be able to replace the ; with cr without having to parse out the string. To enter the CR, you will need to open the expand box for the text, so in the box, the replace command would look like: REPLACE($EMAIL_ADDRESS_STRING$, ;, note the last double quote is on the next line. Mark From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Ferreira, Frans F Sent: Monday, October 01, 2007 2:14 AM To: arslist@ARSLIST.ORG Subject: Splitting of a string ** Hi All I need to split the following string: vimals;appadmin;rianaj a filter must use the first logon id vimals and then appadmin and then rianaj etc. therefore it must split the string on ; I want to pass it to the E-Mail engine, which uses Hard returns to send a message to a list of people as per Email engine 700 documentation page 89 To specify one or more recipients, enter any of the following choices separated by hard returns (the server evaluates each line separately) in the User Name field: _ AR System user logins _ AR System groups _ Direct email addresses Any suggestions will be of great help. Regards Frans Ferreira Senior Technical Consultant African Legend Indigo Tel +27118086300 Mobile +27836263674 Fax +27118020797 Web www.alindigo.com BLOCKED::BLOCKED::http://www.alindigo.com __ Standard Bank Disclaimer and Confidentiality Note This e-mail, its attachments and any rights attaching hereto are, unless the context clearly indicates otherwise, the property of Standard Bank Group Limited and/or its subsidiaries (the Group). It is confidential, private and intended for the addressee only. Should you not be the addressee and receive this e-mail by mistake, kindly notify the sender, and delete this e-mail, immediately and do not disclose or use same in any manner whatsoever. Views and opinions expressed in this e-mail are those of the sender unless clearly stated as those of the Group. The Group accepts no liability whatsoever for any loss or damages whatsoever and howsoever incurred, or suffered, resulting, or arising, from the use of this email or its attachments. The Group does not warrant the integrity of this e-mail nor that it is free of errors, viruses, interception or interference. Licensed divisions of the Standard Bank Group are authorised financial services providers in terms of the Financial Advisory and Intermediary Services Act, No 37 of 2002 (FAIS). For information about the Standard Bank Group Limited visit our website http://www.standardbank.co.za http://www.standardbank.co.za __ __20060125___This posting was submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: Splitting of a string
Hi, The CR in REPLACE may cause a problem, as it typically adds a SPACE after the CR. It looks right when you save the filter, but when you reopen it, the space is there. This may have been changed in newer releases of the ARSystem. One way to fix this would be to do something like this: Alternative 1. REPLACE($FieldName$, ;, LEFT( , 1)) Alternative 2. REPLACE(REPLACE($FieldName$, ;, xyzzy xyzzy), xyzzy, ) Best Regards - Misi, RRR AB, http://www.rrr.se Products from RRR Scandinavia: * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. * RRR|Translator - Manage and automate your language translations. Find these products, and many free tools and utilities, at http://rrr.se. Frans, If you only want to convert the string into a format that the email engine can use to send to multiple recipients, have you tried the REPLACE() function? Set Fields with something likeREPLACE($FieldName$, ;, |) *For this email I used the pipe symbol (|) in place of a return. Stephen Remedy Skilled Professional From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Ferreira, Frans F Sent: Monday, October 01, 2007 3:14 AM To: arslist@ARSLIST.ORG Subject: Splitting of a string Hi All I need to split the following string: vimals;appadmin;rianaj a filter must use the first logon id vimals and then appadmin and then rianaj etc. therefore it must split the string on ; I want to pass it to the E-Mail engine, which uses Hard returns to send a message to a list of people as per Email engine 700 documentation page 89 To specify one or more recipients, enter any of the following choices separated by hard returns (the server evaluates each line separately) in the User Name field: _ AR System user logins _ AR System groups _ Direct email addresses Any suggestions will be of great help. Regards Frans Ferreira Senior Technical Consultant African Legend Indigo Tel +27118086300 Mobile +27836263674 Fax +27118020797 Web www.alindigo.com BLOCKED::BLOCKED::http://www.alindigo.com __ Standard Bank Disclaimer and Confidentiality Note This e-mail, its attachments and any rights attaching hereto are, unless the context clearly indicates otherwise, the property of Standard Bank Group Limited and/or its subsidiaries (the Group). It is confidential, private and intended for the addressee only. Should you not be the addressee and receive this e-mail by mistake, kindly notify the sender, and delete this e-mail, immediately and do not disclose or use same in any manner whatsoever. Views and opinions expressed in this e-mail are those of the sender unless clearly stated as those of the Group. The Group accepts no liability whatsoever for any loss or damages whatsoever and howsoever incurred, or suffered, resulting, or arising, from the use of this email or its attachments. The Group does not warrant the integrity of this e-mail nor that it is free of errors, viruses, interception or interference. Licensed divisions of the Standard Bank Group are authorised financial services providers in terms of the Financial Advisory and Intermediary Services Act, No 37 of 2002 (FAIS). For information about the Standard Bank Group Limited visit our website http://www.standardbank.co.za __ __20060125___This posting was submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are