So you will always have four Incidents that you have to parse to pass to four specific fields? If so, you can do four different Set Fields on the same AL/Filter with different SUBSTRING values pulling each Incident out based on the start and stop values of the SUBSTRING function on the TMP_field. If it's a one to many type of list, then I wouldn't do that, nor would I write them to hardcoded fields. In that case it gets more complicated, but it's still easily doable.
Thanks, Shawn Pierson Remedy Developer | Energy Transfer -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of sanjay Sent: Thursday, May 02, 2013 7:35 AM To: [email protected] Subject: Extracting substring from string and putting the value in different field Hello Lister's, We have a requirement. Where we have a string which contains incident id's separated by ",". And my requirement is to extract the individual incident from the string and put the value to separate field. Example of the above requirement ========================== Input ====== TMP_field ="INC000123, INC000456, INC000789, INC000005" Output ======= Felid1 = INC000123 Felid2 = INC000456 Felid3 = INC000789 Felid4 = INC000005 and my question is how do I accomplish the above task. Please help me out to accomplish the above requirement. Many thanks for all your suggestion and help in advance. Regards, Sanjay. -- View this message in context: http://ars-action-request-system.1093659.n2.nabble.com/Extracting-substring-from-string-and-putting-the-value-in-different-field-tp7588518.html Sent from the ARS (Action Request System) mailing list archive at Nabble.com. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years" Private and confidential as detailed here: http://www.energytransfer.com/mail_disclaimer.aspx . If you cannot access the link, please e-mail sender. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
