Please try the below approach
Assume that you have a field to capture the string. I call it as field "X" 1. Have a duplicate field A to keep your String for manipulation. 2. Have a field to keep your separator called field "B" (here it is ";") 3. Have another field called "C" (Integer) to enter separator position 4. Have a Field "D" to extract your Name Actions a) Have the same field value of X in A FLT-1 b) Find the position of your separator--- by using a set field action (CURRENT TRANSACTION) Field C= STRSTR($A$, $B$) c) Collect the first name from the string --- by using a set field action (CURRENT TRANSACTION) Field X= LEFT($A$, $C$) d) Remove the fist name from Name string---by using a set field action (CURRENT TRANSACTION) Field A= SUBSTR($A$, $C$ + 1) e) Empty the field X-- by using a set field action (CURRENT TRANSACTION) Field X= $NULL$ FLT-2 f) Check for negative value in Field C if so set filed X with the value A and set C= 0 FLT-3 g) Loop the actions (with if condition C is not equal to 0) b),c),d),e) by using the action GO TO (Execution order) (actions b),c),d),e) are in single FLT-1) I'm not sure if it is your complete solution but this may help you to implement... :-) Siraj P M ________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Ferreira, Frans F Sent: Monday, October 01, 2007 11:14 AM To: [email protected] 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___ This message contains information that may be privileged or confidential and is the property of the Capgemini Group. It is intended only for the person to whom it is addressed. If you are not the intended recipient, you are not authorized to read, print, retain, copy, disseminate, distribute, or use this message or any part thereof. If you receive this message in error, please notify the sender immediately and delete all copies of this message. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
