Hello Lister's/sagar, Thanks for your post it really a nice idea to implement. I am able to achieve my requirement.
Thanks for all your helpful suggestion and post. . Have a great day and nice weekend too... Regards, Sanjay On Fri, May 3, 2013 at 9:05 AM, Sagar Valse <[email protected]>wrote: > ** > Hi, > > I have created 2 forms 1 display only form containing a field(desc) to > store string "INC000123, INC000456, INC000789, INC000005" > ,a temp field(temp) and another regular form to store the incident tickets. > > 1.Created alink Alink1 with actions > a.Set desc=$default$ > b.Set temp=STRSTR($desc$, ",") > c.callguide AlinkGuide > AlinkGuide: > 1. Label "Start" > 2. Call alink Alink2 > if 'temp' != "-1" > i. Push in form 2 > incno= SUBSTR($desc$, 0, $temp$ - 1) > ii.Set desc=SUBSTR($desc$, $temp$ + 1, LENGTH($desc$)) > iii. Go to guide label Start. > else > i.Go to guide label End. > 3. Label "End" > d.Pushfield in form 2 > incno=desc > > Thanks and Regard, > Sagar Valse > > > On Thu, May 2, 2013 at 7:53 PM, jayesh panchal <[email protected]>wrote: > >> ** >> >> Have you tried using LEFTC function in set field action???.it will >> extract substrings and u can set into different field. >> >> Regards >> Jayesh >> On May 2, 2013 6:05 PM, "sanjay" <[email protected]> wrote: >> >>> 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" >>> >> _ARSlist: "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"
