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