Hello Pierson, Thanks for your post.But how do I get the start and end position of the incident as the string is dynamic and start and end position cannot be hard coded. See below.
I have just outlined the requirement. The string which contain incident has dynamic values and maximum contains 10 ids.Where I have to count the no. incidents and then put individual incident to different field. Example : Temp_field = string string ="INC000123, INC000456, INC000789, INC000005" or "INC000123, INC000456, INC000789, INC000005,"INC000121, INC000453, INC000781, INC000002" field1="INC000123" . . . Field4="INC000121" Field5="NULL" . . Field10="NULL" or field1="INC000123" . . Field8="INC000002" Field9="NULL' Field10="NULL" what I have to do is to count no. of ids and then put individual ids to fields. The value of sting cannot be hard coded. it is always dynamic but the limit is 10 records. Basically what I want to do is to parse the string and extract the sub-string whenever it find the delimiter "," and then put the values to fields. Hope you have understood my requirement.And expect more suggestion from Lister's. Again,thanking in advance for all suggestion and help. Regards, Sanjay On Thu, May 2, 2013 at 6:11 PM, Pierson, Shawn < [email protected]> wrote: > 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" > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
