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" <kanhu.san...@gmail.com> 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" > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
