Sanjay, you are going to need something in the range of 11 filters...one of them that does a STRSTR to find the location of the , then one filter for each of the field1-10. Put them in a filter guide. Fire the filter that finds the , then, if that int is > 0 use SUBSTR to grab the first value, storing it in field 1 and removing that value from your temp field, then call your find the , filter, rinse and repeat untill no , is found. If no , is found, exit the guide.
On Thu, May 2, 2013 at 7:06 AM, kanhu mohapatra <kanhu.san...@gmail.com>wrote: > ** > 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 < > shawn.pier...@energytransfer.com> 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: >> arslist@ARSLIST.ORG] On Behalf Of sanjay >> Sent: Thursday, May 02, 2013 7:35 AM >> To: arslist@ARSLIST.ORG >> 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" >> > > _ARSlist: "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"
